1 . Create the named ranges listed in the table below . Industry_ Name REVENUE $253:5256054 Group _ Name* DEC 4. DESTI Total REVENUE Quartile* Rank_ Quartile $1 4: 5 KIT Industry _ Total_ Revenue_ Rank_ Quartile\ \$DS 4: 565 7 1 4. For Each industry name , calculate total revenue . I'VE a SUMIIF Function that includes the named ranges Industry_ _^ave and FLEVENUE E. In the Overall Rank column , assign a rank to each industry based on its total revenue . I'VE a RANKED Function that includes the named range Total_ Revenue . Rank the list in descending order . For Example , the industry that has the most total revenue has a rank of #1 ", and the industry that has the least total revenue has a rank of " 6{` C. I'VE VLOOKUP to assign Each industry to a quartile based on it's rank . I'VE the named Large Font_ Quartile . D. For Each industry, USE COL^ I IF to count the number of firms that compose the industry. E. I'VE JIGOKUF and the named range Industy _ Total_ FLUENCE _ Fare_ Quartile to find the total revenue , overall rank , and quartile for the three industries listed in table E F. I'VE SUMIIFS and the named ranges Group_ Jane, Total_ Fluence, and Quartile to calculate* the total revenue for & given quartile and industry group*