Home » Microsoft » 77-727 » Which shows the amounts and variety of products sold during the season.
SIMULATION
Overview
You are the Director of a local farmers’ market. You are creating and modifying charts for a report which shows the amounts and variety of products sold during the season.
On the “Spring Sales” worksheet, add the title “New Products” to the column chart. Label the vertical axis “Gross Sales” and the horizontal axis “Months”.
Correct Answer: See explanation below.
Explanation/Reference:
Explanation:
1. Click on the title on the “Spring Sales” worksheet, then type “New Products”.
2. You can edit the Font of the title from the mini-toolbar that appears OR from the Home tab.
3. Click directly on either the x-axis or y-axis in the chart OR click the Chart Elements button.
4. For editing the x-axis which is the horizontal category then type “Months”.
5. Do the same to edit the y-axis which is the vertical category and type “Gross Sales”.
6. You can further edit the text of the data in either of the axis as desired.
References: https://www.dummies.com/software/microsoft-office/excel/how-to-edit-chart-titles-in-excel-2016/
