Free Microsoft MO-211 Actual Exam Questions

A SUM is definitely the one that adds everything up. The others just analyze the data in different ways, so they’re not about totals. No hidden tricks here, just straightforward addition.

MAX, MIN, and AVERAGE don’t calculate sums at all, so those can be ruled out pretty easily. The question’s about adding up values, which only SUM does directly. Could there be any trick we’re missing here?

Yeah, line charts (B) really win here because they’re made to track changes step-by-step over time, unlike bars or pies that just compare snapshots or parts.

C imo, scatter charts do plot points over time, but they don’t connect them, so you lose the flow of the trend. Pie charts are totally out since they show parts of a whole, not changes. Bar charts break things into chunks and don’t really capture movement. Line charts (B) are just made for this by linking data points, making it easy to see if values go up or down over time.

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.

It’s C for sure. Slicers are specifically made for filtering PivotTables and PivotCharts easily, not for calculations or extra chart features like add-ins. That’s the main function they serve.

C, because slicers simplify filtering without needing extra add-ins.

Option B could also be right because Alt + Shift + F1 does insert a new worksheet in some Excel versions, especially older ones or different setups. The question doesn’t specify the Excel version or OS, so depending on that, B might be a legitimate choice. Since D is the classic shortcut on Windows, and B works in some contexts, it's really about which environment the question targets. Without that info, both have valid claims, but B is less universally known compared to D.

B/D? I know Shift + F11 (D) works on Windows for sure, but I’ve seen Alt + Shift + F1 (B) also insert a sheet in some versions. Since the question doesn’t specify Windows or Mac, B might be valid on certain platforms or setups. Ctrl + Shift + N (A) isn’t something I recall using in Excel, and Ctrl + N (C) definitely opens a new workbook, not a sheet. So between B and D, it depends on the Excel version and OS, but D is the more universal shortcut on Windows at least.

B probably works best here since Ctrl + C copies the formula itself, not just the value or formatting. Ctrl + D is more for filling down in a column, which is more specific.

I think Ctrl + D (D) fits best if the question targets copying formulas down a column specifically, since Ctrl + C is just a basic copy function.

B/C? Custom format is definitely the right option for applying custom formats, but I’m wondering if sometimes you might start from Number format before switching to Custom. Still, B seems more direct.

Eliminate A since Conditional Formatting is for rules, not number formats.

I’m thinking A might be off since loops aren’t always called conditional statements, but D sounds strange because conditions usually come before or during code, not after. Could the question be mixing up terms?

Guessing B because it matches the idea that a conditional checks something before running code, unlike loops which repeat stuff. The others seem off since they mention looping or conditions after running code.

D imo, since wrapping text only changes how the content fits visually and doesn’t separate it into different columns, it can’t be the right choice. Splitting has to be option A for sure.

Since merging cells obviously combines columns, and wrapping text only affects appearance, option C doesn’t deal with splitting either. The only one mentioning splitting is A, but is there any chance the question means something else?

A. Using “Clear” is the easiest way to remove filters from columns without messing with sorting or other functions. The other options don’t actually undo the filter.

Makes sense to skip B and C, A really is the simple “undo” for filters here. A

The hyphen in B isn’t valid syntax for cell ranges, so C is the safe bet.

C imo, it’s the only option that correctly covers all cells A1 through A10.

A vs D? Sharing doesn’t add sheets, so D’s out. Review and Format are more about editing or styling existing content, not adding new sheets. Insert fits logically since it’s about putting new elements into the workbook. Seems like A is the best pick here.

Option A seems right because adding new sheets is generally considered an insertion action. Review is about checking and comments, Format deals with cell styles and layouts, and Share is for collaboration stuff. So, if you think about where you’d add something new, Insert fits perfectly.

A. Conditional formatting is the only one that really reacts automatically when the cell’s content changes. Borders and shading (B) are static unless you manually adjust them, and text wrapping or alignment don’t change based on content value at all. So it has to be A because it’s built for dynamic appearance changes tied to the actual data in the cell.

A. Borders and shading don’t update on their own—they’re set manually. Conditional formatting is designed to automatically adjust based on what’s inside the cell, so that’s the only one that fits here.

C, because Inspect Document lets you find and delete all personal details in one place.

C. The Inspect Document function not only finds but also lets you remove personal info, which is more thorough than just flagging it. It’s the go-to for cleaning up before sharing.

What about thinking of CONCATENATE as joining words side-by-side? That rules out everything but B.

It’s definitely B. The function’s name itself hints at joining or linking things together, which fits combining text strings perfectly. A, C, and D don’t really relate to what CONCATENATE is known for—no calculations or sheet creation involved here. So no need to overthink it.