Arithmetic operators in Google Sheets - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants you to calculate the total price, tax amount, and final price for each product sold.

📊 Data: You have a list of products with their unit price and quantity sold. The sales tax rate is 8%.

🎯 Deliverable: Create a spreadsheet that calculates the total price before tax, the tax amount, and the final price including tax for each product.

Sample Data

Product	Unit Price	Quantity Sold
Notebook	2.50	10
Pen	1.20	15
Eraser	0.50	20
Marker	3.00	5
Folder	1.75	8

1

Step 1: Calculate the total price before tax for each product by multiplying Unit Price by Quantity Sold.

=B2*C2

Expected Result

Notebook total price: 25.00

2

Step 2: Calculate the tax amount for each product by multiplying the total price by the tax rate (8%).

=D2*0.08

Expected Result

Notebook tax amount: 2.00

3

Step 3: Calculate the final price including tax by adding the total price and the tax amount.

=D2+E2

Expected Result

Notebook final price: 27.00

4

Step 4: Copy the formulas down for all products to calculate total price, tax amount, and final price for each.

Drag formulas in columns D, E, and F down from row 2 to row 6.

Expected Result

All products have total price, tax amount, and final price calculated.

Final Result

Product   Unit Price  Quantity Sold  Total Price  Tax Amount  Final Price
Notebook  2.50        10             25.00        2.00        27.00
Pen       1.20        15             18.00        1.44        19.44
Eraser    0.50        20             10.00        0.80        10.80
Marker    3.00        5              15.00        1.20        16.20
Folder    1.75        8              14.00        1.12        15.12

✓The total price is calculated by multiplying unit price and quantity sold.

✓The tax amount is 8% of the total price.

✓The final price is the sum of total price and tax amount.

✓This helps the manager see the exact amount earned including tax for each product.

Bonus Challenge

Add a new column that calculates the discount price if a 10% discount is applied before tax.

Show Hint

Calculate discount price as Total Price * 0.90, then calculate tax on the discounted price.

Practice

1. Which arithmetic operator in Google Sheets is used to multiply two numbers?

easy

A. +

B. *

C. /

D. ^

Solution

1. Step 1: Recall basic arithmetic operators

   The multiplication operator in spreadsheets is the asterisk symbol *.

2. Step 2: Match operator to multiplication

   Among the options, only * represents multiplication.

3. Final Answer:

   * -> Option B

4. Quick Check:

   Multiplication = * [OK]

Hint: Remember * means multiply in formulas [OK]

Common Mistakes:

• Confusing + with multiplication
• Using ^ for multiplication
• Using / instead of *

2. Which of the following is the correct formula to add the values in cells A1 and B1 in Google Sheets?

easy

A. =A1+B1

B. A1+B1

C. =SUM(A1 B1)

D. =A1*B1

Solution

1. Step 1: Understand formula syntax

   Formulas must start with an equals sign = to calculate values.

2. Step 2: Identify correct addition syntax

   The correct way to add two cells is =A1+B1. =A1*B1 multiplies instead, A1+B1 misses the equals sign, and =SUM(A1 B1) has wrong syntax.

3. Final Answer:

   =A1+B1 -> Option A

4. Quick Check:

   Formula starts with = and uses + for addition [OK]

Hint: Always start formulas with = and use + for addition [OK]

Common Mistakes:

• Omitting = at start
• Using * instead of +
• Wrong SUM syntax without comma

3. What is the result of the formula =10 + 5 * 2 in Google Sheets?

medium

A. 20

B. 15

C. 30

D. 25

Solution

1. Step 1: Apply order of operations

   Multiplication (*) is done before addition (+), so calculate 5 * 2 = 10 first.

2. Step 2: Add the results

   Then add 10 + 10 = 20.

3. Final Answer:

   20 -> Option A

4. Quick Check:

   Multiplication before addition = 20 [OK]

Hint: Multiply before adding in formulas [OK]

Common Mistakes:

• Adding before multiplying
• Ignoring operator precedence
• Calculating left to right only

4. The formula =A1 + * B1 gives an error in Google Sheets. What is the correct fix?

medium

A. =A1 + (B1

B. =A1 * B1

C. =A1 + B1 *

D. =A1 + B1

Solution

1. Step 1: Identify syntax error

   The formula has an invalid operator sequence + * which is not allowed.

2. Step 2: Correct the formula

   Remove the extra operator to get =A1 + B1, which adds the two cells correctly.

3. Final Answer:

   =A1 + B1 -> Option D

4. Quick Check:

   Only one operator between operands [OK]

Hint: Use only one operator between values [OK]

Common Mistakes:

• Using two operators together
• Leaving trailing operators
• Missing equals sign

5. You want to calculate the total cost in cell C1 by multiplying quantity in A1 by price in B1, then adding a fixed shipping fee of 5. Which formula correctly does this?

hard

A. =A1 * (B1 + 5)

B. A1 * B1 + 5

C. =(A1 * B1) + 5

D. =A1 + B1 * 5

Solution

1. Step 1: Understand calculation order

   You must multiply quantity and price first, then add shipping fee.

2. Step 2: Use parentheses to ensure correct order

   Formula =(A1 * B1) + 5 ensures multiplication happens before addition. A1 * B1 + 5 misses the equals sign; C adds shipping to price before multiplying (wrong); D multiplies price by 5 then adds quantity (wrong).

3. Final Answer:

   =(A1 * B1) + 5 -> Option C

4. Quick Check:

   Multiply first, then add shipping with parentheses [OK]

Hint: Use parentheses to control calculation order [OK]

Common Mistakes:

• Adding before multiplying
• Wrong operator placement
• Missing parentheses causing wrong results