O'Reilly logo

Microsoft® Office Excel® 2013: Part 1, 2nd Edition by Tim Barnosky

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

ACTIVITY 2-2: Inserting Functions

Data File

C:\091051Data\Performing Calculations\sales_contest.xlsx

Before You Begin

Excel 2013 is open.

Scenario

You've launched a sales contest to reward My Footprint Sports' best performing sales reps. To track their progress, you created a worksheet to store and perform calculations on the sales figures for each of the reps. You're trying to analyze the numbers to determine which sales reps will win prizes. You want to start by calculating each rep's total sales, average quarterly sales, and highest and lowest quarterly sales.

  1. Open the sales_contest.xlsx workbook file.
  2. Calculate the total sales for the first two sales reps: Del Prentice and Christina Chirillo.
    1. Select cell F7.
    2. Select

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required