Microsoft Exam 77-727 Topic 1 Question 37 Discussion

Actual exam question for Microsoft's exam

Question #: 37
Topic #: 1

SIMULATION

Project 7 of 7: Farmers Market

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

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

B1. 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. Do the same to edit the y-axis which is the vertical category and type ''Gross Sales''.
4. You can further edit the text of the data in either of the axis as desired.

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!