NEW
Font size
Worksheets25-26 Excel Basics Test 2 (Basic Formulas)
Total questions: 15
Worksheet time: 8mins
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
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.
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
Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
Function Library
Defined Names
Formula Auditing
Calculation
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.
Tyler created a monthly sales workbook that contains the formula =(January!B3). "January" is an example of a/an:
named range.
external reference.
names manager.
scope.
