QUESTION IMAGE
Question
what is the purpose of the following shortcut: ctrl+shift+end
selects the cells to the edge of the current data region.
moves to the edge of the current data region.
selects the cells to the bottom - right edge of the current data region.
In spreadsheet software (like Excel), the shortcut Ctrl+Shift+End is used to select cells from the current cell to the bottom - right edge of the current data region. The first option describes selecting to the edge (not specific to bottom - right), and the second option is about moving (not selecting) to the edge. So the correct description is the third option.
Snap & solve any problem in the app
Get step-by-step solutions on Sovi AI
Photo-based solutions with guided steps
Explore more problems and detailed explanations
C. Selects the cells to the bottom - right edge of the current data region. (Assuming the options are labeled A, B, C in order from top to bottom as: A. Selects the cells to the edge of the current data region. B. Moves to the edge of the current data region. C. Selects the cells to the bottom - right edge of the current data region.)