FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?

A	Insert
B	Move
C	Rename
D	Tab Color

Explanation:

Detailed explanation-1: -Move a sheet to another workbook On the Window menu, click the workbook that contains the sheet that you want to move. Click the sheet that you want to copy to the other workbook. 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.

Detailed explanation-2: -Use the keyboard shortcuts CTRL + PAGE UP and CTRL + PAGE DOWN. These keyboard shortcuts are probably the quickest and easiest way to move between sheets in Excel. Simply press CTRL + PAGE UP to move to the previous sheet, or CTRL + PAGE DOWN to move to the next sheet.

Detailed explanation-3: -You can move worksheets with the keyboard by using Ctrl+PgUp and Ctrl+PgDown. Ctrl+PgUp moves toward the first worksheet in the workbook and Ctrl+PgDown moves toward the last.

There is 1 question to complete.