Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Microsoft Excel 1.06-1.07 (Part 1)
Test Description: Part 1
Instructions: Answer all questions to get your test result.
1) Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?
A
Hyperlink
B
Web link
C
Linkup
D
Text link
2) Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet?
A
Merge Center
B
Font
C
Orientation
D
Wrap Text
3) Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?
A
Format as Table
B
Cell Style
C
Conditional Formatting
D
Fill Color
4) On the Home Ribbon, what do you use to change the font size of characters in a cell?
A
Font Size drop-down list
B
Font Style drop-down list
C
Cell Styles drop-down list
D
Font drop-down list
5) What type of formatting appears only when the value in a cell meets conditions specified by a user?
A
Restrictive
B
Conditional
C
Criterion
D
Logical
6) What defines the color of the characters in an Microsoft Excel worksheet?
A
Background
B
Font size
C
Cell color
D
Font color
7) Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?
A
Group Cells
B
Wrap Text
C
Merge Center
D
Cell Styles
8) Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select?
A
Orientation
B
Wrap Text
C
Center
D
Merge and Center
9) Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?
A
Format as Table
B
Cell Style
C
Borders
D
Conditional Formatting
10) Which quick-number style button formats numbers to display as currency in the worksheet?
A
Accounting
B
Dollar
C
Percent
D
Comma
11) What command do you use to apply a background color to cells in a worksheet?
A
Drawing
B
Borders Shading
C
Fill Color
D
Highlight
12) On the Home Ribbon, what do you use to change the text color of characters in a cell?
A
Font Color drop-down list
B
Fill Color drop-down list
C
Font Size drop-down list
D
Cell Styles drop-down list
13) Which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree?
A
Alignment
B
Format Cells
C
Orientation
D
Format Text
14) Trey would like to outline the cell range A1:F20. Which formatting style should he select?
A
Conditional Formatting
B
Cell Style
C
Format as Table
D
Borders
15) Which command do you use to reduce the margin between the border and the text in an indented cell?
A
Decrease Indent
B
Alignment
C
Column Width
D
Orientation
16) Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl format the cell to correct this problem?
A
AutoFit
B
Special Formatting
C
Subscript Formatting
D
Merge
17) Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in column D?
A
Currency
B
Text
C
Number
D
Date
18) Which term describes the blank portions of a page that fall outside the main body of the printed document?
A
Borders
B
Margins
C
Frames
D
Edges
19) Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet?
A
Form
B
Insert
C
Format
D
Sort Filter
20) Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?
A
Print Area
B
Background
C
Breaks
D
Effects
*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?