EXCEL 1A Project must be completed using MS Excel. Project must be submitted as

EXCEL 1A
Project must be completed using MS Excel.
Project must be submitted as an MS Excel file.
Begins on Page 316 and ends on Page 344
You will save and submit both standard view and formula view files
Using your data files and textbook, navigate to Excel, Project 1A, Sales Report with Embedded Column Chart & Sparklines.
Follow the directions beginning on Page 316 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.
You will save and submit both a standard view and formula view your spreadsheets.
Lastname_Firstname_1B_Quarterly_Sales
Lastname_Firstname_1B_Quarterly_Sales_Formulas
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 1D
Project must be completed using MS Excel.
Project must be submitted as an MS Excel file.
Begins on Page 373 and ends on Page 375.
Complete all steps.
You will save and submit both standard view and formula view files
Using your data files and textbook, navigate to Excel, Project 1D, Band and Tubing Inventory
Follow the directions beginning on Page 373 and complete the project.
Review the project rubric and example with hints for details.
You will save and submit both a standard view and formula view your spreadsheets.
Lastname_Firstname_1D_Band&Tubing
Lastname_Firstname_1D_Band&Tubing_Formulas
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
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 412.
You will save and submit both standard view and formula view files
Using your data files and textbook, navigate to Excel, Project 2B, Weekly Sales Summary.
Follow the directions beginning on Page 412 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_2B_Weekly_Sales (this is an Excel file)
Lastname_Firstname_SB_Weekly_SalesFormulas (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 2G
Project must be completed using MS Excel, beginning on Page 452-454.
Project must be submitted as an MS Excel file.
Complete all steps.
You will save and submit both standard view and formula view files
Using your data files and textbook, navigate to Excel, Project 2G, Inventory
You will save and submit both a standard view and formula view your spreadsheets.
Lastname_Firstname_2G_ Inventory
Lastname_Firstname_2C_ Inventory_Formulas