MS Excel Shortcut Keys

Correct Answer: A

Correct Answer: B

The keyboard shortcut to select an entire row in Microsoft Excel is Shift + Spacebar. This command selects all cells in the current active row. For highlighting a column, Ctrl + Spacebar is used.

Correct Answer: C

Ctrl + 1 opens the Format Cells dialog box in MS Excel. It provides options for Number, Alignment, Font, Border, Fill, and Protection. It is a useful shortcut for quickly formatting selected cells. Additional information: • Ctrl + 5 — Strikethrough • Ctrl + 6 — Show/Hide objects • Ctrl + F10 — Maximize/restore active window

Correct Answer: A

To add a new row, right-click the row number where you want the new row. Select Insert from the context menu. Excel inserts a new row above the selected row. You can also use Home → Insert → Insert Sheet Rows.

Correct Answer: C

In MS Excel, hold the Ctrl key while selecting cells to select multiple nonadjacent cells or ranges. This allows you to select separate cells without selecting the cells between them. Additional information: Shift is generally used to select a continuous range.

Correct Answer: A

Pressing F2 on your keyboard allows you to edit the active cell or formula directly inside the cell in Microsoft Excel.

Correct Answer: C

Shift + F10 displays the shortcut (context) menu for the selected item, performing the exact same action as a right-click with a mouse.

Correct Answer: A

In Microsoft Word, pressing Ctrl + Shift + F6 switches to the previous open document window when multiple files are open simultaneously.

Correct Answer: B

Alt + F4 is the standard keyboard shortcut to close the entire Microsoft Excel application, while Ctrl + W closes only the active workbook.

Correct Answer: D

Both Shift + F11 and Alt + Shift + F1 are valid keyboard shortcuts used to insert a new worksheet in Microsoft Excel.

Correct Answer: C

The shortcut Ctrl + ; inserts the current system date as a static, unupdating value directly into the active cell.

Correct Answer: C

Pressing Ctrl + Shift + & applies a border around the outline of the selected cell range. To remove borders, use Ctrl + Shift + _.

Correct Answer: C

Ctrl + Page Down is the keyboard shortcut to select the next worksheet tab to the right. Ctrl + Page Up selects the worksheet tab to the left.

Correct Answer: C

In MS Excel, pressing Ctrl + ; (semicolon) instantly inserts the static current date into the selected cell.

Correct Answer: A

Pressing the F1 key opens the Excel Help and Support pane (on Windows systems).

Correct Answer: A

In Excel, Alt+M is the shortcut key used to go to the formula tab.

Correct Answer: A

In Excel, Ctrl + D is the keyboard shortcut for the Fill Down command.

Correct Answer: B

Shift + F9 specifically calculates formulas and updates active cells only on the currently active worksheet tab in MS Excel.

Correct Answer: B

Ctrl + P opens the print dialog box or print menu in Microsoft Excel and other MS Office applications.

Correct Answer: D

Excel provides multiple standard methods to copy cell contents, including toolbar buttons, right-click context menus, edit menu items, and keyboard shortcuts.