USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Insert
|
|
|
Delete
|
|
|
Copy
|
|
|
Move
|
Detailed explanation-1: -To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu. On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Sheet.
Detailed explanation-2: -If you click a cell and then press DELETE or BACKSPACE, you clear the cell contents without removing any cell formats or cell comments. If you clear a cell by using Clear All or Clear Contents, the cell no longer contains a value, and a formula that refers to that cell receives a value of 0 (zero).
Detailed explanation-3: -Click on the sheet that you want to delete. Press the Ctrl + Shift + F11 keys on your keyboard. Click on the Delete Sheet button. Click on the Yes button to confirm that you want to delete the sheet.
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.