Which of the following shortcut key is used to select all cells of the current row in MS-Excel 2010 worksheet?

Correct option is D

In MS-Excel 2010, the shortcut key Shift + Spacebar is used to select all cells of the current row in a worksheet. This allows for quick row selection without using the mouse, enhancing productivity in large spreadsheets.

Important Key Points:

1. Shift + Spacebar selects the entire row where the active cell is located.
2. Once selected, operations such as formatting, copying, or deleting can be applied to the entire row.
3. This shortcut is particularly useful for editing or formatting large datasets.

Knowledge Booster:

• Shift + Page Down: Moves the selection down one screen but does not select the current row.
• Ctrl + Spacebar: Selects the entire column of the active cell, not the row.
• Shift + Page Up: Moves the selection up one screen but does not select the current row.