Copy of InClass_Excel_2007_Examples

Copy of InClass_Excel_2007_Examples - SAVEOPTIONS

Info iconThis preview shows pages 1–7. 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 2456 3456 7645 Product B 3567 8734 4353 Product C 2765 6145 5363 Product D 6578 1541 4242 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 $5,000 $5,500 $5,150 $3,000 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
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?
Background image of page 4
Date Sold Month Text_Month Year Salesperson 2/15/2007 Lisa 3/3/2007 Bob 1/28/2007 Lisa 1/15/2007 Bob 3/6/2007 Vivien 2/1/2007 John 4/5/2007 Andrew 2/11/2007 Bob 2/9/2007 John 1/19/2007 John 1/30/2007 Heather 2/27/2007 Vivien 3/13/2007 John 4/13/2007 Lisa 4/1/2007 John 3/28/2007 Lisa 3/16/2007 John 4/22/2007 Vivien 4/5/2007 John 4/9/2007 Vivien 3/6/2007 Vivien 2/2/2007 Lisa 1/23/2007 Vivien 3/3/2007 Andrew 1/2/2007 Andrew 1/19/2007 Andrew 4/2/2008 Bob 4/12/2007 Lisa 4/1/2007 Lisa 3/16/2007 Vivien 3/11/2007 Bob 2/11/2007 Andrew 2/19/2007 Bob 2/19/2007 Heather 4/15/2007 Heather
Background image of page 5

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

View Full DocumentRight Arrow Icon
Destination France 3 Poland 2 Indonesia 4 Total Tickets Sold (SU Japan 2 Most Tickets Sold (MA India 3 Least Tickets Sold (M UAE 1 Average Number of T Egypt 1 India 2 Tasks: Egypt 2 1. Extract the month f Indonesia 3 2. Extract the year fro
Background image of page 6
Image of page 7
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 / 23

Copy of InClass_Excel_2007_Examples - SAVEOPTIONS

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

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