Excel Online Structured Activitys Personal taxes Mary larvis is a singie individual who is working on filing her tax feturn for the previout year. she has atsembied the following reitwant information - Sine received \$101,000 in salary. - She recenved $15,000 of divigend income. - S St. 700 ef interest income on Mome Depot bonds. - Mary receives one evempeisn (94,000), and the has allowable itemiand deductions of 57,500 . These amounts mill be beduated frum her great income to detertine her taxable income. serform the resared analy sis to ancwer the ouestions belsm. Cpen sgreatsheet a. What is Mary's federal tax labify? Raund your answer to the nearest cent. Do not round intermediate calailations. C. What a ther average tax ratel hound your answer ts 2 decital places. 49 e Calculation of Avernge Tax Rate 41. Average Tax Rain Sheet