Font size
WorksheetsS3 Spreadsheets - Absolute Cell References
Total questions: 10
Worksheet time: 5mins
There are 2 types of cell reference, absolute and relative. Select the relative cell reference.
A
A7
7
$A$7
Which formula uses an absolute cell reference?
=A1+B2
=A1+$B$2
=A1*B2
=A1/B2
Which symbol makes a cell reference absolute?
@
&
#
$
Absolute cell references should be used when possible to avoid having to make multiple updates when a key value changes.
True
False
Absolute cell references do not change when replicated (filled down).
True
False
Which of these formula will calculate 10% of an amount.
= 10% / B3
= B3 / 10
= 10% * B3
= B3 * 5%
Which key on the keyboard do we press to make a cell reference absolute?
F2
F4
F6
F8
What are the correct terms for copying a formula to a range of cells. (You may select more than one answer.)
Fill across
Copy and Paste
Fill down
Replicate
By naming a cell you no longer need to do what in a formula?
Replicate it
Add an absolute cell reference
Put the = sign at the start
What do we mean by Commission?
A sales person's basic pay
Money earned based on the amount of sales made
