Google Sheets: Types of Cell References Quiz

What are the two types of cell references in Google Sheets?

• Fixed and Variable

• Direct and Indirect

• Relative and Absolute

• Static and Dynamic

What happens to a relative reference when a formula is copied to another cell?

• It becomes an absolute reference

• It remains constant

• It changes based on the relative position of rows and columns

• It disappears

How is an absolute reference designated in a formula?

• By adding a hashtag (#)

• By adding a dollar sign ($)

• By using square brackets []

• By using parentheses ()

Which format is most commonly used for absolute references?

• $A2

• $A$2

• A2$

• A$2

In the example, what is the purpose of using cell E2 as an absolute reference?

• To keep the tax rate constant

• To delete the tax rate

• To change the tax rate dynamically

• To hide the tax rate

What is the default type of cell reference in Google Sheets?

• Absolute reference

• Mixed reference

• Relative reference

• Static reference

What is the result of copying a formula with relative references across multiple rows?

• The formula adjusts to each row

• The formula remains the same

• The formula becomes invalid

• The formula is deleted

What should you do to check the accuracy of filled cells with formulas?

• Delete the filled cells

• Right-click the filled cells

• Copy the filled cells

• Double-click the filled cells

What is the fill handle used for in Google Sheets?

• To add comments

• To copy formulas to other cells

• To delete formulas

• To change cell colors

What happens if you forget to include the dollar sign in an absolute reference?

• It causes an error

• It becomes a mixed reference

• It deletes the formula

• It is interpreted as a relative reference