EXCEL 2A Watch the Excel Chapter 2 Video and review the Excel Chapter 2 PowerPoi

EXCEL 2A
Watch the Excel Chapter 2 Video and review the Excel Chapter 2 PowerPoint BEFORE starting your project.
Project must be completed using MS Excel.
Project must be submitted as an MS Excel file.
Begins on Page 386
You will save and submit both standard view and formula view files
Using your data files and textbook, navigate to Excel, Project 2A, Use Flash Fill and SUM, AVERAGE, MEDIAN, MIN, and MAX Functions.
Follow the directions beginning on Page 386 and complete the project.
There are screen shots included to help you when following many of the steps in the textbook. Turn the page if you are not sure what to do to find a picture of the screen.
To help those of you who could not see the two types of files when you were submitting in Module 6, I have changed the way to upload your work for Excel.
You will save and submit both:
A standard view and submit as a PDF and formula view as an Excel file for your spreadsheets.
Lastname_Firstname_2A_Tree_Inventory (this is an Excel file)
Lastname_Firstname_2A_Tree_InventoryFormulas (this can be an Excel or PDF file)
These are the SAME file, just with two different names and formats.
You MUST submit the formula view or the project will not be graded.
In the formula view you MUST widen the columns to display the entire formula; do not leave any cells with the ##### which just means you need to widen the cell.
EXCEL 2B (Begins on Page 412)
Lastname_Firstname_2B_Weekly_Sales (this is an Excel file)
Lastname_Firstname_SB_Weekly_SalesFormulas (this can be an Excel or PDF file)
EXCEL 2G
Project must be completed using MS Excel, beginning on Page 452-454.
Lastname_Firstname_2G_ Inventory
Lastname_Firstname_2C_ Inventory_Formulas