$(2)$ Balance and Reconcile a Checking Account Make a spreadsheet that will balance a checking

account and allow for reconciling a bank statement. The bank statement data for March of $2023$

is in the file, Excel data checking example.xlsx$,$ on Blackboard. This file contains the

reconciling data for the account. All the transactions except for the checks can be assumed to

have occurred on the day given. The checks are written at one point in time each and eventually

deposited. In between those to dates, the account does not know it has a draft against it which

is why balancing the checking account is important.

The account begins March with $$400.$ The checks' dates of writing are given in the table along

with other data commonly stored in the checkbook register.

Use highlighting and borders. Use logical statements to select if a line item is to be reconciled

or not. Have a running balance for the account. Have a reconciled balance for the account.