Arithmetic operators in formulas in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What symbol is used for addition in Excel formulas?

The plus sign + is used for addition in Excel formulas. For example, =A1 + B1 adds the values in cells A1 and B1.

beginner

How do you multiply two numbers in an Excel formula?

Use the asterisk * symbol to multiply. For example, =A1 * B1 multiplies the values in cells A1 and B1.

beginner

Which operator divides numbers in Excel formulas?

The forward slash / is the division operator. For example, =A1 / B1 divides the value in A1 by the value in B1.

intermediate

What does the caret ^ symbol do in Excel formulas?

The caret ^ is used for exponentiation (power). For example, =A1 ^ 2 squares the value in cell A1.

intermediate

How does Excel handle the order of operations in formulas with multiple arithmetic operators?

Excel follows the standard math order of operations: parentheses first, then exponentiation (^), then multiplication (*) and division (/), and finally addition (+) and subtraction (-). For example, =2 + 3 * 4 equals 14, not 20.

Which operator would you use to subtract one cell value from another in Excel?

A -

B +

C *

D /

The minus sign - is used for subtraction in Excel formulas.

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

A 21

B 11

C 16

D 7

Excel multiplies first: 2 * 3 = 6, then adds 5 + 6 = 11.

How do you write a formula to calculate 3 squared in Excel?

A =3 * 2

B =3 + 2

C =3 ^ 2

D =3 / 2

The caret ^ is used for powers. =3 ^ 2 means 3 squared.

Which operator has the highest priority in Excel formulas?

A ^

B -

C *

D +

Exponentiation ^ has higher priority than multiplication, division, addition, and subtraction.

What does the formula = (2 + 3) * 4 calculate first?

A Addition and multiplication at the same time

B 3 * 4

C 2 * 4

D 2 + 3

Parentheses have the highest priority, so Excel calculates 2 + 3 first.

Explain how to use the four basic arithmetic operators in Excel formulas and give an example for each.

Think about how you add, subtract, multiply, and divide numbers in real life.

Describe the order of operations Excel follows when calculating formulas with multiple arithmetic operators.

Remember the math rule PEMDAS or BODMAS.

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