WorksheetsRelative, Mixed and Absolute Cell Reference
Total questions: 27
Worksheet time: 12mins
Name
Class
Date
1.
Which of the following has a cell reference?
a)
5%
b)
=4*3.7
c)
=G4/E3
d)
sub-total
2.
This operator symbol is for what type of operation? /
a)
addition
b)
subtraction
c)
multiplication
d)
division
3.
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
4.
This operator symbol is for what type of operation? /
a)
addition
b)
subtraction
c)
multiplication
d)
division
5.
What term refers to mathematical equations used in Excel to perform calculations?
a)
Format
b)
Summations
c)
Cell
d)
Formulas
6.
=Sum(A5:A10)
a)
Formula
b)
Function
7.
The Order of Operations means to do what first?
a)
section in Parentheses
b)
subtraction
c)
work from left to right
d)
addition
8.
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
9.
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)
10.
What symbol is used to designate an absolute cell reference?
a)
$
b)
!
c)
@
d)
#
11.
Which of these formulas uses relative cell references?
a)
=5*10+20
b)
=$A$10/100
c)
=F18+F19/2
12.
Unlike _________ references, _________ references do not change when copied or filled.
a)
Absolute, Relative
b)
Relative, Absolute
13.
$b$17 is what type of reference?
a)
absolute
b)
relative
c)
mixed varying column
d)
mixed varying row
14.
$b17 is what type of reference?
a)
absolute
b)
relative
c)
mixed varying column
d)
mixed varying row
15.
In the formula =A4*B2^3-F14, which operation is done first?
a)
*
b)
^
c)
-
d)
+
16.
In the formula =A4*B2^3-F14, which operation is done first?
a)
*
b)
^
c)
-
d)
+
17.
What does the term “relative” mean for a formula?
a)
The formula remains unchanged when it is moved.
b)
The formula is related to another spreadsheet.
c)
The formula is related to the cells before it.
d)
The formula changes based on its location.
18.
What does the term “absolute” mean for a formula?
a)
The formula remains unchanged when it is moved.
b)
The formula is related to another spreadsheet.
c)
The formula is related to the cells before it.
d)
The formula changes based on its location.
19.
What character is used to change a cell references from relative to absolute?
a)
$
b)
%
c)
*
d)
+
20.
In the cell reference $A5, what part of the cell reference would remain unchanged?
a)
Column A
b)
Row 5
c)
All cells in Column A
d)
All cells in Row 5
21.
In the cell reference B$5, what part of the cell reference would remain unchanged?
a)
Column B
b)
Row 5
c)
All cells in Column B
d)
All cells in Row 5
22.
Which formula has an absolute cell reference?
a)
=A1+$B$2
b)
=A1+B2
c)
=A1*B2
d)
=A1/B2
23.
Absolute Cell Reference means the cell is locked and will not update when copied or use of Autofill.
a)
True
b)
False
24.
In the formula, which cell reference is absolute? =$D3+E5
a)
Column E
b)
Row 5
c)
Column D
d)
Row 3
25.
Which formula below contains a relative cell reference?
a)
=$A$1+$B$2
b)
=A$1+$B$2
c)
=$A$3+$B$3
$
$
26.
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)
27.
An absolute cell reference includes _____ in the reference name.
a)
a dollar sign
b)
a percent sign
c)
a formula
d)
a function
100 %
