In this assignment, you will develop a simple worksheet for bank reconciliation. The primary focus in your
Question:
In this assignment, you will develop a simple worksheet for bank reconciliation. The primary focus in your design of the worksheet is to use Input controls to prevent the user from making mistakes. You may consider the features such data validation, conditional formatting in Excel as the controls. Of course, you can use any other feature you know to make the input controls better. For instance, the layout of the sheet may help. Certain functions can help a user to make Judgement, and so forth. Recall the examples we used in the lab session about input controls. This may help. You can find a template on the sheet named "template" in this file. You will also find a set of data that you can use to validate your worksheet. The data can be found on the sheet named "question in this file.
Auditing Cases An Interactive Learning Approach
ISBN: 9780134421827
7th Edition
Authors: Mark S Beasley, Frank A. Buckless, Steven M. Glover, Douglas F Prawitt