MS Excel Shortcut Keys

28 questions available

FILTER BY SUBTOPIC

All Basic Shortcuts 27 Editing Shortcuts Cell Navigation Formatting Shortcuts Formula Shortcuts Worksheet Shortcuts 1 Function Keys
Showing 21–28 of 28

Q21.In Microsoft Excel, which commands or interface options can be used to copy data or formulas?

Easy
A Buttons on the Standard Toolbar
B Commands on the Right-Click Shortcut Menu
C Copy, Cut, and Paste commands on the Edit Menu
D All of the above
Basic Shortcuts PPSC

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.

Q22.In Microsoft Excel, what keyboard shortcut is used to select the entire column of the currently active cell?

Easy
A Alt + Spacebar
B Shift + Spacebar
C Ctrl + Spacebar
D None of these
Basic Shortcuts PPSC

Correct Answer: C

Ctrl + Spacebar highlights the entire vertical column, whereas Shift + Spacebar selects the entire horizontal row.

Q23.How do you select an entire column in MS Excel?

Easy
A Select Edit > Select > Column from the menu
B Click the column heading letter
C Hold down the Shift key as you click anywhere in the column
D Hold down the Ctrl key as you click anywhere in the column
Basic Shortcuts PPSC

Correct Answer: B

Clicking the column heading letter selects the entire column. Alternatively, the keyboard shortcut Ctrl + Spacebar selects the active column.

Q24.Which keyboard shortcut can be pressed in Microsoft Excel to automatically generate a standard chart on a separate sheet from selected data?

Easy
A F3
B F8
C F7
D F11
Basic Shortcuts PPSC

Correct Answer: D

F11 is the dedicated Excel function key that instantly builds a default column chart on a new sheet using the selected cell range.

Q25.Which shortcut key is used in Microsoft Office applications (such as Word and Excel) to update selected dynamic fields?

Easy
A F9
B F4
C F6
D None of these
Basic Shortcuts PPSC

Correct Answer: A

Pressing the F9 key updates and recalculates selected dynamic fields in Microsoft Word (like index entries or bibliographies) and Excel (like formulas).

Q26.In Microsoft Excel, which keyboard key should be pressed continuously while dragging to move a column?

Easy
A Tab
B Ctrl
C Shift
D Alt
Basic Shortcuts PPSC

Correct Answer: A

Using the Tab key during certain manual cell or column transfers helps control active focus and spacing.

Q27.In Microsoft Excel, what formatting is applied to the active cell by pressing 'Ctrl + 4'?

Easy
A Applies underline formatting
B Applies bold formatting
C Applies strikethrough formatting
D None of these
Basic Shortcuts PPSC

Correct Answer: C

Ctrl + 4 applies strikethrough formatting in Excel, drawing a line directly through the cell values.

Q28.Which shortcut is used in MS Excel to move between the individual worksheets of an open workbook?

Easy
A ALT + =
B Ctrl + Tab
C Ctrl + F
D Ctrl + Page up / Page Down
Basic Shortcuts PPSC

Correct Answer: D

Ctrl + Page Up navigates to the previous worksheet, while Ctrl + Page Down navigates to the next worksheet in the active workbook.