Answer :

Answer:

b.   (A3-H4)

Explanation:

Excel follows the familiar PEMDAS rule when evaluating expressions

This means in an expression terms in parentheses are evaluated first.

If there are multiple terms at the same parenthesis level, the evaluation proceeds left to right

If there are terms in nested parentheses, the innermost parentheses terms are evaluated first

When all terms are at the same level (no parentheses) the evaluation proceeds left to right

In the formula
        =((A3-H4)+(F10+C4))*(G7/C8)

the innermost leftmost term is (A3 - H4)

So this is evaluated first

Answer:
(A3 - H4)

The order of evaluation is as follows

  1. (A3 - H4)
  2. (F10+C4)
  3. (A3 - H4) +  (F10 +C4)
  4. (G7/C8)
  5. ((A3-H4)+(F10+C4)) * (G7/C8)

Other Questions