Excel Cell References

Which formula has an absolute cell reference?

• =A1+$B$2
• =A1+B2
• =A1*B2
• =A1/B2

Which symbol is used for Absolute Cell Reference?

• #
• $
• =

In the formula below, which references will update when copied? =$D$3+$E5

• Column D
• Row 3
• Column E
• Row 5

In the formula, which cell reference is absolute? =$D3+E5

• Column E
• Row 5
• Column D
• Row 3

In the formula, which reference is relative, meaning it will update if copied or use of Autofill? =$D$3+E$5

• Column D
• Row 3
• Row 5
• Column E

Which formula below contains a  relative cell reference?

• =$A$1+$B$2
• =A$1+$B$2
• =$A$3+$B$3
  $

Which of the following has a cell reference?

• 5%
• =4*3.7
• =G4/E3
• sub-total

Which of the following formulas includes an absolute cell reference?

• =B1/$B$25
• =B1/B25
• =B1*#B#25
• =AVERAGE(B1:B25)

Which of these formulas uses relative cell references?

• =5*10+20
• =$A$10/100
• =F18+F19/2

Unlike _________ references, _________ references do not change when copied or filled. 

• Absolute, Relative
• Relative, Absolute

Tags

CCSS.RI.9-10.4

CCSS.RI.9-10.4

CCSS.RI.11-12.4

CCSS.RI.7.4

CCSS.RI.8.4