Question

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

Answer 1

Answer:

The order of operations for Excel is as follows:

Evaluate items in parentheses.

Evaluate ranges (:).

Evaluate intersections (spaces).

Evaluate unions (,).

Perform negation (-).

Convert percentages (%).

Perform exponentiation (^).

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

Answer 2

Answer:

When evaluating a formula, Excel follows a standard math protocol called "order of operations". First any expressions in parentheses are evaluated. Next Excel will solve for any exponents. After exponents, Excel will perform multiplication and division, then addition and subtraction