Free Microsoft MO-211 Actual Exam Questions - Question 3 Discussion

D imo, because dividing by the original value (old number) is essential for percentage change. The others don’t seem to handle that right, so D fits best for the typical formula structure.

Maybe D, since it looks like the only one that correctly divides the difference by the old value, which is key for accurate percentage change. The others seem off with how they handle that part.

C/D? I think option C might miss parentheses around (new - old), which can cause wrong results. D clearly puts subtraction first, so it’s safer for correct calculation order.

B imo, because it properly uses parentheses to keep calculation order clear.

I’m thinking if the formula doesn’t specify parentheses properly, it could mess up the calculation order. Is option D’s formula correctly using parentheses to ensure subtraction happens before division?

Option D looks right because it matches the standard formula for percentage change: (new - old) / old. The question doesn’t specify exact cell references, but that part is usually just plugging in your data. The other options don’t follow the correct math or give errors, so D fits best overall.

It’s D since it’s the only one that follows (new-old)/old logic correctly.

B imo, because it avoids errors and matches the typical percentage change logic.

D imo, the errors in A, B, and C mean they’re invalid formulas. D is the only one that follows the standard ((new - old)/old) * 100 format for percentage change.

D vs the rest? The errors in A, B, and C are a dead giveaway, plus D uses the classic formula everyone learns for percentage change. No doubt it’s D.

It’s D because the other options clearly show error messages, which can’t be right for a formula. Also, D fits the typical structure for percentage change — subtract old from new, divide by old, then multiply by 100 to convert it to a percentage. No need to overthink it, this is the standard way in Excel for calculating percentage change.

It’s D for sure because it follows the basic formula: (new - old) divided by old, then multiplied by 100 to get the percentage. The others are clearly just error messages.

C/D? I agree that A and B don’t make sense since they look like errors. Between C and D, I’d pick the one that correctly references the new value minus the old value divided by the old value. That’s the standard way to find percentage change in Excel. The *100 is optional if you format the cell as a percentage, but including it in the formula also works. So whichever option has that structure should be right.

Maybe D? The others look like error messages. Usually, percentage change is ((new-old)/old)*100, so D might be the formula that matches this.