WorksheetsExcel Cell References
Total questions: 28
Worksheet time: 14mins
Name
Class
Date
1.
Which formula has an absolute cell reference?
a)
=A1+$B$2
b)
=A1+B2
c)
=A1*B2
d)
=A1/B2
2.
Which symbol is used for Absolute Cell Reference?
a)
#
b)
$
c)
=
3.
In the formula below, which references will update when copied? =$D$3+$E5
a)
Column D
b)
Row 3
c)
Column E
d)
Row 5
4.
In the formula, which cell reference is absolute? =$D3+E5
a)
Column E
b)
Row 5
c)
Column D
d)
Row 3
5.
In the formula, which reference is relative, meaning it will update if copied or use of Autofill? =$D$3+E$5
a)
Column D
b)
Row 3
c)
Row 5
d)
Column E
6.
Which formula below contains a relative cell reference?
a)
=$A$1+$B$2
b)
=A$1+$B$2
c)
=$A$3+$B$3
$
$
7.
Which of the following has a cell reference?
a)
5%
b)
=4*3.7
c)
=G4/E3
d)
sub-total
8.
Which of the following formulas includes an absolute cell reference?
a)
=B1/$B$25
b)
=B1/B25
c)
=B1*#B#25
d)
=AVERAGE(B1:B25)
9.
Which of these formulas uses relative cell references?
a)
=5*10+20
b)
=$A$10/100
c)
=F18+F19/2
10.
Unlike _________ references, _________ references do not change when copied or filled.
a)
Absolute, Relative
b)
Relative, Absolute
11.
An absolute cell reference includes _____ in the reference name.
a)
a dollar sign
b)
a percent sign
c)
a formula
d)
a function
12.
A workbook is made up of ________________.
a)
word documents
b)
worksheets
c)
databases
d)
tables
13.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
14.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
15.
#### means you entered a formula incorrectly.
a)
True
b)
False
16.
What is the Excel symbol for multiplying?
a)
/
b)
( )
c)
X
d)
*
17.
######### means
a)
I entered the formula wrong
b)
The cell needs to be bigger
c)
hashtag, hashtag, hashtag
d)
Something is incorrect
18.
If you want to subtract two numbers in a formula, which formula would be correct?
a)
=1.2*3
b)
=e3+e7
c)
=A2-30
d)
-E7=A3
19.
This operator symbol is for what type of operation? /
a)
addition
b)
subtraction
c)
multiplication
d)
division
20.
What term refers to mathematical equations used in Excel to perform calculations?
a)
Format
b)
Summations
c)
Cell
d)
Formulas
21.
Excel uses the Order of Operations
a)
True
b)
False
22.
The Order of Operations means to do what first?
a)
section in Parentheses
b)
subtraction
c)
work from left to right
d)
addition
23.
What is the main purpose of using cell references when doing formulas & functions?
a)
So you don't have to redo the math if something changes
b)
It feels fancier therefore you're smarter
c)
It's the ONLY way to get the right math answer
d)
Confuse students in Info Tech class
24.
What symbol is used to designate an absolute cell reference?
a)
$
b)
!
c)
@
d)
#
25.
Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.
a)
True
b)
False
26.
Which of the following is a CORRECTLY keyed formula?
a)
A1=A2
b)
7+3
c)
=7+3
d)
==A1/A2
27.
Which of the following is an INCORRECTLY typed formula?
a)
=A1/A6
b)
=8*4
c)
A1/A2=
d)
=SUM(A1:A4)
28.
$b$17 is what type of reference?
a)
absolute
b)
relative
c)
mixed varying column
d)
mixed varying row
100 %
