eLearning Excel Introduction

eLearning Home

Excel Introduction

1. Unit 1: Getting Started
2. Unit 2: Entering and editing data
3. Unit 3: Modifying a Worksheet
   1. Moving and copying data
   2. Moving and copying formulas
   3. Inserting ranges
   4. Deleting ranges
   5. Unit 3 Practice Activity
4. Unit 4: Using Functions
5. Unit 5: Formatting Worksheets
6. Unit 6: Printing
7. Unit 7: Creating Charts

Unit 3 Practice Activity

1. Open Practice sales summary.xls.
2. Delete the row containing the 2002 figures (row 3).
3. Insert a new row between rows 1 and 2. Enter the heading Sales 2003-2007 into cell A2.
4. Enter a formula to calculate the total sales for 2003 in F4.
5. Use the AutoFill handle to copy the year total formula from F4 to F5:F7.
6. In B8, enter formula that will calculate predicted sales for each quarter in 2007.
   For 2007, sales in each quarter are predicted to increase by 2% (on average) from same quarter in the previous year. Note that 2% has been entered into cell E10 to be used as part of the formula.
7. Copy the formula in B8 to C8:E8. Check your formula results in C8:E8 - if the quarterly results are the same as those in the previous year then the formula in B8 needs correcting.
8. Change the percentage in B8 from 2% to 1.5%. The predicted sales for 2007 should automatically recalculate once the percentage has been altered.
9. Copy the formula from F7 down to F8, so total predicted sales for 2007 show in the spreadsheet.
10. Save the workbook as My practice sales summary and close the workbook.

Online support forum and knowledge base

www.microsofttraining.net/forum

Visit our forum to have your questions answered by our Microsoft certified trainers.

Unit 3 Practice Activity solution

Upon completion of Unit 3 Practice Activity your formulas should match those shown below.

Use Ctrl + the 'pipe' key (directly below the Esc key) to view formulas in your spreadsheet.

Notes

• Formulas in column F are created using the AutoSum button
• Formula in row 8 uses an absolute reference - when the cell E10 is entered into the formula, press the F4 key to create an absolute reference ($E$10).