Excel Lesson 6 Pt. 1

Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl format the cell to correct this problem?

• AutoFit
• Special Formatting
• Subscript Formatting
• Merge

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 defines the color of the characters in a Microsoft Excel worksheet?

• Font size
• Font color
• Cell color
• Background

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

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

On the Home Ribbon, what can be used to change the text color of characters in a cell?

• Font Color drop-down list
• Font Size drop-down list
• Fill Color 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

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

• Currency
• Date
• Number
• Text

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

• Number

• Font

• Paragraph

• Format Cells

Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?

• hyperlink
• web link
• link up
• text link