The Data file contains the annual investment return percentages for stocks and treasury bills from 1928 to 2021. Use Excel functions to analyze this data.

1. Enter a formula in cell D3 to determine which investment had the higher return in each year. Use the IF function to set the cell to Stocks if Stocks return was greater than or equal to TBills return, or TBills if they had the higher return. Use the fill handle to copy the formula down Col D to repeat the calculation for each year.
2. Enter a formula in cell B98 to calculate the average return percentage on stocks from 1928 to 2021. Use the fill handle to copy the formula across to C98, to repeat the calculation for TBills.
3. Enter a formula in cell B99 to determine the highest rate of return on stocks over the 94-year range. Copy the formula to cell C99 to make the same calculation for TBills.
4. Use Conditional Formatting to format any negative returns on Stocks and TBills with light red fill and dark red text. Do this with one conditional formatting rule.