Question

Following Excel's order of operations, what is the result of the formula =10-4/2*(5-2)?

A) 9
B) 13
C) 8.5
D) 4

Answer 1

The result of the formula =10-4/2*(5-2) is 4.

Step-by-step explanation:

To solve this equation, we need to follow the order of operations in Excel, which is parentheses, exponentiation, multiplication and division (from left to right), and addition and subtraction (from left to right).

Let's break down the equation:

1. Start with the parentheses: 5-2=3
2. Multiply: 4/2*(3) = 2*(3) = 6
3. Subtract: 10-6 = 4

Therefore, the result of the formula =10-4/2*(5-2) is 4.