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/(8-6)-4/2

a)119+7

b)7*3

c)8-6

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/en-us/excel-help/calculation-operators-and-precedence-HP010078886.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