Correct Answer:
C. Alt+Enter
This question focuses on a specific Excel functionality: inserting a new line within the same cell. Excel cells typically treat 'Enter' as a command to move to the next cell, so a special key combination is required for multi-line text.
- Alt + Enter is the correct key combination. When editing a cell, pressing Alt + Enter inserts a line break, allowing text to wrap within that single cell. This is crucial for formatting and readability when a cell contains a significant amount of text.
- Ctrl + Enter (Option A) is used to fill a selected range of cells with the current entry.
- Shift + Enter (Option B) moves the active cell selection up one row.
- Ctrl + Shift + Enter (Option D) is used to enter array formulas in older Excel versions.
Knowing this shortcut is essential for advanced Excel users.