Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). 'Sales' is an example of a/an:
Formulas
Worksheet Reference
=$B$1+25
Cell reference and cell location are outlined in matching colors
named range.
Relative reference
Absolute
Copy using the Fill Handle
What term is used when referencing cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
Formulas
Worksheet Reference
=$B$1+25
Cell reference and cell location are outlined in matching colors
named range.
Relative reference
Absolute
Copy using the Fill Handle
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
Formulas
Worksheet Reference
=$B$1+25
Cell reference and cell location are outlined in matching colors
named range.
Relative reference
Absolute
Copy using the Fill Handle
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?
Formulas
Worksheet Reference
=$B$1+25
Cell reference and cell location are outlined in matching colors
named range.
Relative reference
Absolute
Copy using the Fill Handle
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
Formulas
Worksheet Reference
=$B$1+25
Cell reference and cell location are outlined in matching colors
named range.
Relative reference
Absolute
Copy using the Fill Handle
How is a cell reference in a formula and its corresponding location in a worksheet identified?
Formulas
Worksheet Reference
=$B$1+25
Cell reference and cell location are outlined in matching colors
named range.
Relative reference
Absolute
Copy using the Fill Handle
Jennifer is calculating her GPA. If she uses '=(A1+A2+A3+A4)/4', this is an example of which type of entry?
Formulas
Worksheet Reference
=$B$1+25
Cell reference and cell location are outlined in matching colors
named range.
Relative reference
Absolute
Copy using the Fill Handle
What method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?
Formulas
Worksheet Reference
=$B$1+25
Cell reference and cell location are outlined in matching colors
named range.
Relative reference
Absolute
Copy using the Fill Handle
Check it!
Match it!
Match it!