1.06 Formatting Cells and Ranges

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

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

• Font Size

• Font Color

• Cell Color

• Background

Which formatting would be most appropriate for the data in column D in a spreadsheet contains information about regional sales?

• Currency

• Date

• Number

• Text

To reduce the margin between the border and the text in an indented cell which command do you use?

• Orientation

• Decrease Indent

• Column Width

• Alignment

Which alignment option should be selected to angle text in cell A1 to at 90 degree?

• Orientation

• Format Cells

• Format Text

• Alignment

Defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel

• Alignment

• Font

• Size

• Effects

Which formatting style should he selected to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text?

• Borders

• Cell Style

• Conditional Formatting

• Format as Table

Which alignment option should be selected to align title in cell A1 horizontally across cells A1 through D1?

• Center

• Merge and Center

• Orientation

• Wrap Text

Which formatting would be most appropriate for the data in column D in a spreadsheet that contains employee ID Number?

• Currency

• Date

• Number

• Text

Command used to format a cell or selected cells quickly by choosing from a defined list of styles?

• Formatt as a Table

• Cell Style

• Conditional Formatting