29.8k views
3 votes
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.

User Mhmt
by
6.8k points

2 Answers

3 votes
The answer is A! (P.E.M.D.A.S.)
User Arunas Bart
by
5.9k points
4 votes

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

Step-by-step 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).

User Floris Padt
by
6.4k points