Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Microsoft Excel 1.06 (Part 2)
Test Description: Excel 2016
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
Format as Table
B
Conditional Formatting
C
Cell Style
D
Form
2) Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?
A
Group Cells
B
Cell Styles
C
Wrap Text
D
Merge Center
3) Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D?
A
Currency
B
Number
C
Text
D
Date
4) Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?
A
Cell Styles
B
Wrap Text
C
Group Cells
D
Merge Center
5) What type of formatting appears only when the value in a cell meets conditions specified by a user?
A
Conditional
B
Criterion
C
Logical
D
Restrictive
6) On the Home Ribbon, what can be used 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
7) Which command is used to reduce the margin between the border and the text in an indented cell?
A
Orientation
B
Column Width
C
Decrease Indent
D
Alignment
8) 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
Cell Style
B
Conditional Formatting
C
Format as Table
D
Borders
9) What defines the color of the characters in a Microsoft Excel worksheet?
A
Font size
B
Background
C
Cell color
D
Font color
10) 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
Borders
B
Cell Style
C
Conditional Formatting
D
Format as Table
*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?