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.

  

Per Statement D/T Total c/o Total Bank Errors Total Correct Balance 224551 23456749 Note Do the correct balances agrees Check Nnumber Amount Total Per Book Collections Total Other Addition Bank Service Total Our Errors Total 1 2 1 2 3 1 2 3 4 5 6 1 2 3 Note Note Note Amount Total