Page 74 - ICT_for_JHS_3_Classical

1. Outline the steps by which the serial no. (1, 2, 3, … 8) were generated without

typing them one by one.

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

2. What is the cell address for the following:

I. “Maths”

…………………………………………………………………………………

II. “Alhassan Ibrahim”

…………………………………………………………………………………

3. Write down the cell range in which “End of Year Examination”

was typed. ……………………………………..………………….

………………………

4. Write the spreadsheet formula that was used in computing the total value

“230” in cell G6. ..

……………………………………………………………………………..

5. Write the spreadsheet function used in computing the total value “609” in cell