Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
MS Excel Honors #5
Test Description: Review
Instructions: Answer all questions to get your test result.
1) Which command is used to format a cell or selected cells quickly by choosing from a defined list of styles?
A
Form
B
Format as Table
C
Conditional Formatting
D
Cell Style
2) Which dialog box in Microsoft Excel is used to set the rotation of text in a cell to a specific degree?
A
Orientation
B
Alignment
C
Format Cells
D
Format Text
3) Which command is used to reduce the margin between the border and the text in an indented cell?
A
Decrease Indent
B
Orientation
C
Column Width
D
Alignment
4) What command is used to apply a background color to cells in a worksheet?
A
Borders and Shading
B
Highlight
C
Drawing
D
Fill Color
5) What type of formatting appears only when the value in a cell meets conditions specified by a user?
A
Logical
B
Conditional
C
Restrictive
D
Criterion
6) Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?
A
Weblink
B
Linkup
C
Hyperlink
D
Textlink
7) Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem?
A
Wrap Text
B
Special Formatting
C
AutoFit
D
Subscript Formatting
8) How is a cell reference in a formula and its corresponding location in a worksheet identified?
A
Cell reference and cell location are outlined in matching colors
B
Lines connect from the formula to the location
C
Cell reference and cell location are circled
D
Arrows pointing from the formula to the location
9) What method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?
A
Copy from the Home Ribbon
B
Copy using the Quick Access Toolbar
C
Copy using the Fill Handle
D
Copy method from Shortcut Menu
10) When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
A
Relative reference
B
Absolute reference
C
Variable reference
D
Certain reference
11) 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
Absolute
B
Unconditional
C
Relative
D
Mixed
12) 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
Sheet Name
B
Name Reference
C
Calling the sheet
D
Worksheet Reference
13) Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?
A
=@D4 x F4
B
=D4*F4
C
=D4-F4
D
=D4+F4
14) 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
15) Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
A
=@B1:B3
B
=$B$1+25
C
=1$B$+25
D
=B1+25
16) Jennifer is calculating her GPA. If she uses =(A1+A2+A3+A4)/4, this is an example of which type of entry?
A
Labels
B
Functions
C
Formulas
D
Values
17) Joshua created a budget workbook that contains the formula =(Summary!B3). Summary is an example of a/an:
A
names manager.
B
scope.
C
named range.
D
external reference.
18) Tyler created a monthly sales workbook that contains the formula =SUM(Sales). Sales is an example of a/an:
A
external reference.
B
names manager.
C
scope.
D
named range.
19) Tyler created a monthly sales workbook that contains the formula =(January!B3). January is an example of a/an:
A
names manager.
B
scope.
C
named range.
D
external reference.
20) Which group on the Formula Ribbon contains the command that checks for common errors found in a formula?
A
Function Library
B
Formula Auditing
C
Defined Names
D
Calculation
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?