Excel Basics Test 2 (Basic Formulas)

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

What method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?

• Copy method from Shortcut Menu

• Copy using the Fill Handle

• Copy from the Home Ribbon

• Copy using the Quick Access Toolbar

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

Which group on the Formula Ribbon contains the command that checks for common errors found in a formula?

• Function Library

• Defined Names

• Formula Auditing

• Calculation

Which group on the Formulas tab enables a user to specify when a formula is computed?

• Function Library

• Calculation

• Formula Auditing

• Defined Names

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

• =D4+F4

• =D4*F4

• =D4 x F4

• =D4-F4

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

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

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

Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?

• Formulas

• Values

• Labels

• Functions