Excelspreadsheet~10 mins

Formula structure (=, cell references) in Excel - Real Business Scenario

Choose your learning style9 modes available

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

Scenario Mode

👤 Your Role: You are a sales assistant at a small retail store.

📋 Request: Your manager wants you to calculate the total price for each product sold by multiplying the quantity sold by the unit price.

📊 Data: You have a list of products with their quantities sold and unit prices in a table.

🎯 Deliverable: Create formulas to calculate the total price for each product using correct formula structure and cell references.

Progress0 / 4 steps

Sample Data

Product	Quantity Sold	Unit Price
Apples	10	0.50
Bananas	5	0.30
Oranges	8	0.60
Grapes	3	1.20
Pears	7	0.80

Step 1: Click on the first empty cell in the 'Total Price' column next to 'Apples'.

Expected Result

Step 2: Type the formula to multiply quantity sold by unit price. Start with an equal sign (=), then click the cell with quantity sold, type an asterisk (*), then click the cell with unit price.

=B2*C2

Expected Result

Step 3: Press Enter to see the total price for Apples.

Expected Result

Step 4: Copy the formula down the 'Total Price' column for the other products by dragging the fill handle from the first formula cell down to the last product.

Expected Result

Final Result

Product   Quantity Sold   Unit Price   Total Price
Apples          10           0.50          5.00
Bananas          5           0.30          1.50
Oranges          8           0.60          4.80
Grapes           3           1.20          3.60
Pears            7           0.80          5.60

✓Using '=' starts a formula in Excel.

✓Cell references like B2 and C2 tell Excel which cells to use.

✓The asterisk '*' means multiply.

✓Copying the formula down applies it to other rows automatically.

Bonus Challenge

Modify the formula to add a 10% sales tax to the total price for each product.

Show Hint