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

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

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top