Correct Answer: See explanation below.

Explanation:

1.

Select the cells in the “CustomerID” column which you want to have checked for duplicates.

2.

Select Remove Duplicates from the Data tab.

3.

Select the “CustomerID” column which you want to have checked under the Columns options.

4.

Click OK.

References:

https://support.office.com/en-us/article/Find-and-remove-duplicates-00E35BEA-B46A-4D5D-B28E66A552DC138D

Correct Answer: See explanation below.

Explanation:

1.

Click on cell C3.

2.

Enter the following formula: “=HYPERLINK([email protected], C3)

References:

https://support.office.com/en-us/article/HYPERLINK-function-333C7CE6-C5AE-4164-9C477DE9B76F577F

Correct Answer: See explanation below.

Explanation:

1.

Select the rows you want to hide, in this case rows number 29 and 30 by clicking on them.

2.

Right-click on the selected rows then click Hide.

References:

https://support.office.com/en-us/article/Hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614dde8443579f8

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.

Click on the 3-D Pie Chart on the “Spring Sales” worksheet.

2.

This would display the Chart Tools, click on the desired style which is Style 3 Monochromatic Color 2 from the Chart Styles group situated on the Design tab.

References:

https://support.office.com/en-us/article/Change-the-layout-or-style-of-a-chart-A346E438-D22A-4540-AA87BCE9FEB719CF