MS Excel

Which of the following is NOT a type of cell reference in Excel?

• Relative Reference
• Absolute Reference
• Fixed Reference
• Mixed Reference

What happens when you copy a formula with a relative reference?

• The reference remains unchanged
• The reference adjusts based on its new location
• It converts to an absolute reference
• It removes all references

What symbol is used to indicate an absolute reference in Excel?

• #
• $
• @
• &

If a formula in A1 is =B1+C1 and is copied to D1, what will the new formula be?

• ="=B1+C1"
• ="=D1+E1"
• ="=B2+C2"
• ="=E1+F1"

A mixed reference means:

• Both row and column are absolute
• One is absolute, the other is relative
• Both row and column are relative
• The reference is invalid

If you enter =$A$1+B1 and copy it down, how does it change?

• It remains =$A$1+B1
• It changes to =$A$1+B2
• It changes to =$A$2+B2
• It remains unchanged for all cells

How do you quickly toggle through reference types (absolute, relative, mixed)?

• Press F4
• Press Ctrl + A
• Press Alt + R
• Right-click the formula

What is a circular reference in Excel?

• A reference that loops back to itself
• A reference to another worksheet
• A reference error
• A reference that Excel automatically corrects

What does the caret (^) symbol represent in an Excel formula?

• Multiplication
• Division
• Exponentiation
• Modulus

What is the result of =10/2*5 in Excel?

• 25
• 20
• 50
• 5