EX16_XL_CH08_GRADER_ML1_HW - Investment Banking 1.2 Project Description: You are an investment banker and you would like to put together a brief statistical report of the most-viewed stock quotes for the day. To complete this task, you will enter stock prices and create a report using the Analysis ToolPak. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible Start Excel. Open exploring_e08_grader_ml_Stocks.xlsx. 0.000 2 Type Symbol in cell B2, type Last Sale Price in cell C2, and type Rank in cell D2. 12.000 Enter the following stock information beginning in cell B3: Click cell B3 and type CTIC. Click cell C3 3 and type 1.92. Click cell B4 and type AAPL. Click cell C4 and type 130.96. Click cell B5 and type C. 8.000 Click cell C5 and type 59.19. Click cell BG and type BAC. Click cell C6 and type 18.12. Use the RANK.AVG function to calculate the rank of the first stock in cell D3 and copy the formula 12.000 down to complete the column. 5 Click cell B8, type Average value, and in cell CB type