WorksheetsYr7 Spreadsheet REVISION
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
Select the software we use in school to produce a spreadsheet ....
a)
b)
c)
d)
2.
What do formulas/functions always start with?
(a)
3.
Columns are ...
a)
The letters
b)
The numbers
4.
If I want to multiply the two numbers, what operator (symbol) will I use?
a)
+
b)
-
c)
*
d)
/
5.
What is the cell reference for the yellow cell?
(a)
6.
What formula would you use to add both of these numbers together? WRITE THE FORMULA.
(a)
7.
If you want to add borders to a range of cells, which icon would you choose?
a)
A
b)
c)
d)
e)
8.
If you want to merge together a range of cells, which icon would you choose?
a)
A
b)
c)
d)
e)
9.
Look at the spreadsheet shown. E7 has $ - what is this an example of?
a)
Absolute Cell Referencing
b)
Relative Cell Referencing
10.
A group of highlighted cells e.g. A1:C8 is called...
a)
A Cell Reference
b)
A Cell Range
c)
A Formula
d)
A Function
11.
SUM, MIN, and MAX are examples of what?
a)
Functions
b)
Formulas
12.
=B8+C8 and =E4*F4 are examples of what?
a)
Functions
b)
Formulas
13.
What does the AVERAGE function do?
a)
Finds the highest number
b)
Finds the lowest number
c)
Finds the total of a range of numbers
d)
Finds the middle value from the cells
14.
Select two types of formatting that have been added to the spreadsheet:
a)
Shading
b)
Merging Cells
c)
Borders
d)
Currency
e)
Right Align
15.
What is the function word has been used to find the total in I4?
(a)
100 %
