USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
John would like to change the order of the worksheets in his workbook. Which option would he choose?
|
|
Insert
|
|
|
Delete
|
|
|
Copy
|
|
|
Move
|
Explanation:
Detailed explanation-1: -On the Edit menu, click Sheet > Move or Copy Sheet. On the To book menu, click the workbook that you want to move the sheet to. Tip: To create a new workbook that contains the moved sheet, click new book. In the Before sheet box, click the sheet that you want to insert the moved sheet before, or click move to end.
Detailed explanation-2: -Press Ctrl+Page Down to move to the next worksheet. For example, if you’re currently in Sheet1, this key sequence jumps you to Sheet2.
Detailed explanation-3: -Simply hold down the Ctrl key and press either the Page Up or Page Down key to move to the previous or next sheet, respectively. You can also use the Ctrl + Arrow keys to move between sheets.
There is 1 question to complete.