MS Excel Honors #5 Question Preview (ID: 54114)


Review. TEACHERS: click here for quick copy question ID numbers.

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 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

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

Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem?
a) AutoFit
b) Special Formatting
c) Subscript Formatting
d) Wrap Text

Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?
a) Hyperlink
b) Weblink
c) Linkup
d) Textlink

What command is used to apply a background color to cells in a worksheet?
a) Drawing
b) Fill Color
c) Borders and Shading
d) Highlight

What type of formatting appears only when the value in a cell meets conditions specified by a user?
a) Criterion
b) Conditional
c) Logical
d) Restrictive

Which command is used to reduce the margin between the border and the text in an indented cell?
a) Orientation
b) Decrease Indent
c) Column Width
d) Alignment

Which dialog box in Microsoft Excel is used to set the rotation of text in a cell to a specific degree?
a) Orientation
b) Format Cells
c) Format Text
d) Alignment

Which command is used to format a cell or selected cells quickly by choosing from a defined list of styles?
a) Format as Table
b) Cell Style
c) Conditional Formatting
d) Form

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

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

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

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

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

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

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 =SUM(Sales). Sales 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.

Which group on the Formula Ribbon contains the command that checks for common errors found in a formula?
a) Function Library
b) Defined Names
c) Formula Auditing
d) Calculation

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: 54114 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links