Question

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

Explanation:

When a worksheet is hidden in a workbook, its data is retained. Also, references to that hidden worksheet continue to function as normal. Hidden worksheets are just not visible on the screen but their data and references are still valid.

Answer:

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