Name:
Class:
Consider the spreadsheet below.
(a) What is a spreadsheet application and give one example of a spreadsheet application? (2 marks)
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
(b) Define the following terms and give an example of each from the graphic above:
(i) Cell (2 marks)
______________________________________________________________________________
______________________________________________________________________________
_____________________________________________________________________________
(ii) Range (2 marks)
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
(c) Describe clearly the formatting of cell A1. (2 marks)
______________________________________________________________________________
______________________________________________________________________________
(d) Describe the formatting applied to the data in cells C3:C9. (2 marks)
______________________________________________________________________________
______________________________________________________________________________
(e) State the formulae that would have been placed in
(i) D10 (3 marks)
______________________________________________________________________________
(ii) D11 (3 marks)
______________________________________________________________________________
(f) The owner of the vegetable-mart decides that he wants the rows reorganized so that they are in
ascending order by ITEM. Explain how he could do this using features of the spreadsheet software.
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
(2 marks)
(g) In creating this spreadsheet, the owners want to make sure that the data entered is error free. Describe
one approach towards ensuring this.
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
(2 marks)
TOTAL 20 marks
