Basic Computer: MS Excel Shortcuts MCQ — 14 Practice Questions with Answers

Explanation

Start with the most familiar commands. Ctrl+P opens Print, so I matches 2. Ctrl+N creates a new workbook, so II matches 3. Ctrl+F opens Find, which gives III-1. Ctrl+H opens Replace, giving IV-4. The only option that keeps all four standard Excel shortcuts correctly paired is I-2, II-3, III-1, IV-4. Options B and C are tempting because they swap one pair, but a match-list question requires every pair to be correct.

Explanation

The question asks for the incorrect statement, so the correct answer is the option that describes a shortcut wrongly. Ctrl+Home is a navigation shortcut for going to the beginning of the worksheet, usually cell A1. It does not go to the last used cell. That role belongs to Ctrl+End, which jumps towards the end of the used worksheet area. F2 is also correctly stated because it lets the user edit the active cell. Hence the statement saying Ctrl+Home moves to the last used cell is incorrect.

Explanation

Ctrl+Z is the standard Undo shortcut. It reverses the last action, such as deleting a value or changing formatting. Ctrl+Y is used for Redo or Repeat, depending on what action is available. The stem tests the pair because students often remember Undo but confuse its opposite. Since Statement 1 correctly links Ctrl+Z with undo and Statement 2 correctly links Ctrl+Y with redo or repeat, both statements are correct. Therefore, option C is the defensible answer.

Explanation

The shortcut Ctrl+S is the standard Save command in MS Excel and most other Office programmes. The question asks about saving the current workbook, not printing it, opening another file, or creating a new workbook. Ctrl+P is for printing, Ctrl+O is for opening a file, and Ctrl+N starts a new workbook. Therefore, when the workbook already exists on screen and you want to save changes quickly, Ctrl+S is the correct shortcut.

Explanation

The three shortcuts in the stem are standard text-formatting shortcuts in Excel as well as in other MS Office programmes. Ctrl+B applies bold formatting, Ctrl+I applies italic formatting, and Ctrl+U applies underline formatting. Therefore I matches with bold text, II with italic text, and III with underline text. In the given list notation, that becomes I-b, II-a, III-c. The wrong options are built around swapping the three closely related formatting commands.