Understanding Cell References in Google Sheets

What is the primary characteristic of a relative reference in Google Sheets?

• It changes based on the position of the formula.

• It locks the row and column.

• It is used for formatting cells.

• It remains constant when copied.

Why might you choose to use an absolute reference in a formula?

• To ensure the reference changes with the formula.

• To keep the reference constant regardless of where the formula is copied.

• To automatically adjust the reference based on data type.

• To apply conditional formatting.

How do you denote an absolute reference in Google Sheets?

• By using a hashtag (#) before the cell reference.

• By placing a dollar sign ($) before the column and row.

• By using parentheses around the cell reference.

• By highlighting the cell in a different color.

What is a mixed reference in Google Sheets?

• A reference that applies to multiple sheets.

• A reference that is used only for text data.

• A reference that locks either the row or the column.

• A reference that changes both row and column.

When creating a formula, what should you consider regarding cell references?

• The number of formulas in the sheet.

• The font size of the text in the cell.

• Whether to use a relative, absolute, or mixed reference.

• The color of the cell.