Page 39 - My Own Workbook for CSEC Information Technology Examinations
P. 39
Spreadsheets SECTION 5
(f) The school offers a payment plan for students on welfare. Students are allowed to pay the total due in six equal payments if the total due is more than $1,000. Create an advanced arithmetic formula that determines whether the student is qualified for a payment plan. If qualified, determine the monthly payment otherwise display “Not qualified”.
..................................................................................................................................................................................
8. Consider the following worksheets which were prepared by the administrative office at a school. Worksheet 1 is a reference sheet; it is read-only and contains the registration numbers and names of exam candidates. Worksheet 2 is a sheet being prepared to determine the total fees that will be financed by payment plans.
1 2 3 4 5 6 7 8 9 10
AB
Registration7Number
1127
1128
1129
1130
1131
1132
1133
1134
1135
Candidate7Name
Bennett,7Yanique
Hanna,7Cher
Jones,7Joanna7
Bennett,7Nigel
Lloyd,7Joel
Morgan,7Lacey
Morgan,7Kathleen
Parker,7Leo
Parker,7Blanche
1
2
3
4
5
6
7
8
9
10
11
12
Totals
ABCD
Registration9Number
1130
1127
1128
1129
1131
1133
1132
1135
1134
Total9No9 Subjects
8
7
7
8
9
9
11
10
10
Total9Fees9 Due
999991,190.00
99999999975.00
999991,020.00
999991,190.00
999991,360.00
999991,360.00
999991,655.00
999991,530.00
999991,530.00
Payment9Plan9 Requests
Y
Y
Y
Y
Y
Y
Worksheet 1
Worksheet 2
(a) The Administrative Assistant wants to automatically insert each candidate’s name in Worksheet 2 by referencing the data in Worksheet 1.
(i) Name the pre-defined system function that is ideal to accomplish this.
..................................................................................................................................................................
(ii) Assuming a column was inserted between columns A and B of Worksheet 2, write the formula that would insert the Candidate Name for the candidate Registration Number ‘1130’.
.................................................................................................................................................................. (b) Row 12 will contain summary data. Write formulae to:
(i) count the number of candidates ..................................................................................................................................................................
IT-book-edited-8,3x11,7.indd 77
9/11/18 7:25 PM
Copyrighted material. All rights reserved.
9 789769
611337
74
DO NOT COPY THIS PAGE DO NOT COPY THIS PAGE DO NOT COPY THIS PAGE
