Which of the following shortcut keys is used to extend the selection of cells to the last used cell on the worksheet (lower-right corner) in MS-Excel 2019?

Correct option is B

In MS Excel 2019, pressing Ctrl + End moves the cursor to the last used cell in the worksheet, which is at the intersection of the last used row and column (bottom-right corner of the used range). If used with Shift, it selects the range up to that point.

Important Key Points:

1. Ctrl + End is useful for quickly reaching the far end of your data range.
2. It does not select empty cells outside the used area.
3. If the worksheet has blank cells after data was deleted, the "used range" may still include them unless the sheet is reset.

Knowledge Booster:

• Shift + End is incomplete without an arrow key; by itself, it doesn’t perform the action.
• Ctrl + Home moves the cursor to cell A1, not to the bottom-right.
• Ctrl + Alt does not serve any navigation or selection purpose in Excel by itself.