Excel 2016 Data and File Group

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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


Ensembles d'études connexes

Biblical Financial decision making (pie diagram)

View Set

Questions - Application Security

View Set

Pesthy A&P 2 Test #2 Respiratory system

View Set

Culture Set 2, Culture Set 3, Culture Set 1

View Set

Biology II - Chapter 5: Hypertonic and Hypotonic Solutions

View Set

BSC 118: Chapter 12 My Labs Plus

View Set