$1.$ Enter a COUNTIF function in cell B$3$ on the Summary worksheet. The function should count the entries in the Investment Type column on the Investment Detail worksheet that match cell A$3$ on the Summary worksheet. Include cell capacity through row $25$ when defining arguments that require a cell range and use absolute references when needed.

$2.$ Copy cell B$3$ and paste it into the range B$4$:B$6$ using the Paste Formulas command.

$3.$ Enter an AVERAGEIF function in cell C$3$ on the Summary worksheet. The function should compute the average of the entries in the Dividend$/$Yield column on the Investment Detail worksheet where there is a match in the Investment Type column on the Investment Detail worksheet with cell A$3$ on the Summary worksheet. Include cell capacity through row $25$ when defining arguments that require a cell range and use absolute references when needed.

$4.$ Copy cell C$3$ and paste it into the range C$4$:C$6$ using the Paste Formulas command.

$5.$ Enter a SUMIF function in cell D$3$ on the Summary worksheet. The function should compute the sum of the entries in the Current Percent of Portfolio column on the Investment Detail worksheet where there is a match in the Investment Type column on the Investment Detail worksheet with cell A$3$ on the Summary worksheet. Include cell capacity through row $25$ when defining arguments that require a cell range and use absolute references when needed.

$6.$ Copy cell D$3$ and paste it into the range D$4$:D$6$ using the Paste Formulas command.

$7.$ Enter a COUNTIFS function in cell B$10$ on the Summary worksheet. The function should count the number of investments on the Investment Detail worksheet that match the investment type in cell A$10$ on the Summary worksheet and achieved a gain that is greater than or equal to $15\%.$ Use the Percent Gain$/$Loss column on the Investment Detail worksheet to evaluate the gains for each investment. Include cell capacity through row $25$ when defining arguments that require a cell range and use absolute references when needed.

$8.$ Copy cell B$10$ and paste it into range B$11$:B$13$ using the Paste Formulas command.

$9.$ Enter a SUMIFS function in cell C$10$ on the Summary worksheet. The purpose of the function is to sum the values in the Unrealized Gain$/$Loss column on the Investment Detail worksheet based on two conditions. The first is where the Investment Type column on the Investment Detail worksheet matches the investment type in cell A$10.$ The second condition is where the value in the Percent Gain$/$Loss column on the Investment Detail worksheet is greater than or equal to $15\%.$ Include cell capacity through row $25$ when defining arguments that require a cell range and use absolute references when needed.

$10.$ Copy cell C$10$ and paste it into the range C$11$:C$13$ using the Paste Formulas command.

$11.$ Enter an AVERAGEIFS function in cell D$10$ on the Summary worksheet. The purpose of the function is to compute the average of the values in the Months Owned column on the Investment Detail worksheet based on two conditions. The first condition is where the Investment Type column on the Investment Detail worksheet matches the investment type in cell A$10.$ The second condition is where the value in the Percent Gain$/$Loss column on the Investment Detail worksheet is greater than or equal to $15\%.$ Include cell capacity through row $25$ when defining arguments that require a cell range and use absolute references when needed.

$12.$ Copy cell D$10$ and paste it into the range D$11$:D$13$ using the Paste Formulas command.

$13.$ Enter a CONCATENATE function in the merged cell range beginning with cell A$7$ in the Summary worksheet. The function should combine the phrase $$Error Warning:$$ with the entry in cell D$1$ on the Investment Detail worksheet.