|
|
1.
Products.htm printed from the web (Your Name included on page cell C8)
2.
Screen
Snapshot of all files included in Excel Project 1 including Hands-On & On
Your Own
Excel Project 2 Including Hands-On 1 & 2
Hand
in
1.
Screen shot of Window containing all workbooks & workspaces
2.
Screen shot of Selections.xls with Indianapolis
sheet selected
3.
Sales Summary (By Store) sheet in Landscape
(fit to one page)
Formulas
of (CTRL + ~)Sales Summary (By Store) sheet in Landscape (fit to one page)
EXCELProject 3 Insert your name and proj. 3 into the right side of the Header
Hand
in
1.
Print
Product sorted by Product Number page EX-94
2.
Print Sales Summary sheet of Selections Prototype.xls. in subheading
views. There are 3 views to expand , print all 3 sheets
EXCEL Project 4 Insert your name and project 4 into the right side of the Header
Hand
in
1.
Completed
Boston sheet
2.
Completed
Summary Sheet
3.
Formulas
of Summary Sheet in Landscape (fit to 1 page)
EXCEL Project 5 Insert your name and proj.
5 into the right side of the Header
Hand
in
1.
From
Orders.xls print out (Landscape,fit to one page): Pivot Table of Item
Description By Date pEX_157
2.
From
Orders.xls print out Pivot Table /Accessories
Category p. EX-158
3.
From
Orders.xls print out a Screen shot of Description By Date (Chart)with
Electronics selected.
4.
From
Orders.xls print out the Pivot Table, Showing Product ID from your Browser
EXCEL PROJECT
6 HAND IN with name and project # in the
header of each paper
Hand
in
1.
Screen Snapshot of: Sales Analysis.xls with ByGender Sheet selected
2.
Screen Snapshot of: Selections
Sales Analysis.xls with By Region ANOVA Sheet selected
3.
Screen Snapshot of: Selections
Sales Analysis.xls with SalesData Sheet selected(map included)
Hand in
1.
Screen Snapshot of: Retirement Calculator.xls with Adjusted Retirement Sheet selected
2.
Screen Snapshot of: Selections
R-E Values.xls with Sales Summary sheet selected
3.
Screen Snapshot of: Solver Data.xls with Boston sheet selected