Excel Lesson 6

Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet?

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

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

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

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

What command do you use to apply a background color to cells in a worksheet?

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

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

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

Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?

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

What type of formatting appears only when the value in a cell meets conditions specified by a user?

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?

Which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree?

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