Asked by Kelly
The order of precedence is very important when building formulas in Excel. Which of the following formulas will produce 778 as the result?
A. =(25*(27/9)+5+309)*2
B.=25*((27/9+5)+309*2)
C.=25*(27/9+5)+309*2
D. =25*27/9+5+309*2
Even understanding the basics of Excel was grueling for me, and this question takes the cake. Any help would be extremely appreciated.
A. =(25*(27/9)+5+309)*2
B.=25*((27/9+5)+309*2)
C.=25*(27/9+5)+309*2
D. =25*27/9+5+309*2
Even understanding the basics of Excel was grueling for me, and this question takes the cake. Any help would be extremely appreciated.
Answers
Answered by
MathMate
Excel is nothing but a tool to help us.
It does not create a new rule for precedence, but follows what we learned in elementary school.
In maths, the rules of precedence PEDMAS (or some variant) are:
Parentheses
Exponentiation
Division/Multiplication
Addition/Subtraction.
They are the same rules you would use with a calculator, or manually.
For example, for D,
25*27/9+5+309*2
=675/9+5+309*2
=75+5+309*2
=75+5+618
=698
It does not create a new rule for precedence, but follows what we learned in elementary school.
In maths, the rules of precedence PEDMAS (or some variant) are:
Parentheses
Exponentiation
Division/Multiplication
Addition/Subtraction.
They are the same rules you would use with a calculator, or manually.
For example, for D,
25*27/9+5+309*2
=675/9+5+309*2
=75+5+309*2
=75+5+618
=698
Answered by
ask
sklja;ks
Answered by
star
25*27 19+5+309*2 25*(27 19 + 5 )+ 309 *2 (25*27 19 +5 +309)*2 (25*27 19 +5 +309)*2 25*(27 19 +5+309*2 result of 778
There are no AI answers yet. The ability to request AI answers is coming soon!
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.