Deliverable 3 – Exercises – Submit one spreadsheet with Tab names as shown in ( ) and bold. In ALL cases, make up your own data; and DO NOT use the data provided in the exercise. Also, leave all formulas.
Complete the entire section of
Workbook Title: Excel Quick Tips_FirstNameLastName
Work with stock and geography data (Stock & Geo)
Fill in contents with Flash Fill (Flash Fill)
Extract part of a cell’s contents (Extract)
Find name ranges (Name)
Transpose data from vertical to horizontal (Transpose)
Conditional formatting by cell contents (Conditional)
Collaborate on an Excel file with others (Co-authoring) Save to one-drive and share with [email protected]. Please create similar (not same) charts as on the sheet.
Add and reference worksheets (TOC) – Note – this is your Table of Contents. Title and Reference. You should have 2 columns (Name) and Reference. You should have a Title Row and 7 additional rows as follows in the Name Column:
Work with stock and geography data
Fill in contents with Flash Fill
Extract part of a cell’s contents
Find name ranges
Transpose data from vertical to horizontal
Conditional formatting by cell contents
Collaborate on an Excel file with others
In summary for Deliverable 3, one workbook, with 8 sheets: Stock & Geo, Flash Fill, Extract, Name, Transpose, Conditional, Co-authoring, TOC
