Please answer using excel formula

1. Prepare an aging of accounts receivable and compute bad debt expense. Excel CH7 i \begin{tabular}{|l|l|l} \hlinex & fx & Create a formula for each age category, using the Excel IF and AND FUNCTIONS \\ \hline \end{tabular} \begin{tabular}{|ccc|c|c|c|} & A & B & C & D & E \\ \cline { 2 - 6 } 34 & 3) Prepare the adjusting journal entry for recording bad debt expense if the Allowance for Doubtful Accounts \end{tabular} 35 had the following unadjusted balance: 4)Preparetheadjustingjournalentryforrecordingbadde 42 had the following unadjusted balance: 45 Bad Debt Expense 46 Allowance for Doubtful Accounts