USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Before the current sheet
|
|
|
After the last sheet
|
|
|
Both answers are correct
|
|
|
None of the above
|
Detailed explanation-1: -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. Tip: You can also right-click the tab of an existing worksheet, and then click Insert.
Detailed explanation-2: -’Shift+F11’ keys are used to insert worksheet in Microsoft Excel.
Detailed explanation-3: -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.
Detailed explanation-4: -Hover the mouse pointer at the edge of the scrollbar until you see the double-headed arrow (see the figure). Click-and-drag the arrow to the right, until you see the complete tab name and any other tabs. The worksheet itself is hidden. To unhide a worksheet, right-click on any visible tab and then click Unhide.