Spreadsheets
By Computing Department
Knowledge checks on GPP Spreadsheets.
1. The address of the cell with the word ITEMS in it is
A5
B5
A6
G3
2. In which column are the totals to be stored?
A
B
E
F
3. What is stored in cell E6?
A text label
a number
a formula
4. The completed formula to work out the averages is
= average(D6..D9)
=average(C6..C9)
=average(C6..D9)
5. If I wanted to put in the name ' Andrew Donald McPherson' in cell E2, how could I fit it all in?
Insert a row
Widen the column by 'dragging' the column edge.
Insert a column
6. How could I make room for an entry for INKJETS between Desktops and Laptops?
insert a column
insert a cell
7. What would you use this window for?
Choosing how to print your spreadsheet
Choosing a type of chart for your spreadsheet data.
Choosing a logo for your file
8. Charting spreadsheet data helps you
print the data in a logical order
make good use of your colour printer
display the spreadsheet data in an attractive and meaningful way.
9. Automatic calculation means
the spreasheet acts like a calculator.
the user has to enter commands to make the spreadsheet performs all calculations.
the spreadsheet performs all its calculations held in its formulae automatically.
10. If you want to make sure that the contents of a cell are not changed by accident, you switch on
cell security
contents protection
cell protection
cell firewall
11. Which function would you use to find out the highest score in a class test?
Minimum
Average
Maximum
12. Which function would you use to find the lowest score in a class test?
13. If there are 20 pupils sitting a test, this function will add up the 20 scores and then divide them by 20.