Posted by vedrana on Thursday, September 1, 2011 at 2:44pm.
Using the operator precedence that excel 2007 follows,which calculation wuld be perfomed first from the following equation?119+7*3/(86)4/2
a)119+7
b)7*3
c)86
d)4/2
is a) correct answer thank you

computers  MathMate, Thursday, September 1, 2011 at 7:15pm
A simplified order of precedence in Excel is:
()
* and /
+ and 
* and / have the same precedence, so the formula will be evaluated from left to right if one follows the other.
To check the order, you would look for parentheses, the enclosed content of which will be executed first.
Then you would look for * and /.
They would be executed next, from left to right.
Then you would look for + and , again they would be from left to right.
If you follow the above rules, you will have no problem finding the right answer, which is not (a) 119+7 because there are other operators that have a higher precedence than "+".
Post your answer for a check if you are not sure.
Also, see the following article from Microsoft:
http://office.microsoft.com/enus/excelhelp/calculationoperatorsandprecedenceHP010078886.aspx
Answer This Question
Related Questions
 math  The diagram of airport runway intersections shows 2 parallel runways. A ...
 math  An airport runway intersections shows 2 parallel runways. A taxiway ...
 Maths'  What percentagge of £119.25p is £11.04p? Divide: 11.04 by 119.25. This ...
 statistics  Statistics. The lowest temperature ever recorded in the state of ...
 math, algebra  The problem states find the simple interest . Assume a 360 day ...
 Math  At a concert, the loudness of sound, L, in decibels, is given by the ...
 Math  At a concert, the loudness of sound, L, in decibels, is given by the ...
 math  The table shows the median home prices in Florida. What is the equation ...
 managerial economics  my cubic equation is O=C+aL+bL^2+cL3 how can i get the ...
 Physics  A ball is launched with a velocity of 10 m/s at an angle of 50.0 ...
More Related Questions