In Excel’s "Edit Mode," which keyboard shortcut allows you to insert a manual line break within a single cell to manage long text strings or multi-line formulas?

Correct — C. Microsoft's Excel for Windows shortcut list gives Alt + Enter as "Start a new line in the same cell".

Plain Enter would complete the entry and select the cell below. Alt + Enter breaks the line and leaves you editing the same cell → option (c).

Why the others are wrong

• (a)
  Ctrl + Enter — Ctrl + Enter fills the selected cell range with the current entry, putting one typed value into every selected cell. It completes the entry instead of breaking a line inside it.
• (b)
  Shift + Enter — Shift + Enter completes the entry and selects the cell above, the reverse of plain Enter. It ends the edit instead of adding a line.
• (d)
  Tab + Enter — Tab + Enter is not a shortcut in Microsoft's list. Tab alone completes an entry and moves one cell right, so pressing it ends the edit and leaves the cell.

F2 opens the active cell for editing, with the insertion point at the end of its contents. Whether you are typing a new entry or editing an old one, the key you press next decides how the entry ends.

Enter: complete the entry, move down.
Shift + Enter: complete it, move up.
Tab: complete it, move right.
Ctrl + Enter: fill every selected cell with it.

Alt + Enter does not end the entry. It starts a new line inside the same cell, which is how you split long text across lines.

Key facts

• Alt + Enter: start a new line in the same cell (Excel for Windows).
• Ctrl + Enter: fill the selected cell range with the current entry.
• Shift + Enter: complete the entry and select the cell above.
• F2: edit the active cell, with the insertion point at the end of its contents.

Common traps

• Choosing Ctrl + Enter because Ctrl is the usual modifier, when it fills a selection instead of breaking a line.
• Carrying Shift + Enter over from Word, where it inserts a line break, when in Excel it completes the entry and moves up.

No directly related past PYQ was found.