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
Conditional Formatting
B
Format as Table
C
Form
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 Text
D
Format Cells
3) Which command is used to reduce the margin between the border and the text in an indented cell?
A
Decrease Indent
B
Column Width
C
Alignment
D
Orientation
4) What command is used to apply a background color to cells in a worksheet?
A
Drawing
B
Borders and Shading
C
Fill Color
D
Highlight
5) What type of formatting appears only when the value in a cell meets conditions specified by a user?
A
Logical
B
Restrictive
C
Conditional
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
Textlink
D
Hyperlink
7) Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem?
A
Wrap Text
B
AutoFit
C
Special Formatting
D
Subscript Formatting
8) 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 outlined in matching colors
C
Cell reference and cell location are circled
D
Lines connect 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 method from Shortcut Menu
B
Copy using the Quick Access Toolbar
C
Copy from the Home Ribbon
D
Copy using the Fill Handle
10) When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
A
Absolute reference
B
Variable reference
C
Certain reference
D
Relative 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
Relative
B
Absolute
C
Unconditional
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
Worksheet Reference
C
Calling the sheet
D
Name 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+25
B
=@B1:B3
C
=1$B$+25
D
=$B$1+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
Formulas
B
Functions
C
Values
D
Labels
17) Joshua created a budget workbook that contains the formula =(Summary!B3). Summary is an example of a/an:
A
scope.
B
external reference.
C
names manager.
D
named range.
18) Tyler created a monthly sales workbook that contains the formula =SUM(Sales). Sales is an example of a/an:
A
names manager.
B
scope.
C
external reference.
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
external reference.
C
scope.
D
named range.
20) 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
*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?