Open the starter file listed above before you begin this test. Open the starter file before you begin this test. $1.2.3.4.5.6.7.$ Set the Freeze Panes command so that Rows $1$ and $2$ and Columns A and B are locked in place while scrolling through the Investment Detail worksheet. In the Investment Detail worksheet, enter an IF function into cell I$3.$ The output of the function should be the word Gain if the Current Investment Value in cell H$3$ is greater than the Cost of Purchase in cell G$3.$ Otherwise, the output of the function should be the words No Gain. Copy the IF function in cell I$3$ and paste it into the range I$4$:I$17$ using the Paste Formulas command. In the Investment Detail worksheet, enter a nested IF function into cell F$3.$ If the Dividend$/$Yield value in cell E$3$ is less than $2\%,$ show the word Low. If the Dividend$/$Yield value in cell E$3$ is greater than or equal to $5\%,$ show the word High. Otherwise, show the word Moderate. Copy the IF function in cell F$3$ and paste it into the range F$4$:F$17$ using the Paste Formulas command. On the Investment Detail worksheet in cell O$3,$ use the OR function within an IF function to evaluate the Current vs$.$ Target value. If the Current vs$.$ Target value in cell N$3$ is greater than $2\%$ or less than $2\%,$ show the word REBAL. Otherwise, show the word OK$.$ Copy the IF function in cell O$3$ and paste it into the range O$4$:O$17$ using the Paste Formulas command. On the Investment Detail worksheet in cell P$3,$ use the AND function within an IF function to evaluate the Current vs$.$ Target value and the Unrealized Gain$/$Loss value. If the Current vs$.$ Target value in cell N$3$ is greater than $2\%$ and if the Unrealized Gain$/$Loss value in cell J$3$ is greater than $0,$ show the word BUY. Otherwise, show the word HOLD. $8.9.$ Copy the IF function in cell P$3$ and paste it into the range P$4$:P$17$ using the Paste Formulas command. On the Investment Detail worksheet, apply a conditional format to the range Q$3$:Q$17.$ If the Months Owned is less than $12,$ change the font color to red. Otherwise, the font color should remain black. $10.$ On the Investment Detail worksheet, enter a VLOOKUP function in cell D$3$ that displays the Growth Last Year for the symbol in cell B$3.$ The growth last year for all investments can be found in Column E on the Investment List worksheet. Your function should look for an exact match to the lookup value. Consider that this function will be copied and pasted into the range D$4$:D$17$ when defining the arguments. On the Investment Detail worksheet, format the range D$3$:D$17$ to a percentage with two decimal places. Then copy the VLOOKUP function in cell D$3$ and paste it into the range D$4$:D$17$ using the Paste Formulas command. $11.$ On the Portfolio Summary worksheet, use the COUNTIF function in cell B$3$ to count the number of investments that match the investment type in cell A$3.$ The function should look for and count the number of investment types in the range A$3$:A$17$ on the Investment Detail worksheet. Consider that this function will be copied and pasted into the range B$4$:B$6$ when defining the arguments. $12.$ Copy the COUNTIF function in cell B$3$ and paste it into the range B$4$:B$6$ using the Paste Formulas command. $13.$ On the Portfolio Summary worksheet, use the AVERAGEIF function in cell C$3$ to calculate the average Dividend$/$Yield for the investment type in cell A$3.$ The function should calculate the average using the data in the range E$3$:E$17$ on the Investment Detail worksheet. The function should look for a match to the investment type in the range A$3$:A$17$ on the Investment Detail worksheet. Consider that this function will be copied and pasted into the range C$4$:C$6$ when defining the arguments. $14.$ Copy the AVERAGEIF function in cell C$3$ and paste it into the range C$4$:C$6$ using the Paste Formulas command. $15.$ On the Portfolio Summary worksheet, use the SUMIF function in cell D$3$ to calculate the Percent of Portfolio for the investment type in cell A$3.$ The function should calculate the sum using the data in the range L$3$:L$17$ on the Investment Detail worksheet. The function should look for a match to the investment type in the range A$3$:A$17$ on the Investment Detail worksheet. Consider that this function will be copied and pasted into the range D$4$:D$6$ when defining the arguments. $16.$ Copy the SUMIF function in cell D$3$ and paste it into the range D$4$:D$6$ using the Paste Formulas command. $17.$ On the Portfolio Summary worksheet, use the HLOOKUP function to display the Portfolio Target in cell E$3.$ The function should look for the Investment Type in cell A$3$ in Row $2$ of the Portfolio Targets worksheet. The function should display the percentage in the Moderate row $($Row $5)$ for each investment type. The function should look for an exact match to the lookup value. Consider that this function will be copied and pasted into the range E$4$:E$6$ when defining the arguments. $18.$ Copy the HLOOKUP function in cell E$3$ and paste it into the range E$4$:E$6$ using the Paste Formulas command. $19.$ On the Portfolio Summary worksheet, use the COUNTIFS