Lesson 6 Excel

Carl notices that the data in cell E4 reads ######. What command could Carl choose to correct the problem?

• AutoFit
• Special Formatting
• Subscript Formatting
• Wrap text

Column D in contains regional sales info. How should the numbers be formatted?

• Currency
• Date
• Number
• Text for option 4 (optional)

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

• Percent
• Accounting
• Comma
• Dollar

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 and Center

The title in cell A1 needs to align horizontally across A1:D1. Which alignment option?

• Center
• Merge and Center
• Orientation
• Wrap text

Which dialog box in Excel is used to set the rotation of text in a cell to a specific degree?

• Orientation
• Format Cells
• format Text
• Alignment

Which formatting style would you use to apply a rule to the data in cell range A1:F2 that will highlight numbers greater than 50,000?

• Borders
• Cell style
• Conditional Formatting
• Format as table

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

• Font size
• Font color
• cell color
• Background

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

• Number
• Font color
• Paragraph
• Format Cells

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