EXP ECH08 H2 Investment Banking 1.1 complete solutions correct answers key

EXP ECH08 H2 Investment Banking 1.1 complete solutions correct answers key

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. You will also track the same stocks on Day 2

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Excel. Open exploring_e08_grader_h2_Stocks.xlsx and save the workbook as exploring_e08_grader_h2_Stocks_LastFirst.

0

2

Type Symbol in cell B4 and type Last Sale Price in cell C4.

5

3

Adjust the width of column C to 13 (96 pixels).

5

4

Enter the following stock information beginning in cell B5:
CTIC              2.88
AAPL           90.73
C                  47.35
BAC             15.40
DNDN           2.31

12

5

Apply the Accounting Number Format to the stock prices in column C.

6

6

Create 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.

14

7

Adjust the width of column E to 17 (124 pixels).

5

8

Type Symbol in cell H4 and type Last Sale Price in cell I4.

5

9

Adjust the width of column I to 13 (96 pixels).

5

10

Enter the following stock information beginning in cell H5:
CTIC              2.85
AAPL           91.51
C                  47.05
BAC             15.35
DNDN            2.21

12

11

Apply the Accounting Number Format to the stock prices in column I.

6

12

Create 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.

14

13

Adjust the width of column K to 17 (124 pixels).

5

14

Create 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.

6

15

Save the workbook. Close the workbook and exit Excel. Submit the workbook as directed.

0

Total Points

100