Part A: In this section, you will identify the highest paid CEOs in S&P $500$ firms. $$HW Lookup

Functions$\_$PortCreation.xlsx$$ includes the following data on CEO compensation in the years $2005$ and

$2009$: company name, CEO total compensation $($salary$,$ bonus, stock options, etc.$),$ CEO salary, CEO cash

bonus, the company$$s industry, and two ranking variables. SP$500\_$Rank$\_$TotalComp is each company's

rank amongst all S&P $500$ firms based on total CEO compensation and Industry$\_$Rank$\_$TotalComp is

each company's rank within its industry based on total CEO compensation. Using the data provided in

the Raw Data worksheets, along with the provided templates, complete the following tasks:

$1.$ Create a list of the top $100$ highest paid CEOs $($based on total compensation$)$ in S&P $500$ firms by

filling in the table in the $"$S&P$500$ Top $100"$ worksheet. Be sure to setup the table such that the

user can easily view the results using either $2005$ or $2009$ compensation data.

$2.$ Create a list of the five highest paid CEOs $($based on total compensation$)$ in each industry by

filling in the table in the "Industry Top $5"$ worksheet. Be sure to setup the table such that it

updates based on the industry and year chosen by the user.

$1$