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 mostviewed 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: 
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: 
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 
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 mostviewed 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: 
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: 
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 
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 mostviewed 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: 
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: 
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 
EXP ECH08 H2 – Investment Banking 1.1
EXP ECH08 H2 – Investment Banking 1.1EXP ECH08 H2 – Investment Banking 1.1EXP ECH08 H2 – Investment Banking 1.1
Project Description:
Project Description: Project Description: Project Description:
You are an investment banker and you would like to put together a brief statistical report of the mostviewed 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
You are an investment banker and you would like to put together a brief statistical report of the mostviewed 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 2You are an investment banker and you would like to put together a brief statistical report of the mostviewed 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 2You are an investment banker and you would like to put together a brief statistical report of the mostviewed 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:
Instructions: Instructions: Instructions:
For the purpose of grading the project you are required to perform the following tasks:
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: 
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: 
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 
Step
Instructions
Points Possible
Step
Instructions
Points Possible
Step
Step
StepStepStep
Instructions
Instructions
InstructionsInstructionsInstructions
Points Possible
Points Possible
Points PossiblePoints PossiblePoints 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
1
Start Excel. Open exploring_e08_grader_h2_Stocks.xlsx and save the workbook as exploring_e08_grader_h2_Stocks_LastFirst.
0
1
1
111
Start Excel. Open exploring_e08_grader_h2_Stocks.xlsx and save the workbook as exploring_e08_grader_h2_Stocks_LastFirst.
Start Excel. Open exploring_e08_grader_h2_Stocks.xlsx and save the workbook as exploring_e08_grader_h2_Stocks_LastFirst.
Start Excel. Open exploring_e08_grader_h2_Stocks.xlsx and save the workbook as exploring_e08_grader_h2_Stocks_LastFirst.exploring_e08_grader_h2_Stocks.xlsx exploring_e08_grader_h2_Stocks_LastFirst
0
0
0
2
Type Symbol in cell B4 and type Last Sale Price in cell C4.
5
2
2
222
Type Symbol in cell B4 and type Last Sale Price in cell C4.
Type Symbol in cell B4 and type Last Sale Price in cell C4.
Type Symbol in cell B4 and type Last Sale Price in cell C4.Symbol Last Sale Price
5
5
5
3
Adjust the width of column C to 13 (96 pixels).
5
3
3
333
Adjust the width of column C to 13 (96 pixels).
Adjust the width of column C to 13 (96 pixels).
Adjust the width of column C to 13 (96 pixels).
5
5
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
4
4
444
Enter the following stock information beginning in cell B5:
CTIC 2.88
AAPL 90.73
C 47.35
BAC 15.40
DNDN 2.31
Enter the following stock information beginning in cell B5:
CTIC 2.88
AAPL 90.73
C 47.35
BAC 15.40
DNDN 2.31
Enter the following stock information beginning in cell B5:
CTIC 2.88
AAPL 90.73
C 47.35
BAC 15.40
DNDN 2.31
CTIC 2.88
AAPL 90.73
C 47.35
BAC 15.40
DNDN 2.31
12
12
12
5
Apply the Accounting Number Format to the stock prices in column C.
6
5
5
555
Apply the Accounting Number Format to the stock prices in column C.
Apply the Accounting Number Format to the stock prices in column C.
Apply the Accounting Number Format to the stock prices in column C.
6
6
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
6
6
666
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.
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.
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
14
14
7
Adjust the width of column E to 17 (124 pixels).
5
7
7
777
Adjust the width of column E to 17 (124 pixels).
Adjust the width of column E to 17 (124 pixels).
Adjust the width of column E to 17 (124 pixels).
5
5
5
8
Type Symbol in cell H4 and type Last Sale Price in cell I4.
5
8
8
888
Type Symbol in cell H4 and type Last Sale Price in cell I4.
Type Symbol in cell H4 and type Last Sale Price in cell I4.
Type Symbol in cell H4 and type Last Sale Price in cell I4.Symbol Last Sale Price
5
5
5
9
Adjust the width of column I to 13 (96 pixels).
5
9
9
999
Adjust the width of column I to 13 (96 pixels).
Adjust the width of column I to 13 (96 pixels).
Adjust the width of column I to 13 (96 pixels).
5
5
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
10
10
101010
Enter the following stock information beginning in cell H5:
CTIC 2.85
AAPL 91.51
C 47.05
BAC 15.35
DNDN 2.21
Enter the following stock information beginning in cell H5:
CTIC 2.85
AAPL 91.51
C 47.05
BAC 15.35
DNDN 2.21
Enter the following stock information beginning in cell H5:
CTIC 2.85
AAPL 91.51
C 47.05
BAC 15.35
DNDN 2.21
CTIC 2.85
AAPL 91.51
C 47.05
BAC 15.35
DNDN 2.21
12
12
12
11
Apply the Accounting Number Format to the stock prices in column I.
6
11
11
111111
Apply the Accounting Number Format to the stock prices in column I.
Apply the Accounting Number Format to the stock prices in column I.
Apply the Accounting Number Format to the stock prices in column I.
6
6
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
12
12
121212
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.
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.
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
14
14
13
Adjust the width of column K to 17 (124 pixels).
5
13
13
131313
Adjust the width of column K to 17 (124 pixels).
Adjust the width of column K to 17 (124 pixels).
Adjust the width of column K to 17 (124 pixels).
5
5
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
14
14
141414
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.
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.
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.Constance Fournier
6
6
6
15
Save the workbook. Close the workbook and exit Excel. Submit the workbook as directed.
0
15
15
151515
Save the workbook. Close the workbook and exit Excel. Submit the workbook as directed.
Save the workbook. Close the workbook and exit Excel. Submit the workbook as directed.
Save the workbook. Close the workbook and exit Excel. Submit the workbook as directed.
0
0
0
Total Points
100
Total Points
Total Points
Total PointsTotal PointsTotal Points
100
100
100100100