Case 10-1
You work for several accountants who are hosting a public seminar on recent changes to tax law that are applicable to the new tax year. You and two of your coworkers are tasked with automating the seminar participants' sign-in process by creating a sign-in form in an Excel workbook (based on a workbook created by a previous team) and a macro. Today you and your coworkers are holding a 'brainstorming session' in preparation for creating the form.
-Bob, who has never before attempted to automate a worksheet task, asks how the team can ensure that participants signing in using the data entry form cannot accidentally or purposely make changes to the form. You tell the team ____.
A) not to worry about accidental or purposeful changes to the form; participants can be trusted not to make changes
B) that the new company intern will stand by to monitor all participants' data entry and make sure no changes are made to the form
C) that a special software patch will be added to Excel to protect the worksheet from changes
D) that the data entry form worksheet will be password protected

Question

Quizplus · Accepted Answer

To prevent accidental or purposeful changes to the form, the best option is to password protect the worksheet. This will ensure that participants can still enter data but cannot accidentally or purposely modify the form itself. Therefore, option D is the best choice. Options A and B are not feasible solutions, as it is not wise to rely solely on participants' trustworthiness or to assign an intern to monitor all participants' data entry. Option C does not exist, as no such software patch is available.

Case 10-1 You Work for Several Accountants Who Are Hosting a Public