USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It’s the easiest way to make a backup before making changes.
|
|
|
It lets you reuse formats and formulas in a new sheet.
|
|
|
It helps Excel learn where your data ranges are located.
|
|
|
You should keep one worksheet hidden in case of an error.
|
Detailed explanation-1: -Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook? It lets you reuse formats and formulas in a new sheet.
Detailed explanation-2: -Which of the following methods copies an existing worksheet within the same workbook? Press and hold CTRL and drag its sheet tab to a new location.
Detailed explanation-3: -To move the chart to a new worksheet, click New sheet, and then in the New sheet box, type a name for the worksheet. To move the chart as an object in another worksheet, click Object in, and then in the Object in box, select the worksheet in which you want to place the chart.
Detailed explanation-4: -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.