Quiz on Cell References in Excel

What are the two types of cell references in Excel?

• Relative and Absolute

• Primary and Secondary

• Static and Dynamic

• Fixed and Variable

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

• They are deleted

• They remain constant

• They change based on position

• They become absolute

How do you create an absolute reference in a formula?

• By using a colon

• By adding a dollar sign before the column and row

• By typing 'absolute'

• By using parentheses

What is the purpose of using relative references?

• To reference other worksheets

• To repeat calculations across multiple cells

• To keep the reference constant

• To create mixed references

What key can you press to switch between relative, absolute, and mixed references in Excel?

• F2

• F4

• F8

• F10

How do you reference a cell from another worksheet?

• By typing the worksheet name followed by a colon

• By using the ampersand symbol

• By typing the worksheet name followed by an exclamation point

• By enclosing the worksheet name in quotes

What will happen if you enter a worksheet name incorrectly in a cell reference?

• The formula will still work

• The worksheet will be deleted

• The cell will be blank

• The cell will display a #REF! error

What is a mixed reference?

• A reference that is neither relative nor absolute

• A reference that changes both row and column

• A reference that is used for text values

• A reference that has a dollar sign before either the row or column

What should you do if a worksheet name contains a space when referencing it?

• Use a hyphen

• Include single quotation marks around the name

• Use an underscore

• Leave it as is

What is the default type of cell reference in Excel?

• Relative

• Mixed

• Static

• Absolute