Refer to CA7.1. Set up a spreadsheet with debit and credit columns and enter the adjusted trial

Question:

Refer to CA7.1. Set up a spreadsheet with debit and credit columns and enter the adjusted trial balance. Then set up debit and credit columns for closing and the post- closing trial balance.
Required
A. Enter the closing information.
B. Write a formula to determine the correct post- closing amounts.