Excel lesson 6

Which command on the Home tab can be used to rotate text to a vertical or diagonal angle in a worksheet?

• Font

• Orientation

• Wrap Text

• Merge and Center

Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?

• Alignment

• Font

• Size

• Effects

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

Which command on the Home tab joins selected cells into one and centers that content into a larger single cell?

• Wrap Text

• Group Cells

• Cell Styles

• Merge and Center

Trey would like to outline the cell range A1:F20. Which formatting style should he select?

• Borders

• Cell Style

• Conditional Formatting

• Format as Table

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

What command is used to apply a background color to cells in a worksheet?

• Drawing

• Fill Color

• Borders and Shading

• Highlight

Which command on the Insert tab 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 Style

• Conditional Formatting

• Fill Color

• Format as Table

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