nick has chosen to hide a worksheet that contains sensitive data when presenting information from his…

nick has chosen to hide a worksheet that contains sensitive data when presenting information from his workbook. which statement is correct?\no the worksheets that are hidden will retain data, but references to those worksheets will no longer function.\no the worksheets that are hidden will have their data removed.\no the worksheets that are hidden will retain their data, and references will continue to function as normal\no you will have to unhide the worksheets to make references function correctly.

nick has chosen to hide a worksheet that contains sensitive data when presenting information from his workbook. which statement is correct?\no the worksheets that are hidden will retain data, but references to those worksheets will no longer function.\no the worksheets that are hidden will have their data removed.\no the worksheets that are hidden will retain their data, and references will continue to function as normal\no you will have to unhide the worksheets to make references function correctly.

Answer

Answer:

The worksheets that are hidden will retain their data, and references will continue to function as normal.

Brief Explanations:

When a worksheet is hidden in a workbook (e.g., in Excel), the data within it remains intact and any valid references to cells or ranges in that hidden worksheet still work as expected.