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

question 28

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

---

Definitions:

Calcium Chloride

A salt compound often used for ice melting, dust control, and as a desiccant because of its ability to absorb moisture.

Formula

A representation of the composition of molecules and compounds using symbols for the elements.

Snow Melting

The conversion of snow into water when the temperature rises, affecting ecosystems, water supplies, and climate models.

Elemental Symbol

A one- or two-letter notation derived from the name of an element, used as a shorthand representation in chemical equations and formulas.