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
4. Unit 4: Using Functions
   1. Using AutoSum
   2. Entering functions
   3. Unit 4 Practice Activity
5. Unit 5: Formatting Worksheets
6. Unit 6: Printing
7. Unit 7: Creating Charts

Unit 4 Practice Activity

1. Open My Practice sales summary.xls. This is the file you worked on for the Unit 3 Practice Activity.
2. Enter the labels Average, Minimum and Maximum into cells G3, H3 and I3 respectively.
3. In cell G4, enter a function to calculate the average quarterly sales for 2003. Copy the formula down to row 8.
4. In cell H4, enter a function to calculate the lowest quarterly sales value for 2003. Copy the formula down to row 8.
5. In cell I4, enter a function to calculate the highest quarterly sales value for 2003. Copy the formula down to row 8.
6. Save the changes made to My Practice sales summary and close the file.

Online support forum and knowledge base

www.microsofttraining.net/forum

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

Unit 4 Practice Activity solution

Upon completion of Unit 4 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

Functions can be entered into columns G, H and I using any one of the three methods outlined in the Unit 4 notes (using the Insert Function button, using the AutoSum list or by entering functions manually into the spreadsheet).