Information Technology
Microsoft Excel theory
Grade 9
1. Answer the following questions based on the spreadsheet given below:
Howell’s Limited
A B C E F G
1 FIRST LAST YEARS RATE FEES
2 Ray Charles 3 100 $300.00
3 Imran Ally 4 100
4 John Persaud 5 200
5 Michael Scott 6 200
6 Mary Allen 7 200
7 TOTAL
8 MAX
(a) Resave the document as YourName_Exceltheory (1 mark)
(b) State the formatting feature applied to the title of the spread sheet. (1 mark) Merge
and center
(c) Write the function to use in cell G8 to determine the highest Fee. (2
marks)=MAX(G2:G6)
(d) What is the name of the feature in excel that can be used to automatically copy the
formula from G2 down to G6? (1mark) Auto fill
(e) Write the function that would be appropriate for Cell G7 to calculate the total fees.
(2 marks)=SUM(G2:G6)
(f) State the numeric data format which has been applied to Column G. (1 mark)
Currency format
Microsoft Excel theory
Grade 9
1. Answer the following questions based on the spreadsheet given below:
Howell’s Limited
A B C E F G
1 FIRST LAST YEARS RATE FEES
2 Ray Charles 3 100 $300.00
3 Imran Ally 4 100
4 John Persaud 5 200
5 Michael Scott 6 200
6 Mary Allen 7 200
7 TOTAL
8 MAX
(a) Resave the document as YourName_Exceltheory (1 mark)
(b) State the formatting feature applied to the title of the spread sheet. (1 mark) Merge
and center
(c) Write the function to use in cell G8 to determine the highest Fee. (2
marks)=MAX(G2:G6)
(d) What is the name of the feature in excel that can be used to automatically copy the
formula from G2 down to G6? (1mark) Auto fill
(e) Write the function that would be appropriate for Cell G7 to calculate the total fees.
(2 marks)=SUM(G2:G6)
(f) State the numeric data format which has been applied to Column G. (1 mark)
Currency format
