Microsoft Excel Review and Assessment Hands On Activity 3 CHAPTER 3 CHAPTER Formatting a Worksheet Skills Assessment Format a Sales Worksheet

1. Begin with 3-NSPSales-A1-HOA open.

2. Change the width of column A to 14.00 characters.

3. Change the width of columns B through E to 10.00 characters.

4. Select row 2 and then insert a new row.

5. Merge and center the range A2:E2.

6. Type Sales Department in cell A2 and then press the Enter key.

7. Increase the height of row 1 to 33.00 points.

8. Increase the height of row 2 to 21.00 points.

9. Increase the height of row 3 to 18.00 points.

10. Make the following formatting changes to the worksheet: a. Make cell A1 active, change the font size to 18 points, and then apply bold formatting. b. Make cell A2 active, change the font size to 14 points, and then apply bold formatting. c. Select the range A3:E3, apply bold formatting, and then click the Center button in the Alignment group. d. Select the range A1:E3 and then change the vertical alignment to Middle Align.

11. Insert the following formulas in the worksheet: a. Insert a formula in cell D4 that adds the amounts in cells B4 and C4. Copy the formula to the range D5:D11. b. Insert a formula in cell E4 that averages the amounts in cells B4 and C4. Copy the formula to the range E5:E11.

12. Make the following changes to the worksheet: a. Select the range B4:E4 and then apply the Accounting format with a dollar symbol ($) and no digits after the decimal point. b. Select the range B5:E11, apply the Comma format, and then change the number of digits after the decimal point to 0. c. Apply the Facet theme to the worksheet. d. Add a double-line border around the range A1:E11. Hint: Use the More Borders option at the Borders button drop down list and then use options at the Format Cells dialog box with the Border tab selected to apply a doubleline border to the outside of the selected range. e. Select cells A1 and A2 and then apply the Blue-Gray, Text 2, Lighter 80% fill color (fourth column, second row in the Theme Colors section). f. Select the range A3:E3 and then apply the Blue-Gray, Text 2, Lighter 60% fill color (fourth column, third row in the Theme Colors section).