Correct Answer: See explanation below.

Explanation:

1.

On the “Customers” worksheet, click the Select All button OR press Ctrl+A.

2.

Click the arrow next to Conditional Formatting from the Home tab in the Styles group, then select New Rule.

3.

Click Select a Rule Type in the New Formatting Rule dialog box, then select Use a formula to determine which cells to format.

4.

In the Format values where this formula is true box, enter =MOD(ROW(),2)=0.

5.

Click on Format.

6.

Click the Fill tab from the Format Cells dialog box.

7.

Select the desired shade background and then click OK, you are able to view how the background would look in the Preview window in the New Formatting Rule dialog box.

8.

Once satisfied, apply the formatting to the cells by clicking OK.

References: https://support.office.com/en-us/article/Apply-shading-to-alternate-rows-in-a-worksheet-A443B0F5-202542F6-9099-5DE09C05E880

Correct Answer: See explanation below.

Explanation:

1. Click Find and Select from the Home tab then click on Go To. OR

1.

Press Ctrl+G on the keyboard.

2.

Double-click the name range you want, in this case “Oregon”.

3.

Delete the contents in the selected cells by pressing Delete on your keyboard. References:

https://support.office.com/en-us/article/Find-named-ranges-14513DF5-0D79-4CD5-9A03-968905B244E6

Correct Answer: See explanation below.

Explanation:

1.

Click Sort Sheets from the Worksheet group in the Kutools Plus tab.

2.

Click the Alpha sort button OR the Alpha Numeric Sort button in the Sort Sheets dialog box, the results can be previewed in the New sheets tab order list box.

3.

Use the Move up or Move down button to manually change the order of the sheets so that the “$5,000 Donors” worksheet is first in the New sheet tabs order list.

4.

Click OK once satisfied with the results.

References:

https://www.extendoffice.com/product/kutools-for-excel/sort-worksheets-in-one-workbook-in-alphabeticalorder.html

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.

On the “Car Inventory” worksheet, click Print Titles from the Page Setup group, situated on the PageLayout tab.

2.

Under Print Titles, on the Sheet tab, type the reference of the row you want to reappear (row 9) in the Rows to repeat at top box.

References:

https://support.office.com/en-us/article/Print-rows-with-column-headers-on-top-of-every-page-D3550133F6A1-4C72-AD70-5309A2E8FE8C

Correct Answer: See explanation below.

Explanation:

1.

On the “Youth Program” worksheet, select Format as Table from the Home tab.

2.

Choose the desired style for the table.

3.

Select the desired cell range of A9:G19 in the Format as Table dialog box.

4.

Mark row 9 as a header.

5.

Click OK.

References:

https://support.office.com/en-us/article/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664

Correct Answer: See explanation below.

Explanation:

1. In cell M9, on the “Summer Bookings” worksheet, insert the following COUNTIF formula: “=COUNTIF (G6:G24, >= 12”)”

References:

https://support.office.com/en-us/article/count-numbers-greater-than-or-less-than-a-number-453b0ccc-cfaa4332-ad02-6e148e01aa0a

Correct Answer: See explanation below.

Explanation:

1.

Select the data you would like to use, in this case it would be the data in the “Products” and “Total” columns from the “Summer Sales” worksheet.

2.

Click on Insert Pie Chart situation on the Insert tab then pick the 3-D Pie chart as desired.

3.

Format the chart as desired by using Chart Elements, the Chart Styles, or the Chart Filters.

4.

Drag the Pie Chart to the desired location which is to the right of the column charts.

References:

https://support.office.com/en-us/article/Add-a-pie-chart-1A5F08AE-BA40-46F2-9ED0-FF84873B7863

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