MS Excel Lesson 6 & 7

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

• Home Ribbon

• Insert Ribbon

• Page Layout Ribbon

• View Ribbon

Jill would like to outline the cell range B1:G20. Which formatting style should she use?

• Borders

• Cell Style

• Conditional Formatting

• Format as Table

The Insert Ribbon creates link to a web page, picture, email address, or program in a worksheet by using this command?

• Hyperlink

• Web Link

• Linkup

• Text Link

Jimmy notices the last two lines of text in cell C4 are not showing up in his spreadsheet. What can Jimmy format the cell to correct this problem?

• AutoFit

• Special Formatting

• Subscript Formatting

• Merge

This 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

Sarah would like to apply the Title format to the data in Row 1 of a spreadsheet Which formatting style should she select?

• Cell Style

• Conditional Formatting

• Fill Color

• Format as Table

What can be used to change the text color of characters in a cell on the Home Ribbon?

• Font Color drop-down list

• Font Size drop-down list

• Fill Color drop-down list

• Cell Styles drop-down list

This a command that is used to apply a background to cells in a worksheet.

• Drawing

• Fill Color

• Borders & Shading

• Highlight

Matthew notices that the data in cell E4 reads #######. What command should he use to fix the problem?

• AutoFit

• Special Formatting

• Subscript Formatting

• Wrap Text

The appearance and shape of the letters, numbers, and special characters in Excel is the

• Alignment

• Font

• Size

• Effects