TUTUNU, Limering the next higher value as the column to look up (from 3 up to 12). Y Explore 15. In cell B18, display the 30-day high value for the selected fund using the MAX func tion. Nest the INDIRECT function within the MAX function, using the named range Symbol as the input value for the INDIRECT function. 16. Repeat Step 15 using the MIN function in cell B19 to return the 30-day low of the selected fund and using the AVERAGE function in cell B20 to return the 30-day average of the selected fund. 99 Explore 17. In cell B21, calculate the average shares traded per day using the AVERAGE function. Nest the INDIRECT function within the AVERAGE function, using the argument Symbol&"_Shares" to reference the named range of shares traded for the selected fund. 18. Test the formulas you created by changing the value in cell B4 to SNRFD, AIF, LTDX, and then IHGF, verifying that a different set of information and summary statistics appears for each symbol. Explore 19. In the Documentation sheet, in the range A8:B24, paste a list of the defined names used in the workbook. On the Formulas tab, in the Defined Names group, click the Use in Formula button, and then click Paste Names. In the Paste Name dialog box, click Paste List. TUTUNU, Limering the next higher value as the column to look up (from 3 up to 12). Y Explore 15. In cell B18, display the 30-day high value for the selected fund using the MAX func tion. Nest the INDIRECT function within the MAX function, using the named range Symbol as the input value for the INDIRECT function. 16. Repeat Step 15 using the MIN function in cell B19 to return the 30-day low of the selected fund and using the AVERAGE function in cell B20 to return the 30-day average of the selected fund. 99 Explore 17. In cell B21, calculate the average shares traded per day using the AVERAGE function. Nest the INDIRECT function within the AVERAGE function, using the argument Symbol&"_Shares" to reference the named range of shares traded for the selected fund. 18. Test the formulas you created by changing the value in cell B4 to SNRFD, AIF, LTDX, and then IHGF, verifying that a different set of information and summary statistics appears for each symbol. Explore 19. In the Documentation sheet, in the range A8:B24, paste a list of the defined names used in the workbook. On the Formulas tab, in the Defined Names group, click the Use in Formula button, and then click Paste Names. In the Paste Name dialog box, click Paste List
