{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Copy of InClass_Excel_2007_Examples_All_Tasks_Completed

Copy of InClass_Excel_2007_Examples_All_Tasks_Completed -...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
SAVE OPTIONS Excel Workbook (*.xlsx) - No macros in 2007 workbook Excel Macro-Enabled Workbook (*.xlsm)  - Macro enabled 2007 workbook Excel Template (*.xltx) – No macro template Excel Macro-Enabled Template (*.xltm) – Template containing macros Excel Binary Workbook (*.xlsb) - Large workbooks with no XML support Excel 97 - Excel 2003 Workbook (*.xls)     Microsoft Excel 5.0/95 Workbook (*.xls)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Product Qrt 1 Qrt 2 Qrt 3 Qtr 4 Q1 to Q2 % Growth Product A $2,456.00 $3,456.00 $7,645.00 $9,174.00 40.72% Product B $3,567.00 $8,734.00 $4,353.00 $5,223.60 144.86% Product C $2,765.00 $6,145.00 $5,363.00 $6,435.60 122.24% Product D $6,578.00 $1,541.00 $4,242.00 $5,090.40 -76.57% Fourth Quarter Growth Projection 0.2 Tasks:  1. Calculate the % Increase from Q1 to Q2 2. Calculate the % Growth from Q2 to Q3 3. Should we anchor the column, row, both or no cell references so we can just cop 4. Project the Qtr 4 Sales as 20% increase from Qtr 3 sales using the 20% number  5.  Do we need to anchor cell E8?  Should we fully anchor it, or just the row or colum 6. Define a named range for cell E8. 7.  Redo step 4 using the named range.  Notice that there is no longer a reason to a 8. Format the quarterly sales as currency with no decimal places 9.  Format the percentages as percentages 10. Calculate the quarterly versus target: Column B / Column H, Column C/Column  11. Format those cells as percentages. 12. Freeze the row and columns starting in cell B3 13. Create a Column & Line Chart that looks like the following.
Background image of page 2
Q2 to Q3 % Growth Quarterly Target Q1 vs Target Q2 vs. Target Q3 vs. Target 121.21% $5,000 49.12% 69.12% 152.90% -50.16% $5,500 64.85% 158.80% 79.15% -12.73% $5,150 53.69% 119.32% 104.14% 175.28% $3,000 219.27% 51.37% 141.40% py paste the formula to the other cells? r in E8. mn?  anchor the cell references  H, etc.  Only type the formula once and copy it to the remaining cells.  How do we have to Qrt 1 Qrt 2 Qrt 3 Q $0 $1,000 $2,000 $3,000 $4,000 $5,000 $6,000 $7,000 $8,000 $9,000 $10,000 Sample Quarter Sales USD
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
o anchor the cell? Qtr 4 $0 $1,000 $2,000 $3,000 $4,000 $5,000 $6,000 rly Report Product A Product B Product C Product D Quarterly Target Sales USD
Background image of page 4
Salesperson (All) 0 2 4 6 8 10 12 Salesp Number of Tickets Sold
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
0 2 4 6 8 10 12 person Ticket Sales USDs
Background image of page 6
Date Sold Month Text_Month Year Salesperson 2/15/2007 2 February 2007 Lisa 3/3/2007 3 March 2007 Bob 1/28/2007 1 January 2007 Lisa 1/15/2007 1 January 2007 Bob 3/6/2007 3 March 2007 Vivien 2/1/2007 2 February 2007 John 4/5/2007 4 April 2007 Andrew 2/11/2007 2 February 2007 Bob 2/9/2007 2 February 2007 John 1/19/2007 1 January 2007 John 1/30/2007 1 January 2007 Heather 2/27/2007 2 February 2007 Vivien 3/13/2007 3 March 2007 John
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '08
  • Reardon,J
  • Options, France Poland Indonesia Japan India UAE Egypt India Egypt Indonesia Poland UAE Japan Japan France Egypt India Indonesia Poland France Egypt India Poland UAE Japan France France Poland UAE Japan Egypt India UAE Egypt Indonesia, Area code 208, Eastern Washington, Unspecified Eastern Washington, Eastern Washington Business

{[ snackBarMessage ]}

Page1 / 28

Copy of InClass_Excel_2007_Examples_All_Tasks_Completed -...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon bookmark
Ask a homework question - tutors are online