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-1: Creating Worksheet Formulas

Data File

C:\091051Data\Performing Calculations\new_product_income_xlsx

Before You Begin

Excel 2013 is open.

Scenario

My Footprint Sports plans to introduce four new products. Company management wants you to analyze the projected sales figures to determine how much the company can plan to profit from the new items. You have entered the sales estimates into an Excel worksheet. Now, you must use Excel formulas to get Excel to perform the calculations for you.

  1. Open the new_product_income_xlsx file.
    1. Select FILE→Open.
    2. From the Open screen, select Computer→Browse.
    3. In the Open dialog box, navigate to the C:\091051Data\Performing Calculations folder.
    4. Select the new_product_income.xlsx

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