Home » Microsoft » 77-727 » SIMULATION
SIMULATION
Overview
The city events manager wants to analyze the enrollment changes over the past five years for various adult and youth sports programs. You have been tasked to prepare tables for the analysis.
On the “Adult Program” worksheet, insert a Column sparkline for each sport that shows the enrollment for the past five years.
Correct Answer: See explanation below.
Explanation/Reference:
Explanation:
1. On the “Adult Program” worksheet, select the area you want the sparkline to be inserted.
2. Click Column in the Sparklines group from the Insert tab.
3. Enter the range of cells in the Data Range box, in this case A10:A19.
OR
3. Select the range of cells by temporarily collapsing the dialog box and manually selecting the cells.
4. Click OK and the Sparkline Tools will appear, the Design tab can be used to customize the sparklines.
References: https://support.office.com/en-us/article/analyze-trends-in-data-using-sparklines-be6579cf-a8e3-471a-a459-873614413ce1