Question Demo 2
Completion requirements
1. On the “Used Car Sales” worksheet, add a total row to the table. Configure the total row to display the total sales of each month and 3 months.
2. On the “New Car Sales” worksheet, configure the table style options to automatically shade every other table row
3. On the “Used Car Sales” worksheet, create a Clustered Column Chart that shows the sale of each car in February and March, with the Car name as the horizontal axis labels. Place the chart below the table. The exact size and position of the chart do not matter.
4. On the “Total Car Sales” worksheet, for the “Total Sale” chart, display a data table without legend keys.
5. Move the chart on “New Car Sales” to a new chart sheet named “NewCarChart”.
Grading method: Highest grade