DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook? a. It’s the easiest way to make a backup before making changes.
|
|
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.
|
Explanation:
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.
There is 1 question to complete.