Correct Answer: See explanation below.

Explanation:

1.

Select cell A5 of the “$5,000 Donors” worksheet where you want the source file to be imported to.

2.

Click on File, then select Open.

3.

Select Text Files from the Open dialog box.

4.

Locate the contributors.txt file in the Documents folder, then double-click it.

5.

Click Finish to complete the operation.

References:

https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b339e391393ba

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.

In cell J10 on the “Car Inventory” worksheet enter “=G10 *.95” OR “=G10 * 95%”.

2.

Select cell J10, hold the Shift key on your keyboard, and use the down arrow key until all the cells the formula is required to be applied (J40).

3.

Hold down the Ctrl key on your keyboard and press D which would “copy down” the formula for the rows below.

OR

1.

In cell J10 on the “Car Inventory” worksheet enter “=G10 *.95” OR “=G10 * 95%”.

2.

Select cell J10, then Right-click and select Copy, OR click Copy from the Clipboard group situated on the Home tab.

3.

Paste the formula by selecting Paste from the Clipboard group situated on the Home tab, OR Right-click then select Paste, OR click Paste from the Clipboard group situated on the Home tab, then click Paste Special and select Formulas, OR you could select Values for the formula results instead.

4.

Verify that the cell references in the formula are as desired.

References:

https://www.excelforum.com/excel-general/745891-calculate-discount-for-full-column.html

https://support.office.com/en-us/article/move-or-copy-a-formula-1f5cf825-9b07-41b1-8719-bf88b07450c6

Correct Answer: See explanation below.

Explanation:

1.

On the “Inventory” table, click on any cell.

2.

Click on Format as Table from the Home tab.

3.

Select the Rose, Table Style Light 17 as desired.

References:

https://support.office.com/en-us/article/Format-an-Excel-table-6789619F-C889-495C-99C22F971C0E2370

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. In cell M10 on the “Summer Bookings”, insert the following SUMIF formula: “=SUMIF(G6:G24, “andgt;= 12”, I6:I24).”’

References:

https://support.office.com/en-us/article/SUMIF-function-169B8C99-C05C-4483-A712-1697A653039B

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.

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.

References:

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

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