Open IL$\_$EX$\_5-5.$xlsx from the location where you store your Data Files, then save it as IL$\_$EX$\_4\_$Billings. Create a table with the default table style. Sort, summarize, add a column, build a table formula, and add data validation so that your screen matches the table shown in FIGURE $5-24.$ Enter your name in the center section of the worksheet footer. Save the workbook, preview the table, close the workbook, submit the workbook to your instructor, then close Excel.

FIGURE $5-24$

$\backslash$table$[[4,$A$,B,$C$,$D$,$E$,F,,$G$,H,1,$I,$k,t,,M,4],[1,$Account $17,$Attorneve,Otficen,Service al$,$Referral,Billed $10,,$Pald $10,$Balance:$-,,,,$Attorney Billing,$],[2,1008C,$Cantro,Austin,RealEstate,Friend$/$Family$,$$$1,200,$$$,1,000,200,,,,$Attorney,,,$],[3,1272,$Costro,Austin,Real Estate,Other,$300,$$$,200,100,,,,$Castro,,,$],[4,1659,$Costro,Austin,Real Estate,Chamber of Commerce.,$1,200,$$$,-,1200,,,,$Bailled,$$,2950,],[5,1663,$Castro,Austin,Small Business,Friend$/$Family$,250,$$$,100,150,,,,,,,],[6,2762,$Roussesu,Dallas,Bankruptcy,Friend$/$Family$,4,500,$$$,4,500,0,,,,$Referral Ballings$],[7,1498,$Tovarez,Dallas,Bankuptcy,Chamber of Commerce,$300,$$$,100,200,,,,$Referral,,,$],[8,1085,$Rousseau,Dallas,Bankruptcy,Online Search,$500,$$$,400,100,,,,$Chamber of Commerce$],[9,1992,$Rousseau,Dallas,Civil Litigation,Social Medis,$500,$$$,-,500,,,,$Balled,$5,7\mathrm{.}800,],[10,1214,$Rousseau,Dallas,Civil Litigation,Social Media,$3,000,s,1,000,2000,,,,,,,],[11,1153,$Rousseau,Dallas,Civil Litigation,Online Search,$500,5,500,0,,,,,,,],[12,1696,$Tovarez,Dallas,Real Estate,Other,$500,$$$,100,400,,,,,,,],[13,1512,$Tovarez,Dallas,Real Estate,Other,$2,050,5,-,2050,,,,,,,],[14,1035,$Rousseou,Dallas,RealEstate,Online Search,$1,500,$S$,500,1000,,,,,,,],[15,1559,$Rousseau,Dalles,Small Business,Online Search,$1,500,5,1\mathrm{.}500,0,,,,,,,],[16,1266,$Tovarez,Dallas,Small Business,Chamber of Commerce,$300,$$$,300,0,,,,,,,],[17,2063,$Tavarez,Dallas,Small Businesi,Other,$500,5,-,500,,,,,,,],[18,1484,$Lewis,Houston,Bankruptcy,Friend$/$Family$,2,050,5,2,000,50,,,,,,,],[19,1742,$Lewis,Houston,Bankruptcy,Social Media,$300,5,500,0,,,18,,,,],[20,2134,$Lewis,Houston,Civil Litigation,Chamber of Cornmerce,$4,500,$$$,1,000,3500,,,,,,,],[21.,1300,$Lewis,Houston,Estate Planning,Online Search,$3,000,$$$,3,000,0,,,,,,,],[22,1167,$Lewis,Houston,Small Buxiness $[,$Chamber of Commerce,$1,500,$$$,500,1000.,,,,,,,],[23,,,,\backslash$table$[[$miend$],[$online$]],$trandy,,,,,,,,,,,$],[24,,,,$cunbe,,,,,,,,,,,,$],[25,,,,\backslash$table$[[$Socials$],[$other$]],$Aldia,,,,,,,,,,,$],[26,,,,,,,,,,,,,,,,.]]$