USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Click on the New sheet (+) button to the right of the worksheet tabs.
|
|
|
On the home tab, click Insert and then click Insert Sheet.
|
|
|
On the Insert tab, click Worksheet.
|
|
|
Right-click a worksheet tab and click Insert, then click Worksheet and click OK.
|
Detailed explanation-1: -Solution(By Examveda Team) Copy the worksheet is not a basic step in creating a worksheet.
Detailed explanation-2: -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. On the General tab, click Worksheet, and then click OK.
Detailed explanation-3: -There are three ways you can insert a new sheet into a workbook: 1) Using the (Insert > Worksheet) menu. 2) Using the Worksheet Shortcut menu. 3) Using either of the shortcut keys (Shift + F11) or (Alt + Shift + F1).
Detailed explanation-4: -Which of the following procedures is not a way to delete a worksheet from a workbook? Press Ctrl + A to select all cells in the worksheet and press Delete. Which of the following statements about hidden and unhidden worksheets is correct? A hidden worksheet cannot be inadvertently deleted.