WorksheetsForm 3 Excel Referencing Quiz
Total questions: 15
Worksheet time: 13mins
What does a cell reference like B3 mean in Excel?
Column B, Row 3
Row B, Column 3
Cell number 3 in the list
A formula
What is an absolute reference in Excel?
A cell reference that can change when copied
A reference that includes only the row
A reference that stays the same when copied
A reference that shows an error
Which of the following is an example of an absolute reference?
A1
B2
$A$1
C$3
If you copy the formula =A1 + B1 from cell C1 to cell C2, what will the new formula be?
=A1 + B1
=A2 + B2
=A1 + B2
=C1 + D1
What is the difference between relative and absolute referencing?
What happens when you copy the formula =$A1 + B$1 to another cell?
Both references stay the same
Row and column always change
Only the fixed parts ($A and $1) stay the same
The whole formula becomes an error
Which symbol is used to make a reference absolute in Excel?
*
#
$
&
Which of the following is a mixed reference?
$C$5
C5
$C5
=SUM(A1:A5)
If cell D5 contains =B1 + $A$1 and you copy it to E6, what will it be in E6?
=B1 + $A$1
=C2 + $A$1
=C1 + A1
=B1 + A1
What is the main advantage of using absolute references in formulas?
It makes the spreadsheet faster
It keeps certain values constant when copying formulas
It deletes unnecessary cells
It changes values automatically
Which formula adds up cells from A1 to A10, even if you copy it?
=SUM(A1:A10)
=SUM($A$1:$A$10)
=SUM(A$1:A$10)
=SUM($A1:A10)
If you drag the formula =C1 from D1 to D2, what will the new formula be?
What does the $ sign in a cell reference tell Excel?
It's a currency symbol
It makes the reference absolute (fixed)
It deletes the reference
It changes the color of the cell
What is the reference for column D, row 10?
10D
D10
10:D
RowD10
Which reference would change both the row and column when copied?
$A$1
$A1
A$1
A1
