Excel MOAC Lesson 06: Formatting Cells & Ranges (Part 2)

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