You are an investment Notes

  • 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

    http://assignment.store/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/\n\nEXP ECH08 H2 - Investment Banking 1.1\n\nProject Description:\n\nYou 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. You will also track the same stocks on Day 2\n\nInstructions:\n\nFor the purpose of grading the project you are required to perform the following tasks:\n\nStep\n\nInstructions\n\nPoints Possible\n\n1\n\nStart Excel. Open exploring\\_e08\\_grader\\_h2\\_Stocks.xlsx and save the workbook as exploring\\_e08\\_grader\\_h2\\_Stocks\\_LastFirst.\n\n0\n\n2\n\nType Symbol in cell B4 and type Last Sale Price in cell C4.\n\n5\n\n3\n\nAdjust the width of column C to 13 (96 pixels).\n\n5\n\n4\n\nEnter the following stock information beginning in cell B5: \n\nCTIC 2.88 \n\nAAPL 90.73 \n\nC 47.35\n\nBAC 15.40\n\nDNDN 2.31\n\n12\n\n5\n\nApply the Accounting Number Format to the stock prices in column C.\n\n6\n\n6\n\nCreate a descriptive statistics summary report using the range C4:C9 as the input range and cell E4 as the output range. Note that the first row of the input range contains labels.\n\n14\n\n7\n\nAdjust the width of column E to 17 (124 pixels).\n\n5\n\n8\n\nType Symbol in cell H4 and type Last Sale Price in cell I4.\n\n5\n\n9\n\nAdjust the width of column I to 13 (96 pixels).\n\n5\n\n10\n\nEnter the following stock information beginning in cell H5: \n\nCTIC 2.85 \n\nAAPL 91.51 \n\nC 47.05 \n\nBAC 15.35 \n\nDNDN 2.21\n\n12\n\n11\n\nApply the Accounting Number Format to the stock prices in column I.\n\n6\n\n12\n\nCreate a descriptive statistics summary report using the range I4:I9 as the input range and cell K4 as the output range. Note that the first row of the input range contains labels.\n\n14\n\n13\n\nAdjust the width of column K to 17 (124 pixels).\n\n5\n\n14\n\nCreate a footer with the name Constance Fournier on the left side, the name of the worksheet in the middle, and the file name on the right side.\n\n6\n\n15\n\nSave the workbook. Close the workbook and exit Excel. Submit the workbook as directed.\n\n0\n\nTotal Points\n\n100"},{"left":"","right":""},{"left":"","right":""},{"left":"","right":""}]


Sign Up Free