1.6 Excel Test

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

• Conditional Formatting

• Cell Style

• Form

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

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

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

What defines the color of the characters in a Microsoft Excel worksheet?

• Font size

• Font color

• Cell color

• Background

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

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

• Conditional Formatting

• Format as Table

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

worksheet?

• Drawing

• Fill Color

• Borders & Shading

• Highlight