In a classic menu-based version of Microsoft Excel, which of the following is…
2019
In a classic menu-based version of Microsoft Excel, which of the following is not a standard way to select all cells in a worksheet?
Answer: C. Clicking three times with the right mouse button in the worksheet — ConceptA worksheet-wide selection command changes the selection scope from the active cell or region to every cell in the sheet. In Excel, worksheet-wide…
- A.
Using the Edit → Select All menu command
- B.
Pressing Ctrl + A on the keyboard
- C.
Clicking three times with the right mouse button in the worksheet
- D.
None of these
Attempted by 59 students.
Show answer & explanation
Correct answer: C
Concept
A worksheet-wide selection command changes the selection scope from the active cell or region to every cell in the sheet.
In Excel, worksheet-wide selection is provided through explicit Select All controls or shortcuts; repeated ordinary pointer clicks act at the pointer location.
Application
Edit → Select All directly invokes the menu command for selecting all cells.
Ctrl + A is Excel’s Select All shortcut. If the first press selects the current data region, another press expands the selection to the entire worksheet.
Clicking three times with the right mouse button repeats a context-click action at the chosen location; it does not invoke a worksheet-wide selection command.
Cross-check and contrast
Edit → Select All and Ctrl + A are explicit selection commands.
Three right-clicks are not documented as a method for selecting all worksheet cells.
Therefore, the claim “None of these” does not fit the documented behavior of the listed actions.
Result
Clicking three times with the right mouse button in the worksheet is the action that will not select all cells.