USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
On the View tab, in the Window group, click Hide.
|
|
|
Select the visible area of the worksheet.
|
|
|
Right-click the worksheet’s tab and click Hide.
|
|
|
Enter the name of the worksheet in the Hide dialog box.
|
Detailed explanation-1: -Which of the following steps is a method for hiding a single worksheet in a multi-sheet workbook? Right-click the worksheet’s tab and click Hide. Which of the following steps is not a method for inserting a worksheet into a workbook? On the Insert tab, click Worksheet.
Detailed explanation-2: -First ensure that the Show sheet tabs is enabled. To do this, For all other Excel versions, click File > Options > Advanced-in under Display options for this workbook-and then ensure that there is a check in the Show sheet tabs box.
Detailed explanation-3: -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.