NEW
Font size
S
M
L
XL
WorksheetsEXCEL
Total questions: 15
Worksheet time: 6mins
Name
Class
Date
1.
Part # 523456 is entered on a spreadsheet, is this a label or a value?
a)
Label
b)
Value
2.
When is a cell considered active?
a)
it is never considered active
b)
when you click on it
c)
cells can't be active
3.
Rows are which of the following:
a)
vertical
b)
horizontal
4.
Columns are vertical.
a)
True
b)
False
5.
What does every formula or function start with?
a)
!
b)
@
c)
#
d)
=
6.
What is the formula for =sum(B2:B9)
a)
B1+B2+B3+B4
b)
=B2+B3+B4+B5+B6+B7+B8+B9
c)
B2+B3+B4+B5+B6+B7+B8+B9
d)
=B1+B2+B3+B4
7.
What is the formula to find the lowest number in cells C1:C4?
a)
=average(C1:C4)
b)
=max(C1:C4)
c)
=min(C1:C4)
d)
=sum(C1:C4)
8.
What would I use to combine cells A1:A9?
a)
adjust column width
b)
merge
c)
wrap text
9.
$5.25 is entered on a spreadsheet, is this a label or a value?
a)
label
b)
value
10.
What should you do if you see #### on your spreadsheet?
a)
merge cells
b)
wrap text
c)
adjust column width
11.
What instructs the software to perform a calculation?
a)
value
b)
label
c)
formula
12.
What symbol will tell spreadsheet software not to treat cell data as a value?
a)
=
b)
+
c)
'
d)
:
13.
What is the Order of Operations?
a)
PEDMAS
b)
PSMADE
c)
PMSADE
d)
PEMDAS
14.
An absolute cell reference means the cell value remains constant when copied to another cell or used in a formula.
a)
True
b)
False
15.
A relative cell means that the cell value changes "relative" to the cell in which it is copied.
a)
True
b)
False
Reset
