Excel Lesson 6 Quiz

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