- Select a style from the Design tab and then format the all courses (on the chart) with the fill color of Olive Green, Accent 3.
- Select the Cluster Cylinder Column chart, use the Cut command, and then paste a copy of the chart in cell A31.
- Create a second chart from the Design tab. This time, select a Bar chart.
- Add a chart title to both charts using the Layout Style 1. Label the Cluster Cylinder Column chart CTU Grade Average, and label the bar chart “Your Name” Grade Average.
- You realize that a score is missing for your IP5 assignment in IT254. Modify cell F6, and add the value of 81.