The mathematical order of operations is used in Excel when formulas are evaluated. This order of operations states the order to be

A. exponentiation, multiplication and division, addition and subtraction.
B. addition and subtraction, multiplication and division, exponentiation.
C. multiplication and division, addition and subtraction, exponentiation.
D. multiplication and division, exponentiation, addition and subtraction.

Respuesta :

The answer is A! (P.E.M.D.A.S.)

Answer: A. exponentiation, multiplication and division, addition and subtraction.

Explanation: When we use a tool to calculate mathematical operation (Like Excel, Wolfram or even just a calculator) we need to have in consideration the order in which the operation will be made (if we don't consider the order, we will probably obtain a wrong answer), so when Excel evaluate formulas, the order of the operation is: exponentiation, multiplication and division, addition and subtraction, so if we have for example: 5+4*2^3, it will solve first the exponentiation (2^3=8) then the multiplication (4*8=32) and finally the addition (5+32=37).