Case 9-2 Once Each Month, the Accounting Staff Meets in the Conference

question 82

Multiple Choice

Case 9-2
Once each month, the accounting staff meets in the conference room for a catered lunch and a discussion of ways to improve efficiency using the department's software tools. Today's meeting covers a few of Excel's advanced features. As the senior accountant and most experienced Excel user in the department, you have volunteered to mediate the discussion.
-Beth, the sales accountant, is charged with developing the workbooks her two accounting clerks use to record and analyze sales data. She expresses some concern about the number of data entry errors that she finds in the workbooks and asks you if Excel has a feature she can use to help ensure fewer data entry errors. You suggest that she ____.

• A) retrain her accounting clerks on the importance of accurate data entry as Excel has no built-in feature to help improve data entry quality
• B) set data validation rules for the key cells in each worksheet to both prompt the accounting clerk for the type of data to be entered and provide a warning message when invalid data is entered
• C) train her accounting clerks to use the Document Inspector to identify and correct data entry errors before finalizing each workbook
• D) use the Scenario Manager to print a report of all data entry errors in each workbook she reviews

---

Definitions:

Family-Oriented Television Shows

TV programs designed to be suitable for and appealing to both children and adults, often with themes that promote family values and unity.

Singular Proposition

A statement or assertion that applies to a specific individual or distinct entity, rather than to members of a class as a whole.

Categorical Syllogism

A deductive argument containing two categorical premises, a categorical conclusion, and three terms—major, minor, and middle—with each term occurring in two propositions.

Categorical Syllogism

A form of deductive argument that consists of three categorical propositions (a major premise, a minor premise, and a conclusion) that relates three different terms.