Use data in Pivot_table_data tab, do the following tasks: 1) There is an unfilled column titled "Industry" in the data (next to SIC code column and highlighted in light green). According to NAICS association, SIC code is used to define different industries. In this data, there are three different industries defined by NAICS: SIC Code 20-39 40-49 52-59 Industry Manufacturing Transportation and Communication Retail Trade Use IF statement to fill out the column "Industry" according to the above definition. Please note there are three cases in this case, so you need to use nested IF statement. 2) Create a report of annual total dividends paid per share by firm for each year, grouped by stock exchange (NYSE = 'N'; NASDAQ = 'Q'). To group by exchange then stock, make sure that Exchange is above the stock ticker/name in the Row Labels field. Do not report grand total or subtotals. Format the numbers in the report with two