Question

specify the order of operation used for evaluating formulas in Excel​

Answer 1

Answer:

The order of operations for Excel is as follows:

1:Evaluate items in parentheses.

2:Evaluate ranges (:).

3:Evaluate intersections (spaces).

4:Evaluate unions (,).

5:Perform negation (-).

6:Convert percentages (%).

7:Perform exponentiation (^).

8:Perform multiplication (*) and division (/), which are of equal precedence.

Explanation: