WorksheetsExcel MOAC Lesson 06: Formatting Cells & Ranges (Part 2)
Total questions: 11
Worksheet time: 6mins
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 defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?
Alignment
Font
Size
Effects
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
Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?
Cell Styles
Conditional Formatting
Fill Color
Format as Table
Which quick-number style button formats numbers to display as currency in the worksheet?
Percent
Comma
Accounting
Dollar
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
Which command is used to format a cell or selected cells quickly by choosing from a defined list of styles?
Format as Table
Form
Conditional Formatting
Cell Style
What defines the color of the characters in a Microsoft Excel worksheet?
Font size
Font color
Cell color
Background
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
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
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
