Cell References and Naming Cells Quiz

Which of the following is a relative cell reference?

• $A$1

• A$1

• A1

• $A1

What is the correct way to make column A absolute and row relative?

• $A$1

• A$1

• $A1

• A1

What does $B$5 represent?

• Relative reference

• Mixed reference

• Absolute reference

• Named range

What is the default reference type in Excel?

• Absolute

• Mixed

• Relative

• Named

Where is the Name Manager found in Excel?

• View tab

• Insert tab

• Formulas tab

• Home tab

Which is not allowed in a named range?

• Letters

• Underscore (_)

• Space

• Numbers

Which name is valid for naming a cell?

• 123Sales

• Sales Data

• _Sales2023

• @Sales

What is a cell reference?

• A color

• A chart

• A cell address like A1

• A number

What happens if you copy =B$2 downward?

• Becomes =C$2

• Changes column

• Stays =B$2

• Gives error

The shortcut to open Name Manager is:

• Ctrl + A

• Ctrl + F3

• Ctrl + F4

• Ctrl + 1