Che bucerne Company uses the allowance method of estimating bad debts expense. An aging schedule is presaared in order to colculate the balance in the al owiance aceount. he cercentase uncollectible is calculated as fallows: Alter 355 days, the account is werteri off. Requerements 1 Calculate the number of davs rach receivable is outstanding. 2. Complest the schedule of Acrounts Receivable. 1. Journalize the adiusting entry for bad debt expense Lacel skaths 1 use the Dars finction to calculate the bamber of dops between the invelce date and the date of the aging sthedule 2. Use the vookup function to orovide the uncollectible accouns persentage tased an the chys outstanding 1. Use if and Avb functions to determine in which column of the Accourts elecetvabie Schedule to ploce the anourt for each customer. 4. Format oflis using mumber and percentage formats. 5. Uso formulas to calculate totals. 6. Use the increase indent bunten to indent the cred taccount for the jarmal entry. 7 . Use nesoluse ieferences to refer ta a velein the vookup formufa Eacel migh oars firvion I 41 a thent Bravely inat) hequirement t: Calcdate the number of dryi each receivatle is outscandine