Excel - Lesson 6

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

• Font color

• Cell color

Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?

• Merge and Center

• Orientation

Which quick-number style button formats numbers to display as currency in the worksheet?

• Comma

• Accounting

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

• Conditional Formatting

• Borders

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

• Wrap Text

• Merge & Center

Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?

• Format Cells

• Paragraph

Where is the command to apply a fill color to a cell or range of cells in a worksheet?

• Home Ribbon

• Insert Ribbon

Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D?

• Number

• Text

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

• Orientation

• Merge & Center

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

• Conditional Formatting

• Cell Style