fill in blanks using excel formual please...

On December 31,20Xx, the following information has been taken and summarized from the subsidiary accounts receivable ledger. The credit department believes that the uncollectable amounts can be determined with age using the following parameters: \begin{tabular}{l|lll|} \hline A & B & C & D \\ \hline 20 & Current Balance in Allowance for Doubtful Accounts & $7,500 credit \\ \hline \end{tabular} Required: Create an Aging of Accounts Receivable schedule. Determine the amount to use to adjust the Allowance for Doubtful Accounts account. Note: List the account narnes in alphabetical order. Sum the amounts in the "Amount Owed" column with the Aging Schedule, not the Subsidiary Ledger. 25 On December 31,20Xx, the following information has been taken and summarized from the subsidiary accounts receivable ledger. The credit department believes that the uncollectable amounts can be determined with age using the following parameters: \begin{tabular}{l|lll|} \hline A & B & C & D \\ \hline 20 & Current Balance in Allowance for Doubtful Accounts & $7,500 credit \\ \hline \end{tabular} Required: Create an Aging of Accounts Receivable schedule. Determine the amount to use to adjust the Allowance for Doubtful Accounts account. Note: List the account narnes in alphabetical order. Sum the amounts in the "Amount Owed" column with the Aging Schedule, not the Subsidiary Ledger. 25