Google Sheets: Types of Cell References Quiz

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

• Static and Dynamic

• Relative and Absolute

• Fixed and Variable

• Direct and Indirect

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

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

• It disappears

• It becomes an absolute reference

• It remains constant

How is an absolute reference designated in a formula?

• By adding a dollar sign ($)

• By using parentheses

• By adding an asterisk (*)

• By using a hashtag (#)

Which format is most commonly used for absolute references?

• A2$

• $A2

• A$2

• $A$2

In the example, what is the purpose of using cell $E$2 as an absolute reference?

• To keep the tax rate constant in the formula

• To change the tax rate dynamically

• To make the formula disappear

• To convert the formula to text

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

• Relative reference

• Absolute reference

• Static reference

• Dynamic reference

What is the fill handle used for in Google Sheets?

• To delete a formula

• To insert a new row

• To copy a formula to other cells

• To change the font size

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

• Press the 'Enter' key

• Right-click and select 'Check'

• Double-click the filled cells

• Hover over the cells

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

• Google Sheets will interpret it as a relative reference

• The formula will not work

• The cell will turn red

• The formula will be deleted

What is the purpose of using relative references in formulas?

• To make the spreadsheet colorful

• To keep a value constant

• To delete unnecessary data

• To repeat the same calculation across multiple rows or columns