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

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