Excell Lesson 6 (Part 2)

Match it! Select the correct answer from the pull down...Good luck!

Column D in a spreadsheet contains Product Prices. Which formatting would be most appropriate for the data in column D?

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

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

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

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

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

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

Jacob would like to apply a rule to the data in cell range A1:D20 that will highlight numbers greater than 20,000 with a green fill color and dark red text. Which formatting style should he select?