Lalbaba Excel Quiz 3 : Cell Reference & It's Importance

Why is cell referencing important in Excel formulas?

• It allows you to apply Formula to cells.

• It helps to keep formulas dynamic by automatically updating the results if the data in the referenced cells changes.

• It changes the font style in the referenced cells.

• All of these

What is the purpose of using a dollar sign in a cell reference in Excel?

• To make the cell reference absolute, preventing it from changing when copied.

• To format the cell as currency.

• It changes the format of the cell to currency.

• It converts the reference into a dynamic range.

Which shortcut key is used to fix both row and column components of a cell reference in Excel?

• Shift+Delete

• Alt+Tab

• Ctrl+C

• F4 or Fn+F4

In Excel, what happens when you copy a formula vertically down?

• The cell references in the formula remain unchanged.

• The cell references in the formula shift down by one row for each copied cell.

• The formula converts to text and does not update.

• The formula only copies to the adjacent cells in the same row.

When fixing a cell reference with a dollar sign, what does '$A1' indicate?

• Both the column and row are relative (change).

• Both the column and row are absolute (fixed).

• The row is absolute (fixed) while the column is relative (changes).

• The column is absolute (fixed) while the row is relative (changes).

When you horizontally copy and paste a formula in Excel, what changes?

• Rows remains same and columns change

• Both Rows remain same

• Columns remains same and rows change

• Column remains unchange and rows change