Relative references in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales assistant at a 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 a new column that calculates the total price for each product using relative references so the formula can be copied down easily.

Sample Data

Product	Quantity Sold	Unit Price
Apples	10	0.5
Bananas	5	0.3
Oranges	8	0.6
Grapes	3	1.2
Peaches	7	0.8

1

Step 1: Insert a new column to the right of 'Unit Price' and name it 'Total Price'.

Expected Result

A new column labeled 'Total Price' appears next to 'Unit Price'.

2

Step 2: In the first cell under 'Total Price' (D2), enter a formula to multiply the quantity sold by the unit price using relative references.

=B2*C2

Expected Result

Cell D2 shows 5 (10 * 0.5).

3

Step 3: Copy the formula from D2 down to all rows in the 'Total Price' column.

Drag the fill handle from D2 down to D6.

Expected Result

Cells D3 to D6 show the total prices: 1.5, 4.8, 3.6, 5.6 respectively.

Final Result

Product   Quantity Sold   Unit Price   Total Price
Apples          10           0.5           5.0
Bananas          5           0.3           1.5
Oranges          8           0.6           4.8
Grapes           3           1.2           3.6
Peaches          7           0.8           5.6

✓Using relative references allows the formula to adjust automatically for each row.

✓Total price is correctly calculated by multiplying quantity sold by unit price for each product.

Bonus Challenge

Add a new column that calculates a 10% discount on the total price for each product.

Show Hint

Use a formula that multiplies the total price by 0.9 using relative references.