Shortcut Key
8. Fill in the blanks.
Action (to perform in a table)
1. Move to last row
2. Move to next cell
3. Move to previous cell
4. Move to one row up
5. Move current row down
6. Move the cursor to the first column-
Answers
Explanation:
1.1 Keys for moving and scrolling in a worksheet or workbook
Move one cell up, down, left, or right: ARROW keys
Move to the edge of the current data region: CONTROL+ARROW key
Move to the beginning of the row: HOME
Move to the beginning of the worksheet: CONTROL+HOME
Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1: CONTROL+END
Move down one screen: PAGE DOWN
Move up one screen: PAGE UP
Move one screen to the right: ALT+PAGE DOWN
Move one screen to the left: ALT+PAGE UP
Move to the next sheet in the workbook: CONTROL+PAGE DOWN
Move to the previous sheet in the workbook: CONTROL+PAGE UP
Move to the next workbook or window: CONTROL+F6 or CONTROL+TAB
Move to the previous workbook or window: CONTROL+SHIFT+F6 or CONTROL+SHIFT+TAB
Move to the next pane in a workbook that has been split: F6
Move to the previous pane in a workbook that has been split: SHIFT+F6
Scroll to display the active cell: CONTROL+BACKSPACE
Display the Go To dialog box: F5
Display the Find dialog box: SHIFT+F5
Repeat the last Find action (same as Find Next): SHIFT+F4
Move between unlocked cells on a protected worksheet: TAB
Answer:
1. ans - ctrl -down
2. ans- tab
3. ans- shift + tab
4. ans- shift and alt key up
5.ans- shift and alt key down
6. ans - at first click alt + home amd then press alt+ page up