Microsoft Exam 77-727 Topic 1 Question 37 Discussion

Actual exam question for Microsoft's exam

Question #: 37
Topic #: 1

[All Questions]

SIMULATION

Project 5 of 7: City Sports

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.

A1. 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.

B1. 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:A18.
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.

Show Suggested Answer

Suggested Answer: A

References:

https://www.dummies.com/software/microsoft-office/excel/how-to-edit-chart-titles-in-excel-2016/

by Dierdre at Dec 12, 2022, 05:03 AM

Limited Time Offer

25%

Off

Get Premium Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!