Question

Summit Ridge has decided to add some exciting winter sports and will be hosting their own X Games competition the last weekend in January. They need a calculator to help validate and determine ticket costs. Click on the last worksheet in your Week 4 Lab file.

1. Create a formula to calculate the total cost based on price and quantity.

$Week_4_Lab_-_X_Games_5.PNG$

How do i insert formula in order to have a result like the above picture?

Thank you

Answer 1

To find the total , one has to use formula in .xls sheet as shown in picture below

null

If the cell E5 contains the price in currency format as $799.00
in the cell E6 contains the quantity of tickets 4
Write the formula in for the cell E7 as =E5*E6 (in the Formula Bar as shown in top of the image ), it will multiply the result and will display the value as $3,196.00.  To insert formula, do following

1. first click the left mouse button on cell E7.
2. type =E5*E6 at the text space just after f_x as shown in image.
3. As the formula is typed and pressed Enter key, the calculated figure is shown in the cell E7 cell position.