Case 9-1
You are presenting a two-hour seminar on using Excel features to professionals at an annual convention of accounting managers. The seminar will be followed by a brief Q&A session. Half-way through the seminar, you give the seminar participants a break.
-During the following Q&A session, another participant complains that a workbook created in his accounting department was widely shared with others in his company; unfortunately, the workbook contained sensitive information in hidden rows and columns that should not have been shared. He asks if Excel has a feature that can help to prevent this problem in the future. You tell him to ____.
A) stop putting sensitive data in workbooks that might be shared with others
B) download a special application from the Internet that can stop the distribution of a workbook that contains hidden rows and columns
C) have his employees use the Document Inspector feature to identify hidden information that should be removed before a workbook is distributed
D) tell his employees to just be more careful because Excel does not have a feature that can help prevent distributing hidden information

Question

Quizplus · Accepted Answer

The best option is to have the employees use the Document Inspector feature to identify hidden information that should be removed before a workbook is distributed. This is a built-in feature in Excel that can help prevent the distribution of sensitive data. Option A is not a practical solution as sometimes sensitive data may need to be included in a workbook. Option B is not recommended as downloading applications from the internet can be risky and compromise security. Option D is not entirely true as there is a feature in Excel that can help to prevent distributing hidden information.

Case 9-1 You Are Presenting a Two-Hour Seminar on Using Excel Features