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-3: Reusing Functions

Before You Begin

The my_sales_contest.xlsx file is open.

Scenario

You need to complete your analysis of the sales figures for all sales reps so you can announce the sales contest winners at an upcoming meeting. You decide to reuse the functions you have already created for Del Prentice and Christina Chirillo for the remaining sales reps rather than create new functions for each one. Because you also need to provide commission payment figures to the payroll department before the meeting, you decide to use the same worksheet to perform the commission calculations.

  1. Use the existing functions to calculate the total and average quarterly sales for the remaining sales reps.
    1. Select cell F8.
    2. Press Ctrl+C ...

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