Microsoft Excel Review and Assessment Hands On Activity 3 CHAPTER Skills Assessment Format a Supplies and Equipment Worksheet

1. Begin with 3-OEBudget-A3-HOA open.

2. Select and then merge the range A1:D2. Hint: Use the Merge Across option at the Merge & Center button drop-down list.

3. With cells A1 and A2 selected, click the Middle Align button in the Alignment group and then click the Center button.

4. Make cell A1 active and then change the font size to 22 points and apply bold formatting.

5. Make cell A2 active and then change the font size to 12 points and apply bold formatting.

6. Change the height of row 1 to 36.00 points.

7. Change the height of row 2 to 21.00 points.

8. Change the width of column A to 15.00 characters.

9. Select the range A3:A17, apply bold formatting, and then click the Wrap Text button in the Alignment group.

10. Make cell B3 active and then apply the Currency format with no digits after the decimal point.

11. Select the range C6:C19 and then apply the Percentage format with one digit after the decimal point.

12. Make cell D6 active and then type a formula that multiplies the absolute cell reference $B$3 with the percentage in cell C6. Copy the formula to the range D7:D19.

13. With the range D6:D19 selected and with the Currency format applied, format the numbers with no digits after the decimal point.

14. Make cell D8 active and then clear its contents. Use the Repeat command, the F4 function key, to clear the contents from cells D11, D14, and D17.

15. Select the range A1:D19, change the font to Constantia, and then change the font color to standard dark blue.

16. Add the Green, Accent 6, Lighter 80% fill color (last column, second row in the Theme Colors section) to the following cells: A1, A2, A5:D5, A8:D8, A11:D11, A14:D14, and A17:D17.

17. Automatically adjust the width of column B.