2
QuizMultiple Choice

Unit Test — Unit test

Question 2 • Business Information Management

Nick has chosen to hide a worksheet that contains sensitive data when presenting information from his workbook. Which statement is correct?

Answer
A
The worksheets that are hidden will retain data, but references to those worksheets will no longer function.
B
The worksheets that are hidden will have their data removed.
C
The worksheets that are hidden will retain their data, and references will continue to function as normal
D
You will have to unhide the worksheets to make references function correctly.

Explanation

Hiding a worksheet changes whether it is visible, but it does not delete or alter its contents. Formulas and other references can still use data on a hidden worksheet, so those references continue to function normally. The correct statement is that hidden worksheets retain their data and references continue to work as usual.

AI-written and checked against the verified answer.

Previous
Next