Excel Absolute References Quiz

What is the purpose of using '$' in Excel formulas?

• To format the cell as currency

• To add a comment

• To highlight the cell

• To make the reference absolute

Which key is used as a shortcut to enter absolute references in Excel?

• F12

• F5

• F4

• F1

What happens if you copy a formula with a relative reference down a column?

• The reference remains the same

• The reference becomes absolute

• The reference changes by one row

• The reference changes by one column

How do you make only the row reference absolute?

• $D$3

• D3

• D$3

• $D3

What is the result of pressing F4 multiple times on a cell reference?

• It deletes the reference

• It opens the formula bar

• It cycles through different absolute reference options

• It changes the cell color

What is the benefit of using absolute references in Excel?

• To make formulas easier to read

• To prevent errors when copying formulas

• To create charts

• To automatically format cells

Which of the following is an example of a fully absolute cell reference?

• $D$3

• D$3

• $D3

• D3

What does the formula =D3*$G$3 do when copied down a column?

• It adds D3 to G3

• It multiplies D3 by each cell in column G

• It multiplies each cell in column D by G3

• It multiplies D3 by G3

What is the effect of using $D$1:$F$1 in a formula?

• It makes the range absolute

• It makes the range relative

• It highlights the range

• It deletes the range

What does the F2 key do in Excel?

• Closes the workbook

• Saves the workbook

• Opens the help menu

• Edits the selected cell