WorksheetsExcel Lesson 6 Quiz
Total questions: 24
Worksheet time: 24mins
Which command on the Home Ribbon can be used to rotate text to a vertical or diagonal angle in a worksheet?
Font
Orientation
Wrap Text
Merge & Center
What defines the color of the characters in a Microsoft Excel worksheet?
Font size
Font color
Cell color
Background
Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
Center
Merge and Center
Orientation
Wrap Text
Which command is used to format a cell or selected cells quickly by choosing from a defined list of styles?
Format as Table
Cell Style
Conditional Formatting
Form
Where is the command to apply a fill color to a cell or range of cells in a worksheet?
Home Ribbon
Insert Ribbon
Page Layout Ribbon
View Ribbon
Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D?
Currency
Date
Number
Text
On the Home Ribbon, what is used to change the font size of characters in a cell?
Font drop-down list
Font Size drop-down list
Font Style drop-down list
Cell Styles drop-down list
Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?
Alignment
Font
Size
Effects
Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?
Cell Style
Conditional Formatting
Fill Color
Format as Table
What command is used to apply a background color to cells in a worksheet?
Drawing
Fill Color
Borders & Shading
Highlight
Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?
Number
Font
Paragraph
Format Cells
Which quick-number style button formats numbers to display as currency in the worksheet?
Percent
Accounting
Comma
Dollar
Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?
Wrap Text
Group Cells
Cell Styles
Merge & Center
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?
Borders
Cell Style
Conditional Formatting
Format as Table
Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?
Currency
Date
Number
Text
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?
AutoFit
Special Formatting
Subscript Formatting
Merge
Which dialog box in Microsoft Excel is used to set the rotation of text in a cell to a specific degree?
Orientation
Format Cells
Format Text
Alignment
Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select?
Center
Merge and Center
Orientation
Wrap Text
Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?
Hyperlink
Web link
Linkup
Text link
Which command is used to reduce the margin between the border and the text in an indented cell?
Orientation
Decrease Indent
Column Width
Alignment
On the Home Ribbon, what can be used to change the text color of characters in a cell?
Font Color drop-down list
Font Size drop-down list
Fill Color drop-down list
Cell Styles drop-down list
Trey would like to outline the cell range A1:F20. Which formatting style should he select?
Borders
Cell Style
Conditional Formatting
Format as Table
What type of formatting appears only when the value in a cell meets conditions specified by a user?
Criterion
Conditional
Logical
Restrictive
Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem?
AutoFit
Special Formatting
Subscript Formatting
Wrap Text
