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.

Answer 1

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

Hiding a sheet only affects visibility — formulas and links to that sheet still work. (For stronger protection, use workbook protection or remove/secure the sensitive data.)