WorksheetsBasic Spreadsheets Check Point
Total questions: 6
Worksheet time: 4mins
Name
Class
Date
1.
What symbol must you use at the beginning of a cell when you want to use a function or a formula in that cell?
a)
+
b)
=
c)
/
d)
*
2.
Which function tells you the maximum value in a range?
a)
Max
b)
=Maximum
c)
MaximumValue
d)
=MAX
3.
Which function tells you the minimum value in a range?
a)
=MIN
b)
MIN
c)
=MINIMUM
d)
MINIMUM
4.
Choose two methods in which you can add values together in a spreadsheet. (Make sure that you choose 2!!)
a)
A1+B1
b)
=SUM(_:_)
c)
=A1+B1
d)
=1A+1B
5.
Give the cell references for the following range:
The first ten cells of column B
a)
=B1+B10
b)
=B1:B10
c)
=1B:10B
d)
B1:B10
6.
Give the cell references for the following range:
The cells in rows 15-20 in column A
a)
=A15:A20
b)
A15 - A20
c)
=15A-20A
d)
=15A:20A
100 %
