Critical Thinking QuestionsCase 9-2Once 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 qualityc.
train her accounting clerks to use the Document Inspector to identify and correct data entry errors before finalizing each workbookb.
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 enteredd.
use the Scenario Manager to print a report of all data entry errors in each workbook she reviews
What will be an ideal response?
Answer: B
You might also like to view...
You can use the clear property to position the contents of an element below another element that has been floated; this is also called ____________________ an element.
Fill in the blank(s) with the appropriate word(s).
Filter by Selection allows filters based on multiple values in the same field
Indicate whether the statement is true or false
What is the difference between nonexclusive forwarding and exclusive forwarding?
What will be an ideal response?
What is the function of a "working group" within the IEEE?
What will be an ideal response?