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
Linkup
B
Hyperlink
C
Text link
D
Web link
2) Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet?
A
Wrap Text
B
Merge Center
C
Font
D
Orientation
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
Fill Color
B
Conditional Formatting
C
Cell Style
D
Format as Table
4) On the Home Ribbon, what do you use to change the font size of characters in a cell?
A
Font drop-down list
B
Cell Styles drop-down list
C
Font Style drop-down list
D
Font Size drop-down list
5) What type of formatting appears only when the value in a cell meets conditions specified by a user?
A
Logical
B
Criterion
C
Restrictive
D
Conditional
6) What defines the color of the characters in an Microsoft Excel worksheet?
A
Font color
B
Font size
C
Background
D
Cell 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
Merge Center
C
Wrap Text
D
Cell Styles
8) Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select?
A
Center
B
Wrap Text
C
Merge and Center
D
Orientation
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
Conditional Formatting
B
Borders
C
Cell Style
D
Format as Table
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
Highlight
B
Borders Shading
C
Drawing
D
Fill Color
12) On the Home Ribbon, what do you use to change the text color of characters in a cell?
A
Font Size drop-down list
B
Cell Styles drop-down list
C
Font Color drop-down list
D
Fill Color 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
Format Cells
B
Orientation
C
Format Text
D
Alignment
14) Trey would like to outline the cell range A1:F20. Which formatting style should he select?
A
Conditional Formatting
B
Format as Table
C
Borders
D
Cell Style
15) Which command do you use to reduce the margin between the border and the text in an indented cell?
A
Alignment
B
Orientation
C
Decrease Indent
D
Column Width
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
Merge
B
AutoFit
C
Subscript Formatting
D
Special Formatting
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
Number
C
Date
D
Text
18) Which term describes the blank portions of a page that fall outside the main body of the printed document?
A
Frames
B
Borders
C
Edges
D
Margins
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
Format
B
Form
C
Sort Filter
D
Insert
20) Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?
A
Background
B
Print Area
C
Effects
D
Breaks
*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?