Order of Oper

Let's take a look at a couple of examples regarding the order of operations in Excel.

Be sure to understand why each answer is correct.

Example #1

If we typed +100*.05+4/2 into a cell, what value would be displayed?

Would we take 100 times .05 and get 5, then add 4 to get 9, then divide by 2 to get 4.5?

OR

Would we take 100 times .05 to get 5, then take 4 divided by 2 to get 2, then take 5 plus 2 to arrive at 7?

Example #2

If we typed +200+50/5*4-20 into a cell, what value would be displayed?

Would we take 200 plus 50 to get 250, then divide by 5 to get 50, then multiply by 4 to get 200, then subtract 20 to arrive at 180?

OR

Would we take 50 divided by 5 to get 10, then multiply by 4 to get 40, then take 200 plus 40 minus 20 to arrive at 220?

Be sure to check your answers!