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

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.

I agree with D since Shift + F11 has been the go-to for adding sheets for a long time, and B looks less common to me. So D feels safer here.

D imo, because Shift + F11 is the classic way to add a new sheet quickly. Ctrl + N (C) actually opens a new workbook, so that one’s out for sure.

B/D? I remember D (Shift + F11) being the go-to shortcut for adding a new worksheet in most Windows Excel versions. But B (Alt + Shift + F1) also rings a bell as an alternative, especially in some older Excel editions or different setups. Since Ctrl + N (C) opens a new workbook, that’s out. Ctrl + Shift + N (A) seems off for this task. Without platform specifics, I’d say D is safer, but B can’t be fully ruled out depending on context.

Option D is definitely the go-to for inserting a new worksheet quickly. Ctrl + N (option C) just opens a new workbook, so that’s out. A seems off because Ctrl + Shift + N isn’t a standard Excel shortcut for this. B’s Alt + Shift + F1 could be tricky or less common, but I haven’t really seen it used much for new sheets. So yeah, D feels like the simplest and most reliable choice here.

Maybe B works too since Alt + Shift combinations are often used for insert actions in Excel, but D is the more straightforward and common shortcut I know for adding a sheet.

Makes sense to go with D. Shift + F11 is the usual shortcut for a new sheet.