USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
To the right of the current worksheet tab.
|
|
|
To the far left of all worksheet tabs.
|
|
|
To the far right of all worksheet tabs.
|
|
|
In a random position, depending on which worksheet is active.
|
Detailed explanation-1: -As many as the available memory of your system will permit. When you insert a new worksheet using Insert, Insert Sheet on the Home tab, the new worksheet tab appears: To the right of the current worksheet tab. Sam has painstakingly created a worksheet of Sales figures for the Eastern region.
Detailed explanation-2: -When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.
Detailed explanation-3: -The “SHIFT + F11” key is the shortcut key to insert a new worksheet.
Detailed explanation-4: -To insert a new worksheet in front of an existing worksheet, select that worksheet and then, on the Home tab, in the Cells group, click Insert, and then click Insert Sheet.
Detailed explanation-5: -If using these last two methods, however, note that Excel inserts the new worksheets to the left of the active worksheet. This is the worksheet whose name tab appears in color and bolded when the sheet is inserted.