Page 36 - My Own Workbook for CSEC Information Technology Examinations

My Own Workbook for CSEC® Information Technology Examinations
(b)
Complete the following table by writing names and examples of the different numeric formatting used in the worksheet. The first row has been completed for you.
Each cell in the range E6:E11 contains a formula which uses relative addressing only. Suggest the formula used for each of the following items:
(i) Registration Fee ...............................................................................................................................
(ii) Subject Fee ........................................................................................................................................
(iii) Oral Examination ........................................................................................................................
(iv) TOTAL DUE ...................................................................................................................................
(v) Registration % .................................................................................................................................
The formula in cell E8 was changed to a formula with mixed addressing—a combination of relative and absolute addressing—which referenced cells B7 and E3 respectively.
(i) State the formula to which cell E8 was changed. ...........................................................
(ii) State the effect on the value in cell E9 if the formula stated in (d)(i) was copied
to E9. ..................................................................................................................................................................
A pie chart is required to show the proportions of costs that make up ‘Total Due’. State the data range that would:
Name
Cell Reference
Cell Content
General
B7
11
E1
Comma, 2 decimal places
6.0%
(c)
(d)
(e)
(i) (ii) (iii)
be used for the pie chart ............................................................................................................. contain the values used for the pie chart slices .............................................................. contain the labels for the pie chart slices ............................................................................
73
9 789769
611337
Copyrighted material. All rights reserved.
IT-book-edited-8,3x11,7.indd 76
9/11/18 7:25 PM
DO NOT COPY THIS PAGE DO NOT COPY THIS PAGE DO NOT COPY THIS PAGE