Lab Work (10/15)

1. To verify a formula using range finder (E 2.25)

2. To change the font and center the worksheet title (E 2.28)

3. To change the title background and font colors and apply an outline border (E 2.30)

4. To Bold, Center, and Underline the column titles (E 2.31)

5. To center data in cells and format dates (E 2.32)

6. To apply a currency style format and comma style format using the formatting toolbar (E 2.34)

7. To underline the row above the tile row and bolding the total row titles (E 2.36)

8. To apply a currency style format with a floating dollar sign using the format cells command (E 2.37)

9. To apply a percent style format (E 2.39)

10. To apply conditional formatting (E 2.40)

11. To change the widths of columns (E 2.44)

12. To change the height of a row by dragging (E 2.47)

13. To check spelling on the worksheet (E 2.49)

14. To import Data from a web source using a web query (E 2.59)

15. To rename the sheets (E 2.62)

16. Save your work book and email a copy to capstoneatccsu@yahoo.com