Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Which formula divides C3 by C7?
External Reference
Absolute
Named Range
Worksheet Reference
Cell reference and cell location are outlined in matching colors
Formula
Relative References
=C3/C7
How is a cell reference in a formula and its corresponding location in a worksheet identified?
External Reference
Absolute
Named Range
Worksheet Reference
Cell reference and cell location are outlined in matching colors
Formula
Relative References
=C3/C7
If you type =Sum(B7+D7) into a cell, which of the following best describes what you have entered?
External Reference
Absolute
Named Range
Worksheet Reference
Cell reference and cell location are outlined in matching colors
Formula
Relative References
=C3/C7
What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area?
External Reference
Absolute
Named Range
Worksheet Reference
Cell reference and cell location are outlined in matching colors
Formula
Relative References
=C3/C7
If you create a spreadsheet with a cell that contains =SUM(Income) What does the (Income) represent?
External Reference
Absolute
Named Range
Worksheet Reference
Cell reference and cell location are outlined in matching colors
Formula
Relative References
=C3/C7
If you copy a formula from one cell into another, which type of reference will automatically adjust the cell references based on the new location?
External Reference
Absolute
Named Range
Worksheet Reference
Cell reference and cell location are outlined in matching colors
Formula
Relative References
=C3/C7
If you have a cell in your spreadsheet that contains a formula such as =(BudgetUS!B3), what does the BudgetUS represent?
External Reference
Absolute
Named Range
Worksheet Reference
Cell reference and cell location are outlined in matching colors
Formula
Relative References
=C3/C7
What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
External Reference
Absolute
Named Range
Worksheet Reference
Cell reference and cell location are outlined in matching colors
Formula
Relative References
=C3/C7
Check it!