NEW
Font size
S
M
L
XL
WorksheetsYear 10 Plenary SUM,MAX, MIN, AVERAGE
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
I can find the lowest number in a range with the ... function
a)
MIN
b)
MAX
c)
AVERAGE
d)
COUNT
2.
When you key a formula in a spreadsheet what do you key in first?
a)
Subtraction sign
b)
Equal Sign
c)
Addition sign
d)
Division sign
3.
What function is used to add more than 2 cells?
a)
+
b)
=
c)
SUM
d)
( )
4.
Columns are identified using _______?
a)
Numbers
b)
Letters
c)
Numbers & Letters
d)
Cells
5.
Rows are identified using ________?
a)
Numbers
b)
Letters
c)
Numbers & Letters
d)
Cells
6.
SUM, AVERAGE, MAX and VLOOKUP are examples of what?
a)
Functions
b)
Tables
c)
Formulae
d)
Statistical tools
7.
What formula would you use to find out the highest number within a range of cells?
a)
=Max
b)
=Min
c)
=High
8.
=SUM(A5:A14) Could also be calculated in Excel by which formula?
a)
=A5+A14
b)
=SUM A5:A14
c)
=A5+A6+A7+A8+A9+A10+A11+A12+A13+A14
d)
=A6+A13
9.
Which feature allows a formula to be copied to another cell yet adjusting the cell reference to match?
a)
Copy and paste
b)
Autofill
c)
Sum
d)
Fill
10.
Which function calculates the average number in a range?
a)
Average
b)
sum and divide by the number
c)
Autosum
d)
Sum
Reset
