Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.3. Apply cell references in formulas: Relative

 

Memo to Self: The equation is different in each row. For example, the formula in Cell D5 would be =B5*C5. This is an example of a RELATIVE cell reference,

Add It All Up

So what is the retail price? The equation would be the Cost times the Markup.

6. Calculate the Retail Price

Click on Cell D2 to begin. Now, all equations in Excel start by entering the “=” sign. You will find it on your keyboard by the numbers row, a few buttons to the right of the 9.

The math will look like this: =B2*C2, where the multiply sign is the asterisk above the number 8 on your keyboard. You can type in the cell references for B2 and C2, or you can click on the cells.

Excel won’t calculate until you leave the cell. When you are done with the equation use the Tab or Enter key on your keyboard.

 

The correct answer is $3.75.

 

Enter the formula for the other items in the fruit basket.