Microsoft Excel 1.06 (Part 2) Question Preview (ID: 45520)


Excel 2016. TEACHERS: click here for quick copy question ID numbers.

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) Cell Style
c) Conditional Formatting
d) Form

Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?
a) Wrap Text
b) Group Cells
c) Cell Styles
d) Merge Center

Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D?
a) Currency
b) Date
c) Number
d) Text

Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?
a) Wrap Text
b) Group Cells
c) Cell Styles
d) Merge Center

What type of formatting appears only when the value in a cell meets conditions specified by a user?
a) Criterion
b) Conditional
c) Logical
d) Restrictive

On the Home Ribbon, what can be used to change the text color of characters in a cell?
a) Font Color drop-down list
b) Font Size drop-down list
c) Fill Color drop-down list
d) Cell Styles drop-down list

Which command is used to reduce the margin between the border and the text in an indented cell?
a) Orientation
b) Decrease Indent
c) Column Width
d) Alignment

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

What defines the color of the characters in a Microsoft Excel worksheet?
a) Font size
b) Font color
c) Cell color
d) Background

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

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 45520 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register