USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
True
|
|
False
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -Launch Excel. From Excel’s topmost menu, choose Excel > Preferences > (Authoring) Edit. In the Edit Options section, locate the “After pressing Return, move selection:” line and be sure the checkbox at the left of that line is checked. Then use the dropdown list to select Right.
Detailed explanation-2: -When you enter information in a cell, and then press the Enter key, Excel normally moves to the cell below the one in which you entered the information. You can configure Excel to move in a different direction after pressing Enter by following these steps: Display the Excel Options dialog box.
Detailed explanation-3: -Pressing Enter moves the selection down one cell, and pressing Tab moves the selection one cell to the right. You cannot change the direction of the move for the Tab key, but you can specify a different direction for the Enter key.
Detailed explanation-4: -The correct answer is The cursor (selection box) will move to the lower cell. When you enter a value in an Excel cell and press the ENTER key the cursor (selection box) will move to the lower cell.