February 19

Format the Microsoft Excel Chart with the following:

-Cells B3-G3 should be titled the first six months of the year. (ex. January, February....etc).
-Cell H3 should be titled Total
-Cell I3 should be titled Price per Bar
-Cell J3 should be titled Total Earnings
-Cells A4-A9 Should be Titled as follows: Sticky Bumps, Mrs. Palmers, Magma, BubbleGum, Phil's Organic, Sex Wax
-Bold All of your titles
-Cell A10 should be titled Total

Once you have the titles in, use the following formulas:
-In Cells H4-H9 you should use the AutoSum function and find the totals
-In Cells B10 - G10 you should use the AutoSum function and find the totals
-In Cells J4 - J9 you should use the multiplication formula =(H4*I4) then drag the formula down through J9
-Use the AutoSum or addition formula in Cell J10

Now you can format the chart!
-The Title Should be Gnarley Charley's Surf Shop in 20-26 size font, your choice on design.
-The subtitle should be First Half Year Surf Wax Sales in 16-18 size font
-These headings should be merged and centered
-Use whatever color background and font you want.
-Highlight cells A3-J10 and use the Autoformat function of "List 3"
-Once you do this, go back over and highlight cells I4-J10 and go back to the autoformat function and use the Accounting 1 Format Style
-Click on Cell J10 and color it with Neon Yellow because that is your total amount of sales.

-Look at your chart and make any necessary changes before you Email it to me.

-Good Luck