Project 8

1.       On the “Books” worksheet, format the table so that every other row is shaded. Use a technique that automatically updates the formatting when you insert a new row.

2.       On the “Profits” worksheet, include “Cost” of “Products of CA” to the “C&P” Chart. Change the layout of this chart to Layout 5.

3.       On the “Books” worksheet, modify the chart to show the value of “Cost” and “Selling price” on the X-axis and the name of “Author” as Y-axis.

4.       Below the table of “Sales data” worksheet, create a Clustered Column Chart to show Quarter 3 Sales of “Soups” category. Month should be shown as Legend (Series Name). Name of “Item” should be shown as Horizontal Axis Label. Remove the Chart Title. Add text “Soups” as the value of Vertical Axis Title.

5.       Locate the “TinhocCong” table and add a row to the table that automatically calculates total of Selling price. Use an available feature of table. The result should be shown in cell G41.

6.       On the “Profits” worksheet, change the picture of an ice cream to the logo of Tin hoc Cong (logo.png) in the CA.EDocument folder. Keep all formatting of the old picture.

7.       Add a footer of each page of “Sales data” worksheet. Show Current date in Center place. This date should be updated automatically.