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

Multiple Choice

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