Excel 2016 Data and File Group

On the Vehicles worksheet, add subtotals to the Price column that display the combined price for each Type with a page break between each type.

data tab/ outline group/ subtotal change at each type/subtotal/page break

Beginning at cell A16 on Sheet1, import the list from the comma delimited source file MoreToys.cvs located in the GMetrixTemplates folders. (Accept all other defaults).

Data Tab/ Get & Transform Data/ Get Data

On the Home-Made Pet Food worksheet, in cell A9, import New Flavors.txt located in the GMetrixTemplates folder as a tab-delimited file without headers.

Data Tab/ Get & Transform Data/ Get Data

Simultaneously remove all duplicate records in the Wired Networks table.

Data Tab/ data tools/

Remove all duplicate records from the Food Inventory worksheet. Do not remove any other records.

Data Tab/ data tools/ Remove Duplicates

Outline both the columns and rows of the table on the Summary worksheet.

Data Tab/ outline group/ auto outline

Add the Subject Equipment Draft to the document properties.

FILE tab/ info group/ Show all properties / Subject

Add the value New Rates to the Title property of the document.

FILE tab/ info group/ Show all properties / Subject

Remove all hidden properties and personal information from the workbook.

FILE tab/ info group/ check for issues

Modify the scaling of the Sales Commissions worksheet so it fits on a single page when printed.

FILE tab/ print group/ scale to fit on one page

Save the Summary worksheet into the GMetrixTemplates folder as a PDF file with the name, Summary.

FILE tab/ save as/

Save the Computer Rooms worksheet as a webpage named Rent Prices.htm to the Gmetrix Templates folder.

FILE tab/ save as/ change file type: html