Xercise Cycles Company has provided its year ended accounts receivables that were uncollected. The controller has asked you to help prepare the Aging of Accounts Receivable Schedule and the corresponding journal entries. Use the information included in the excel simulation and the excel functions described below to clmplete the task

Cell reference

Basic Math Function

SUM function

AND function

DAYS function

I am showing both parts but i have already figured out Part 1, just need help with the others please and thank you!

4 1) Calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION ( 6x). 17 2) Use the information above to complete the Aging of Accounts Recelvable Schedule below. 15. Create a formula for each age category, using the Excel IF and AND FUNCTIONS ( fx ) to determine where each customer amount belongs. 15 The IF statement may include the following arguments: ,,>=, Excel AND FUNCTION (fx). 17 2) Use the information above to complete the Aging of Accounts Receivable Schedule below. Create a formula for each age category, using the Excel If and AND FUNCIIONS (fx) to determine where each customer amount belongs. 34 3) Prepare the adjusting journal entry for recording bad debt expense if the Allowance for Doubtful Accounts 41 4) Prepare the adjusting journal entry for recording bad debt expense if the Allowance for Doubtful Accounts 42 had the follmwing unadiustad halanre