+
Excel Project EXP ECH08 H2 - Investment Banking 1.1

Excel Project EXP ECH08 H2 - Investment Banking 1.1

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/excel-project-exp-ech08-h2-investment-banking-1-1/

EXP ECH08 H2 - Investment Banking 1.1
 
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 asexploring_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.35BAC             15.40DNDN           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


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial