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 DocumentRight 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 DocumentRight 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 DocumentRight 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 DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/08/2011 for the course BUS 311 taught by Professor Reardon,j during the Spring '08 term at University of Hawaii, Manoa.

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
Ask a homework question - tutors are online