Microsoft Excel 1.04 Question Preview (ID: 45516)


Excel 2016.[print questions]

Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?
a) =D4+F4
b) =D4*F4
c) =D4 x F4
d) =D4-F4

Jennifer is calculating her GPA. If she uses '=(A1+A2+A3+A4)/4', this is an example of which type of entry?
a) Values
b) Formulas
c) Labels
d) Functions

How is a cell reference in a formula and its corresponding location in a worksheet identified?
a) Arrows pointing from the formula to the location
b) Cell reference and cell location are circled
c) Cell reference and cell location are outlined in matching colors
d) 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?
a) =B4+C4
b) =B4*C4
c) =B4/C4
d) =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?
a) Relative
b) Mixed
c) Absolute
d) Unconditional

Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
a) =$B$1+25
b) =B1+25
c) =1$B$+25
d) =B1:B3

What method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?
a) Copy method from Shortcut Menu
b) Copy using the Fill Handle
c) Copy from the Home Ribbon
d) Copy using the Quick Access Toolbar

Joshua created a budget workbook that contains the formula = (Summary!B3). 'Summary' is an example of a/an:
a) named range.
b) external reference.
c) names manager.
d) scope.

Tyler created a monthly sales workbook that contains the formula = (January!B3). 'January' is an example of a/an:
a) named range.
b) external reference.
c) names manager.
d) scope.

When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
a) Absolute reference
b) Certain reference
c) Variable reference
d) Relative reference

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?
a) Calling the Sheet
b) Name reference
c) Sheet Name
d) Worksheet Reference

Tyler created a monthly sales workbook that contains the formula =SUM(Sales). 'Sales' is an example of a/an:
a) named range.
b) external reference.
c) names manager.
d) scope.

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 45516 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register