Excel 2016 Core Data Analysis, Manipulation, and Presentation: 77-727

Correct Answer: See explanation below.

Explanation:

1.

To check the accessibility select the Review tab from the ribbon.

2.

Select Check Accessibility.

3.

Review the results.

4.

Exit the Accessibility Checker.

5.

Right-click on the worksheet then click Format and then click Alt Text.

6.

Type “Tree Nursery Inventory” in the Description box.

7.

Click OK.

References:

https://support.office.com/en-us/article/Use-the-Accessibility-Checker-to-find-accessibility-issuesa16f6de0-2f39-4a2b-8bd8-5ad801426c7f

Correct Answer: See explanation below.

Explanation:

1.

Right-click the text title “Adult_Program” and click Format Object then click Alt Text.

2.

Type “Adult Enrollment” in the Title box as desired.

3.

Click OK.

References:

https://support.office.com/en-us/article/add-alternative-text-to-a-shape-picture-chart-smartart-graphic-orother-object-44989b2a-903c-4d9a-b742-6a75b451c669#bkmk_o2016_2013

Correct Answer: See explanation below.

Explanation:

1.

Select the “Top Sellers” column chart.

2.

Click on the particular data point you want to label, click Add Chart Element +, from the upper right corner next to the chart, then select Data Labels.

3.

Then click Format Data Labels.

4.

The Data Label Range dialog box would appear, select the data range which are the cell values you want to appear in the labels, in this case it would be the “Total” colunn for “Fruits”, “Vegetables”, and “Jams and Honey”, then click OK.

References:

https://support.office.com/en-us/article/add-or-remove-data-labels-in-a-chart-884bf2f1-2e29-454e-8b42f467c9f4eb2d