1. What is the function in the yellow cell?

assigment 3 Q. Tahoma ( 11 . A-A- 2 BIU % of index greater than 10 year 1) Using the index and match formulas combined with a max formula, determine what the ticker of the S&P 500 stock with the highest dividend yield. Market Cap with Dividends Industry 10 year treasury rate Market Cap Total 539,980,611,788 866,411,745,704 673,751,641,257 143,528,830,213 25.9% Health Care 2,752,032,592,125 4,449,132 2,682,670 303,969 15.1% 93.0% 165,589,399,197 904,018 292 21.4734 172 64.6% 14.8% 55.0% 78.8% 114,637214,656 index ALXN Real Estate Telecommunication Services 465,181,434,591 459 957.1 -sumifs -sumif) APPLE INC AES CORP Information Technol 682 147 71 7412,433,445 209,761,000 8,657,317,194 AFFILTATED MANAGERS GROUP Financials vlookup) -indexl, match at Formula Examples + + 111%