The table below shows a spreadsheet for household expenses created by a student.
A 
B 
C 
D 

1 
Item 
Quantity 
Cost price 
Total cost 
2 
Shirts 
3 
$25 

3 
Shoes 
4 
$30 

4 
Drinks 
7 
$12 

5 
Gas 
2 
$10 

6 
Rice 
5 
$13 

7 
//////////////  ////////////  ///////////  ///////// 
8 
Maximum Quantity 

9 
Minimum Quantity 

10 
Total cost of all the items 
(a) Write down the formula/function for each of the following cells.
i. D2: =B2*C2
ii. B8: =MAX(B2:B6)
iii. B9: =MIN(B2:B6)
iv. D10: =SUM(D2:D6) / =D2+D3+D4+D5+D6
(b) Pick one from the table above for:
i. Label: Rice. (Other answers: Item, Quantity, Cost Price, Total Cost, Shirts, Shoes, Drinks, Gas, Rice, Maximum Quantity, Minimum Quantity, Total cost of all the items)
ii. Numbers: 3. (Other answers: 4, 7, 2, 5, 25, 30, 12, 10, 13)
(c) Using a pencil, shade cells A7:D7. (SEE TABLE ABOVE)
(d) If the display in cell C2 appears as “######’
i. What does this mean?
The cell is not wide enough to display its item.
ii. How would you overcome this problem?
By widening the column so that the item can be displayed properly.
(e) Give one example of spreadsheet application.
Microsoft Office Excel