I need help understanding what to input for the IF function in question 5. Also, question number 6 explained better.

can purchase with your savings based on today's price for each company. 1. Enter the data above into an Excel worksheet. The column heading should be on two lines within the cell as shown. Be sure to include the title Stock Shares for Hint: The formula should be 2100 Investment Corporation and include your divide by the Current Price. name as the subtitle. 5. In the Increased or Decreased column, 2.SavetheworksheetasExcelTest.3.UsingthePercentofGrowthcolumn,calculatethepercentofgrowth(ordecline)fromlastyeartothisyearforeachcompanybyenteringtheappropriateformula.Thepercentofgrowthiscalculatedbysubtracting(currentpricefromthelastyearprice)anddividingtheresultbylastyearsprice.enteraformulathatwilldisplay"Increased"ifthevalueofthesharesincreasedor"Decreased"ifthevalueofthestockdecreasedfromlastyeartothisyear.Increatingtheformula,usetheIfStatementDialogBox.YouwillneedtoenterIncreasedas"Increased"andDecreasedas"Decreased".ThistellsExcelthattextwillbetheresult. 6. Determine the Average, Minimum and - Hint: (Current Price - Last Year Price) Maximum Current Price. Determine the needs parentheses around before dividing by Last Year Price. Totals for "Last Year Price", "Current Price", and "Possible Share Purchase" columns. If the result is a negative number, there was Formatting of the worksheet a decline rather than growth. Format the 7. For the Title, Center Across all Columns. column to a percent with one decimal Change the Point Size to 14 for both the Title and the Sub Title. 4. Using the Possible Share Purchase column, calculate how many shares you 1