Are You Making Any Money?

Profit is what you make after you pay for the costs. In our example, the equation is: =D2-B2.

3. Try This: Calculate the Profit

Select Cell E1 and type the label: Profit.

Select Cell E2 and enter the equation:

=D2-B2

 

Copy and paste that equation into Cells E3 through E5.

4. Add This, Too: Sum up the Profit

Select Cell E6.

Go to AutoSum.

 

What Do You See? For each fruit basket that you sell, there is a profit of $4.25.

Home -> Editing ->AutoSum

 

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.3. Apply cell references in formulas: Relative