1. The main use of a spreadsheet program is to
create document layouts for newspapers, adverts, brochures and leaflets
store numerical data and perform calculations
organise collections of data or information

2. The columns in a spreadsheet are
numbered
lettered
numbered and lettered

3. Cell A5 contains a
value
label
formula

4. Cell F8 contains a
value
label
formula

5. What type of data would be used for a column heading in a spreadsheet?
functions
numbers
text

6. One cell on a spreadsheet has a thick box around it to show where the typing will go. This cell is called the
active cell
working cell
current cell

7. Which of the following would be used to calculate VAT in a column in a spreadsheet?
digit
formula
character

8. What does F14 = SUM(F7:F11) mean?
Multiply the values in the cells F7 to F11 and present the result in cell F14
Average the values in the cells F7 to F11 and present the result in cell F14
Total up the values in the cells F7 to F11 and present the result in cell F14

9. What does this icon on a spreadsheet toolbar mean?

average
autosum
function

10. What is the feature of spreadsheets that allows common tasks to be automated?
functions
macros
applets

Score =
Correct answers: