Clyboard RS 1 Animals & Us For xv Arment Menye & Center Conditional Format a Cell Formatting able inst Delete Format Chal Set Fines F-Select- Number Ce D E F G " N P 9 n Author Create a named range for each of Author Create a Chart the revenue showing the % of Total Nevene for each Category Revenue (in thousands Categories 1st Q 2nd C 3rd Q 4th Q Total 4 100 1253 1427 1454 5 Grooming 760 790 00 6 Drug Sales 750 733 738 7 Obence School 1205 1300 1207 1299 B Total Sales 3727 4347 4381 10 Percentage increase 11 2nd d 12 Visit 13 Drug Sales use the named range a SUM function formula to determine the total revenue of each category over the 4 gates 14 Groning 15 Obedience School 17 18 19 Author for each of the darten cute a mithematical formal to detene the ncrease from the Then apply conditonal formatting to all these co Sales Green Yelow Red- where green x good red bad reloas n the middle the is the default choice and works for Author for % of Total create a mathemato formula to determine the percentage of revenue for each category to the total revenue please use an absok reference for cel 20 a O Revenue Tab Docment Properties and R 4:00 AM 3/11/2