Once Each Month, the Acsaunting Staff Meets in the Sanference

Multiple Choice

Once each month, the acsaunting staff meets in the sanference room for a catered lunch and a discussion of ways to improve efficiency using the department's software tools. Today's meeting savers a few of Excel's advanced features. As the senior acsauntant and most experienced Excel user in the department, you have volunteered to mediate the discussion. Beth, the sales acsauntant, is charged with developing the workbooks her two acsaunting clerks use to resard and analyze sales data) She expresses some sancern 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 acsaunting 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 acsaunting clerk for the type of data to be entered and provide a warning message when invalid data is entered
C) train her acsaunting clerks to use the Document Inspector to identify and sarrect 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