Xercise Cydes Company sels exercise equipreent to gyms on account. M year end, the following accounts receivable were uncolected. 1) Calculate the number of deps unpaid, using the Excel Davs functon. Leg Lend Fraded celt Leave biank 1 no antwnr. netsided Serotchandi Use as a nontrided Worlicapoce 21 Use the ieflorenation above to complete the Aging of Accounts heceivable scthedule below. Create a focmula for each ace catecors, using the trcel if funceson to determine where cach cartemer amount beloses. Calcuiste each "Total" cet toy usind the ficel SuM functen and induge all possible cells. leve no celst blark. 2) Use the information above to complete the Aging of Accounts Heceivable schedule below. Create a foemula for each age category, using the Eecel if Nunction to de bustomer amount belecgs. cadoulatin tach "Total" celi by uning the Excel sum function and indlude all peasible celih. Leive no celis blank: Legend Graded cell:wave blank if no antwer a needed. Scratchendevise as a non-araded workspoce Excel Mocrawn Hil Eicel Question - Saved 31 Gigaded Wanghed + Save and fletum to Acergnmest