Excel Chapter 4 Test

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?

• Calling the Sheet

• Name reference

• Sheet Name

• Worksheet Reference

Jennifer is calculating her GPA. If

she uses '=(A1+A2+A3+A4)/4', this is an example of which type of entry?

• Values

• Formulas

• Labels

• Functions

Joshua created a budget workbook that contains the formula =(Summary!B3). 'Summary' is an example of a/an:

• named range.

• external reference.

• names manager

• scope.

Tyler created a monthly sales workbook that contains the formula =SUM(Sales). 'Sales' is an example of a/an:

• named range.

• external reference.

• names manager

• scope

Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?

• =D4+F4

• =D4*F4

• =D4-F4

• =D4 x F4

Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?

• =$B$1+25

• =B1+25

• =1$B$+25

• =B1:B3

When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?

• Absolute reference

• Certain reference

• Variable reference

• Relative reference

How is a cell reference in a formula and its corresponding location in a worksheet identified?

• Arrows pointing from the formula to

  the location

• Cell reference and cell location

  are circled

• Cell reference and cell location are

  outlined in matching colors

• Lines connect from the formula to

  the location

Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?

• =B4+C4

• =B4*C4

• =B4/C4

• =B4-C4

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?

• Relative

• Mixed

• Absolute

• Unconditional