Vgfdsh

|Name: Claudia Sarahi navarro Sánchez |Registration: 2661732 |
|Course title:|Teacher’s name: |
|Computer science |MCC Guadalupe del Rosario Montero Paz ||Module: |Activity: |
|Advanced exel |Usingformulas and functions |
| | |
|| |
|Date: 18 deabril del 2012 |Team: N/A|
|Bibliography: |
|MicrosoftOffice Excel 2007 Updated First Edition, Exam 77-602, Microsoft Official Academic Course, John Wiley & Sons. |

Excercises to solve:
I.- Blue Horizon Expenses exercise.
1. Open theBlue Horizon Expenses workbook located in the folder with the files for this lesson. The active sheet should be the Expense History.
2. Select cell B8 and then click on AutoSum to calculate the totalfor the year 2005.
3. Copy the formula in cell B8 to cells C8:F8.
4. Select cell F4 and click AutoSum to calculate the total expense of the corporate contracts over the 4 years period.
5.Copy the formula in cell F4 to range F5:F7
6. In the cell B12, create a new formula to calculate the increment percentage of the corporate contract expense from the year 2005 to 2006. Start...