Cell Referencing in Excel Quiz

What does cell referencing in Excel allow users to refer to?

• Entire worksheet

• Formatting options

• Specific cell or range of cells in a formula or function

• Only text in a cell

Which type of cell referencing adjusts to the new location when copied to another cell?

• Static Cell Referencing

• Mixed Cell Referencing

• Absolute Cell Referencing

• Relative Cell Referencing

When a formula is copied to another cell, what happens to cell references in Excel by default?

• They are automatically adjusted based on the new location

• They remain the same

• They are deleted

• They become bold

What does Absolute Cell Referencing in Excel allow you to lock?

• Entire row

• Specific cell or range of cells

• Entire worksheet

• Entire column

In Absolute Cell Referencing, what do you add before the column letter and row number of the cell reference to remain constant?

• $

• &

• #

• @

What does Mixed Cell Referencing in Excel allow you to fix while allowing the other to change when copied or filled?

• Only the first cell

• Both row and column

• Neither row nor column

• Either the row or column

Which type of cell referencing is a mixture of both absolute and relative referencing?

• Mixed Cell Referencing

• Dynamic Cell Referencing

• Hybrid Cell Referencing

• Variable Cell Referencing

What symbol do you use in Mixed Cell Referencing to fix either the row or column?

• $

• #

• @

• &

What is an example of Absolute Cell Referencing?

• $A$1

• A1

• A$1

• $A1

Which type of cell referencing is important when dealing with fixed values?

• Dynamic Cell Referencing

• Mixed Cell Referencing

• Relative Cell Referencing

• Absolute Cell Referencing