USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Unhidden worksheets cannot contain formulas that refer to hidden worksheets.
|
|
|
When you click Find All, the Find and Replace dialog box will show matched contents within hidden worksheets as well as unhidden ones.
|
|
|
A hidden worksheet cannot be inadvertently deleted.
|
|
|
Excel creates a minimized window for each hidden worksheet.
|
Detailed explanation-1: -Which of the following statements about hidden and unhidden worksheets is correct? A hidden worksheet cannot be inadvertently deleted. Why would you need to copy a worksheet within a workbook? It lets you repeat formats and working formulas into a new sheet.
Detailed explanation-2: -You can hide any worksheet to remove it from view. The data in hidden worksheets is not visible, but it can still be referenced from other worksheets and workbooks, and you can easily unhide hidden worksheets as needed. Right-click the sheet tab you want to hide, or any visible sheet if you want to unhide sheets.
Detailed explanation-3: -Which signifies that there is a hidden worksheet in an Excel document? Explanation: If there is a hidden worksheet in an Excel document, the Unhide Sheets option under Hide and Unhide in the Format drop-down menu will not be grayed out.
Detailed explanation-4: -Clicking the Page Layout View button in the View tab of the Ribbon shows all columns in the worksheet and shades hidden columns.