Quiz on Cell Referencing in Spreadsheets

What type of cell reference changes its address when copied or moved to a different cell?

• Absolute Reference

• Relative Reference

• Mixed Reference

Which referencing type remains fixed when copied to other cells?

• Relative Reference

• Absolute Reference

• Mixed Reference

If cell A1 contains the formula "=B$3 + C5", what type of reference is used for cell B3 in the formula?

• Relative Reference

• Absolute Reference

• Mixed Reference

What symbol ($) is used to denote an absolute reference in a cell address?

• Dollar Sign ($)

• Hash Symbol (#)

• Ampersand (&)

Which referencing type keeps the column constant but allows the row to change when copied vertically?

• Absolute Column Reference

• Absolute Row Reference

• Mixed Reference

In a spreadsheet, what does an absolute reference with $A$1 mean?

• Row 1 in column A

• Column A in row 1

• Any cell in column A

Which referencing type would change both the column and row when copied to other cells?

• Relative Reference

• Absolute Reference

• Mixed Reference

What is the purpose of using mixed references in a formula?

• To keep both column and row constant

• To allow flexibility in column or row direction

• To prevent copying of formulas

Which referencing type allows flexibility in only one direction (either row or column)?

• Relative Reference

• Absolute Reference

• Mixed Reference

If you want to fix the row but allow the column to change when copied, what type of reference would you use?

• Absolute Row Reference

• Absolute Column Reference

• Mixed Reference