Page 40 - My Own Workbook for CSEC Information Technology Examinations

My Own Workbook for CSEC® Information Technology Examinations
(c)
(ii) compute the Total Fees Due
................................................................................................................................................................... The Administrative Assistant just realized that one row of data was omitted from
the worksheet that is sorted by Candidate Name.
(i) Outline the process to insert a row of data in the correct position.
................................................................................................................................................................... ................................................................................................................................................................... ...................................................................................................................................................................
(ii) Describe the effect that the insertion of the data will have on the formulae in row 12.
...................................................................................................................................................................
...................................................................................................................................................................
The Administrative Assistant wants to extract the data for persons that qualify for the payment plan from the list of persons that have requested a plan. Candidates that qualify have Total Fees Due in an amount greater than $1,000 (and have made a request indicated by a “Y” in the ‘Payment Plan Requests’ column).
(d)
(i)
Write the criteria that would be used to filter the required data.
ABCD
1 2 3 4
Registration3Number
Total3No3 Subjects
Total3Fees3 Due
Payment3Plan3 Requests
(ii)
State the rows that would be included in the results. ................................................................................................................................................................... ................................................................................................................................................................... ...................................................................................................................................................................
75
9 789769
611337
Copyrighted material. All rights reserved.
IT-book-edited-8,3x11,7.indd 78
9/11/18 7:25 PM
DO NOT COPY THIS PAGE DO NOT COPY THIS PAGE DO NOT COPY THIS PAGE