Exam 77-420 Microsoft Excel 2013
4. Apply Formulas and Functions
4.2 Summarize Data with Functions (Multiply, Subtract)

Fill in the Formulas

There are two equations that need to be added to this price sheet.

1. Try it: Calculate the Retail

Select Cell D3.

Type: =B3*C3


2. Try This: Calculate the Profit

Select Cell E3.
Type: =D3-B3.

Click ENTER on the keyboard.
You should see an answer: $5.00.

 

Profit is good!

Memo to Self: All good equations start with the equals sign (=).

graphic2
graphic1

 

 

graphic3