Arithmetic operators in formulas in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

Calculate the result of a mixed arithmetic formula

What is the value in cell A1 if the formula =5 + 3 * 2 - 4 / 2 is entered?

A 11

B 10

C 9

D 8

💡 Hint

Remember the order of operations: multiplication and division happen before addition and subtraction.

The formula calculates as 5 + (3 * 2) - (4 / 2) = 5 + 6 - 2 = 9.

❓ Function Choice

intermediate

Choose the correct formula to calculate total cost

You have quantity in cell B2 and price per item in C2. Which formula correctly calculates total cost with a 10% tax added?

A =B2 * C2 * 1.10

B =B2 * C2 + 10%

C =B2 + C2 * 1.10

D =B2 * (C2 + 10%)

💡 Hint

Tax is 10% of the total price, so multiply total by 1.10.

Option A multiplies quantity by price, then adds 10% tax by multiplying by 1.10.

📊 Formula Result

advanced

Evaluate a formula with parentheses and mixed operators

What is the result of the formula = (8 + 2) * (5 - 3) / 2?

A 20

B 10

C 5

D 15

💡 Hint

Calculate inside parentheses first, then multiply and divide from left to right.

(8 + 2) = 10, (5 - 3) = 2, so formula is 10 * 2 / 2 = 20 / 2 = 10.

🎯 Scenario

advanced

Fix the formula to correctly calculate average cost per item

You want to calculate average cost per item. You have total cost in A1 and number of items in B1. Which formula correctly calculates average cost?

A =A1 + B1

B =B1 / A1

C =A1 * B1

D =A1 / B1

💡 Hint

Average cost is total cost divided by number of items.

Option D divides total cost by number of items, giving average cost per item.

❓ data_analysis

expert

Determine the number of items with positive profit

Column A has costs, column B has revenues. Which formula counts how many items have revenue greater than cost?

A =SUMPRODUCT(--(B1:B10 > A1:A10))

B =COUNTIF(B:B, ">" & A:A)

C =COUNTIF(A:A, ">" & B:B)

D =SUM(B1:B10 > A1:A10)

💡 Hint

Use SUMPRODUCT with a logical test to compare arrays element-wise.

Option A correctly counts how many rows have revenue greater than cost by comparing arrays element-wise.

Practice

1. Which arithmetic operator in Excel is used for multiplication in a formula like =A1 * B1?

easy

A. + (plus)

B. * (asterisk)

C. - (minus)

D. / (slash)

Solution

1. Step 1: Identify the multiplication operator

   In Excel formulas, the asterisk (*) is used to multiply values.

2. Step 2: Confirm the operator in the example

   The formula =A1 * B1 uses the asterisk to multiply the values in cells A1 and B1.

3. Final Answer:

   * (asterisk) -> Option B

4. Quick Check:

   Multiplication = * [OK]

Hint: Remember * means multiply in Excel formulas [OK]

Common Mistakes:

• Confusing * with + for addition
• Using x instead of *
• Using / for multiplication

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

easy

A. =A1 + B1

B. =A1 - B1

C. =A1 * B1

D. =A1 / B1

Solution

1. Step 1: Identify the addition operator

   The plus sign (+) is used to add numbers in Excel formulas.

2. Step 2: Check the formula syntax

   The formula =A1 + B1 correctly adds the values in cells A1 and B1.

3. Final Answer:

   =A1 + B1 -> Option A

4. Quick Check:

   Addition = + [OK]

Hint: Use + to add numbers in Excel formulas [OK]

Common Mistakes:

• Using - instead of +
• Forgetting the = sign
• Using * for addition

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

medium

A. 25

B. 30

C. 15

D. 20

Solution

1. Step 1: Apply order of operations

   Excel calculates multiplication before addition, so 5 * 2 = 10.

2. Step 2: Add the results

   Then add 10 + 10 = 20.

3. Final Answer:

   20 -> Option D

4. Quick Check:

   10 + (5 * 2) = 20 [OK]

Hint: Multiply before adding unless parentheses change order [OK]

Common Mistakes:

• Adding first then multiplying
• Ignoring operator precedence
• Confusing * with +

4. The formula =A1 + B1 * returns an error. What is the problem?

medium

A. Formula should start with a single quote

B. Using + instead of -

C. Missing value after the * operator

D. Parentheses are required around A1 and B1

Solution

1. Step 1: Check formula completeness

   The formula ends with an operator * but has no value after it, which is invalid.

2. Step 2: Understand Excel syntax rules

   Every operator must have values on both sides; missing value causes an error.

3. Final Answer:

   Missing value after the * operator -> Option C

4. Quick Check:

   Operators need values on both sides [OK]

Hint: Ensure every operator has values before and after [OK]

Common Mistakes:

• Leaving operator at end
• Forgetting to complete formula
• Adding unnecessary parentheses

5. You want to calculate the total price with tax in Excel. The price is in cell A2, and tax rate (as decimal) is in B2. Which formula correctly calculates price plus tax?

hard

A. =A2 + B2 * A2

B. =(A2 + B2) * A2

C. =A2 + B2

D. =A2 + B2 + A2

Solution

1. Step 1: Understand the calculation

   Total price with tax = price + (price x tax rate).

2. Step 2: Match formula to calculation

   Formula =A2 + B2 * A2 correctly adds price plus tax amount (B2 * A2).

3. Final Answer:

   =A2 + B2 * A2 -> Option A

4. Quick Check:

   Price + (TaxRate x Price) = Total [OK]

Hint: Multiply tax rate by price, then add price [OK]

Common Mistakes:

• Adding tax rate directly
• Multiplying sum incorrectly
• Using wrong operator order