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