USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
moves the activecell indicator one cell down
|
|
|
moves the activecell indicator one cell up
|
|
|
moves the activecell indicator one cell right
|
|
|
moves the activecell indicator one cell left
|
Detailed explanation-1: -Move Active Cell Left in a Selection – wrap to previous row-Shift + tab moves the active cell left.
Detailed explanation-2: -Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your worksheet. Note: When SCROLL LOCK is on, Scroll Lock is displayed on the status bar in Excel. Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right.
Detailed explanation-3: -SHIFT+TAB Move to the previous option or option group. CTRL+TAB or CTRL+PAGE DOWN Switch to the next tab in a dialog box. CTRL+SHIFT+TAB or CTRL+PAGE UP Switch to the previous tab in a dialog box.
Detailed explanation-4: -To move to the next cell, press the Arrow Keys. To move to the next cell to the right, press TAB. To move to the next cell to the left, press SHIFT + TAB. To move to the edge of a data region, press CONTROL + Arrow Keys.