Project Description:
You own a tour company that provides historical tours and activities for vacationers in Boston, Massachusetts. You want weather statistics to compare to your sales for the period. You will copy and paste data from a Web site into your Excel worksheet and use that data to create summary statistics and charts.
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_e10_grader_h2_Weather.xlsx and save the workbook as exploring_e10_grader_h2_Weather_LastFirst. 
0.000 
2 
Open the downloaded file Ch10_H2_WeatherData. Copy the data on Sheet 1 in the range A1:F98 and then paste it on the Raw Data worksheet for this project starting in cell A5. 
3.000 
3 
Bold the headings on rows 5 and 6 and then apply Align Right to the headings on row 6. Add a bottom border to the range B5:F5. Apply the same formatting to rows 38 and 39 and rows 70 and 71. 
5.000 
4 
Create a nested function in cell G7 that displays sunny for any day that does not have an event observation and repeats events if listed. Nest the function in a function that displays the results in uppercase letters. Copy the function through cell G102, then delete the functions on heading rows between months. Enter Weather in cell G6 and autofit the width of the column. 
9.000 
5 
On the Statistics worksheet, enter functions in the range B4:D4 that will display the number of sunny days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
6 
On the Statistics worksheet, enter functions in the range B5:D5 that will display the number of rainy days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
7 
On the Statistics worksheet, enter functions in the range B6:D6 that will display the number of foggy days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
8 
On the Statistics worksheet, enter functions in the range B7:D7 that will display the number of snowy days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
9 
On the Statistics worksheet, enter functions in the range B8:D8 that will display the average high temperatures for each of the three months using the data from the Raw Data worksheet (use the AVERAGE function). Enter similar functions in the range B9:D10. 
12.000 
10 
On the Statistics worksheet, enter functions in the range B11:D11 that will display the total precipitation for each of the three months using the data from the Raw Data worksheet. Enter similar functions in the range B12:D13 using the AVERAGE and MAX functions. 
12.000 
11 
Use columns B:D from the Raw Data worksheet to create three line charts – one per month – to plot the daily high, average, and low temperatures. Place each line chart on a separate sheet, and name the sheets November Temps, December Temps, and January Temps, respectively. 
18.000 
12 
Add the chart title November Temperatures to the November chart, December Temperatures to the December chart, and January Temperatures to the January chart. 
5.000 
13 
Save the workbook. Ensure that the worksheets are named correctly and in the following order: November Temps, December Temps, January Temps, Raw Data, and Statistics. Close the workbook and exit Excel. Submit the workbook as directed. 
0.000 

Total Points 
100.000 
Project Description:
You own a tour company that provides historical tours and activities for vacationers in Boston, Massachusetts. You want weather statistics to compare to your sales for the period. You will copy and paste data from a Web site into your Excel worksheet and use that data to create summary statistics and charts.
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_e10_grader_h2_Weather.xlsx and save the workbook as exploring_e10_grader_h2_Weather_LastFirst. 
0.000 
2 
Open the downloaded file Ch10_H2_WeatherData. Copy the data on Sheet 1 in the range A1:F98 and then paste it on the Raw Data worksheet for this project starting in cell A5. 
3.000 
3 
Bold the headings on rows 5 and 6 and then apply Align Right to the headings on row 6. Add a bottom border to the range B5:F5. Apply the same formatting to rows 38 and 39 and rows 70 and 71. 
5.000 
4 
Create a nested function in cell G7 that displays sunny for any day that does not have an event observation and repeats events if listed. Nest the function in a function that displays the results in uppercase letters. Copy the function through cell G102, then delete the functions on heading rows between months. Enter Weather in cell G6 and autofit the width of the column. 
9.000 
5 
On the Statistics worksheet, enter functions in the range B4:D4 that will display the number of sunny days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
6 
On the Statistics worksheet, enter functions in the range B5:D5 that will display the number of rainy days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
7 
On the Statistics worksheet, enter functions in the range B6:D6 that will display the number of foggy days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
8 
On the Statistics worksheet, enter functions in the range B7:D7 that will display the number of snowy days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
9 
On the Statistics worksheet, enter functions in the range B8:D8 that will display the average high temperatures for each of the three months using the data from the Raw Data worksheet (use the AVERAGE function). Enter similar functions in the range B9:D10. 
12.000 
10 
On the Statistics worksheet, enter functions in the range B11:D11 that will display the total precipitation for each of the three months using the data from the Raw Data worksheet. Enter similar functions in the range B12:D13 using the AVERAGE and MAX functions. 
12.000 
11 
Use columns B:D from the Raw Data worksheet to create three line charts – one per month – to plot the daily high, average, and low temperatures. Place each line chart on a separate sheet, and name the sheets November Temps, December Temps, and January Temps, respectively. 
18.000 
12 
Add the chart title November Temperatures to the November chart, December Temperatures to the December chart, and January Temperatures to the January chart. 
5.000 
13 
Save the workbook. Ensure that the worksheets are named correctly and in the following order: November Temps, December Temps, January Temps, Raw Data, and Statistics. Close the workbook and exit Excel. Submit the workbook as directed. 
0.000 

Total Points 
100.000 
Project Description:
You own a tour company that provides historical tours and activities for vacationers in Boston, Massachusetts. You want weather statistics to compare to your sales for the period. You will copy and paste data from a Web site into your Excel worksheet and use that data to create summary statistics and charts.
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_e10_grader_h2_Weather.xlsx and save the workbook as exploring_e10_grader_h2_Weather_LastFirst. 
0.000 
2 
Open the downloaded file Ch10_H2_WeatherData. Copy the data on Sheet 1 in the range A1:F98 and then paste it on the Raw Data worksheet for this project starting in cell A5. 
3.000 
3 
Bold the headings on rows 5 and 6 and then apply Align Right to the headings on row 6. Add a bottom border to the range B5:F5. Apply the same formatting to rows 38 and 39 and rows 70 and 71. 
5.000 
4 
Create a nested function in cell G7 that displays sunny for any day that does not have an event observation and repeats events if listed. Nest the function in a function that displays the results in uppercase letters. Copy the function through cell G102, then delete the functions on heading rows between months. Enter Weather in cell G6 and autofit the width of the column. 
9.000 
5 
On the Statistics worksheet, enter functions in the range B4:D4 that will display the number of sunny days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
6 
On the Statistics worksheet, enter functions in the range B5:D5 that will display the number of rainy days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
7 
On the Statistics worksheet, enter functions in the range B6:D6 that will display the number of foggy days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
8 
On the Statistics worksheet, enter functions in the range B7:D7 that will display the number of snowy days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
9 
On the Statistics worksheet, enter functions in the range B8:D8 that will display the average high temperatures for each of the three months using the data from the Raw Data worksheet (use the AVERAGE function). Enter similar functions in the range B9:D10. 
12.000 
10 
On the Statistics worksheet, enter functions in the range B11:D11 that will display the total precipitation for each of the three months using the data from the Raw Data worksheet. Enter similar functions in the range B12:D13 using the AVERAGE and MAX functions. 
12.000 
11 
Use columns B:D from the Raw Data worksheet to create three line charts – one per month – to plot the daily high, average, and low temperatures. Place each line chart on a separate sheet, and name the sheets November Temps, December Temps, and January Temps, respectively. 
18.000 
12 
Add the chart title November Temperatures to the November chart, December Temperatures to the December chart, and January Temperatures to the January chart. 
5.000 
13 
Save the workbook. Ensure that the worksheets are named correctly and in the following order: November Temps, December Temps, January Temps, Raw Data, and Statistics. Close the workbook and exit Excel. Submit the workbook as directed. 
0.000 

Total Points 
100.000 
Project Description:
Project Description: Project Description: Project Description:
You own a tour company that provides historical tours and activities for vacationers in Boston, Massachusetts. You want weather statistics to compare to your sales for the period. You will copy and paste data from a Web site into your Excel worksheet and use that data to create summary statistics and charts.
You own a tour company that provides historical tours and activities for vacationers in Boston, Massachusetts. You want weather statistics to compare to your sales for the period. You will copy and paste data from a Web site into your Excel worksheet and use that data to create summary statistics and charts.You own a tour company that provides historical tours and activities for vacationers in Boston, Massachusetts. You want weather statistics to compare to your sales for the period. You will copy and paste data from a Web site into your Excel worksheet and use that data to create summary statistics and charts.You own a tour company that provides historical tours and activities for vacationers in Boston, Massachusetts. You want weather statistics to compare to your sales for the period. You will copy and paste data from a Web site into your Excel worksheet and use that data to create summary statistics and charts.
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_e10_grader_h2_Weather.xlsx and save the workbook as exploring_e10_grader_h2_Weather_LastFirst. 
0.000 
2 
Open the downloaded file Ch10_H2_WeatherData. Copy the data on Sheet 1 in the range A1:F98 and then paste it on the Raw Data worksheet for this project starting in cell A5. 
3.000 
3 
Bold the headings on rows 5 and 6 and then apply Align Right to the headings on row 6. Add a bottom border to the range B5:F5. Apply the same formatting to rows 38 and 39 and rows 70 and 71. 
5.000 
4 
Create a nested function in cell G7 that displays sunny for any day that does not have an event observation and repeats events if listed. Nest the function in a function that displays the results in uppercase letters. Copy the function through cell G102, then delete the functions on heading rows between months. Enter Weather in cell G6 and autofit the width of the column. 
9.000 
5 
On the Statistics worksheet, enter functions in the range B4:D4 that will display the number of sunny days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
6 
On the Statistics worksheet, enter functions in the range B5:D5 that will display the number of rainy days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
7 
On the Statistics worksheet, enter functions in the range B6:D6 that will display the number of foggy days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
8 
On the Statistics worksheet, enter functions in the range B7:D7 that will display the number of snowy days for each of the three months using the data in column G from the Raw Data worksheet. 
9.000 
9 
On the Statistics worksheet, enter functions in the range B8:D8 that will display the average high temperatures for each of the three months using the data from the Raw Data worksheet (use the AVERAGE function). Enter similar functions in the range B9:D10. 
12.000 
10 
On the Statistics worksheet, enter functions in the range B11:D11 that will display the total precipitation for each of the three months using the data from the Raw Data worksheet. Enter similar functions in the range B12:D13 using the AVERAGE and MAX functions. 
12.000 
11 
Use columns B:D from the Raw Data worksheet to create three line charts – one per month – to plot the daily high, average, and low temperatures. Place each line chart on a separate sheet, and name the sheets November Temps, December Temps, and January Temps, respectively. 
18.000 
12 
Add the chart title November Temperatures to the November chart, December Temperatures to the December chart, and January Temperatures to the January chart. 
5.000 
13 
Save the workbook. Ensure that the worksheets are named correctly and in the following order: November Temps, December Temps, January Temps, Raw Data, and Statistics. Close the workbook and exit Excel. Submit the workbook as directed. 
0.000 

Total Points 
100.000 
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_e10_grader_h2_Weather.xlsx and save the workbook as exploring_e10_grader_h2_Weather_LastFirst.
0.000
2
Open the downloaded file Ch10_H2_WeatherData. Copy the data on Sheet 1 in the range A1:F98 and then paste it on the Raw Data worksheet for this project starting in cell A5.
3.000
3
Bold the headings on rows 5 and 6 and then apply Align Right to the headings on row 6. Add a bottom border to the range B5:F5. Apply the same formatting to rows 38 and 39 and rows 70 and 71.
5.000
4
Create a nested function in cell G7 that displays sunny for any day that does not have an event observation and repeats events if listed. Nest the function in a function that displays the results in uppercase letters. Copy the function through cell G102, then delete the functions on heading rows between months. Enter Weather in cell G6 and autofit the width of the column.
9.000
5
On the Statistics worksheet, enter functions in the range B4:D4 that will display the number of sunny days for each of the three months using the data in column G from the Raw Data worksheet.
9.000
6
On the Statistics worksheet, enter functions in the range B5:D5 that will display the number of rainy days for each of the three months using the data in column G from the Raw Data worksheet.
9.000
7
On the Statistics worksheet, enter functions in the range B6:D6 that will display the number of foggy days for each of the three months using the data in column G from the Raw Data worksheet.
9.000
8
On the Statistics worksheet, enter functions in the range B7:D7 that will display the number of snowy days for each of the three months using the data in column G from the Raw Data worksheet.
9.000
9
On the Statistics worksheet, enter functions in the range B8:D8 that will display the average high temperatures for each of the three months using the data from the Raw Data worksheet (use the AVERAGE function). Enter similar functions in the range B9:D10.
12.000
10
On the Statistics worksheet, enter functions in the range B11:D11 that will display the total precipitation for each of the three months using the data from the Raw Data worksheet. Enter similar functions in the range B12:D13 using the AVERAGE and MAX functions.
12.000
11
Use columns B:D from the Raw Data worksheet to create three line charts – one per month – to plot the daily high, average, and low temperatures. Place each line chart on a separate sheet, and name the sheets November Temps, December Temps, and January Temps, respectively.
18.000
12
Add the chart title November Temperatures to the November chart, December Temperatures to the December chart, and January Temperatures to the January chart.
5.000
13
Save the workbook. Ensure that the worksheets are named correctly and in the following order: November Temps, December Temps, January Temps, Raw Data, and Statistics. Close the workbook and exit Excel. Submit the workbook as directed.
0.000
Total Points
100.000
1
Start Excel. Open exploring_e10_grader_h2_Weather.xlsx and save the workbook as exploring_e10_grader_h2_Weather_LastFirst.
0.000
1
1
111
Start Excel. Open exploring_e10_grader_h2_Weather.xlsx and save the workbook as exploring_e10_grader_h2_Weather_LastFirst.
Start Excel. Open exploring_e10_grader_h2_Weather.xlsx and save the workbook as exploring_e10_grader_h2_Weather_LastFirst.
Start Excel. Open exploring_e10_grader_h2_Weather.xlsx and save the workbook as exploring_e10_grader_h2_Weather_LastFirst. exploring_e10_grader_h2_Weather.xlsx exploring_e10_grader_h2_Weather_LastFirst
0.000
0.000
0.000
2
Open the downloaded file Ch10_H2_WeatherData. Copy the data on Sheet 1 in the range A1:F98 and then paste it on the Raw Data worksheet for this project starting in cell A5.
3.000
2
2
222
Open the downloaded file Ch10_H2_WeatherData. Copy the data on Sheet 1 in the range A1:F98 and then paste it on the Raw Data worksheet for this project starting in cell A5.
Open the downloaded file Ch10_H2_WeatherData. Copy the data on Sheet 1 in the range A1:F98 and then paste it on the Raw Data worksheet for this project starting in cell A5.
Open the downloaded file Ch10_H2_WeatherData. Copy the data on Sheet 1 in the range A1:F98 and then paste it on the Raw Data worksheet for this project starting in cell A5.Ch10_H2_WeatherData
3.000
3.000
3.000
3
Bold the headings on rows 5 and 6 and then apply Align Right to the headings on row 6. Add a bottom border to the range B5:F5. Apply the same formatting to rows 38 and 39 and rows 70 and 71.
5.000
3
3
333
Bold the headings on rows 5 and 6 and then apply Align Right to the headings on row 6. Add a bottom border to the range B5:F5. Apply the same formatting to rows 38 and 39 and rows 70 and 71.
Bold the headings on rows 5 and 6 and then apply Align Right to the headings on row 6. Add a bottom border to the range B5:F5. Apply the same formatting to rows 38 and 39 and rows 70 and 71.
Bold the headings on rows 5 and 6 and then apply Align Right to the headings on row 6. Add a bottom border to the range B5:F5. Apply the same formatting to rows 38 and 39 and rows 70 and 71.
5.000
5.000
5.000
4
Create a nested function in cell G7 that displays sunny for any day that does not have an event observation and repeats events if listed. Nest the function in a function that displays the results in uppercase letters. Copy the function through cell G102, then delete the functions on heading rows between months. Enter Weather in cell G6 and autofit the width of the column.
9.000
4
4
444
Create a nested function in cell G7 that displays sunny for any day that does not have an event observation and repeats events if listed. Nest the function in a function that displays the results in uppercase letters. Copy the function through cell G102, then delete the functions on heading rows between months. Enter Weather in cell G6 and autofit the width of the column.
Create a nested function in cell G7 that displays sunny for any day that does not have an event observation and repeats events if listed. Nest the function in a function that displays the results in uppercase letters. Copy the function through cell G102, then delete the functions on heading rows between months. Enter Weather in cell G6 and autofit the width of the column.
Create a nested function in cell G7 that displays sunny for any day that does not have an event observation and repeats events if listed. Nest the function in a function that displays the results in uppercase letters. Copy the function through cell G102, then delete the functions on heading rows between months. Enter Weather in cell G6 and autofit the width of the column.sunny Weather
9.000
9.000
9.000
5
On the Statistics worksheet, enter functions in the range B4:D4 that will display the number of sunny days for each of the three months using the data in column G from the Raw Data worksheet.
9.000
5
5
555
On the Statistics worksheet, enter functions in the range B4:D4 that will display the number of sunny days for each of the three months using the data in column G from the Raw Data worksheet.
On the Statistics worksheet, enter functions in the range B4:D4 that will display the number of sunny days for each of the three months using the data in column G from the Raw Data worksheet.
On the Statistics worksheet, enter functions in the range B4:D4 that will display the number of sunny days for each of the three months using the data in column G from the Raw Data worksheet.
9.000
9.000
9.000
6
On the Statistics worksheet, enter functions in the range B5:D5 that will display the number of rainy days for each of the three months using the data in column G from the Raw Data worksheet.
9.000
6
6
666
On the Statistics worksheet, enter functions in the range B5:D5 that will display the number of rainy days for each of the three months using the data in column G from the Raw Data worksheet.
On the Statistics worksheet, enter functions in the range B5:D5 that will display the number of rainy days for each of the three months using the data in column G from the Raw Data worksheet.
On the Statistics worksheet, enter functions in the range B5:D5 that will display the number of rainy days for each of the three months using the data in column G from the Raw Data worksheet.
9.000
9.000
9.000
7
On the Statistics worksheet, enter functions in the range B6:D6 that will display the number of foggy days for each of the three months using the data in column G from the Raw Data worksheet.
9.000
7
7
777
On the Statistics worksheet, enter functions in the range B6:D6 that will display the number of foggy days for each of the three months using the data in column G from the Raw Data worksheet.
On the Statistics worksheet, enter functions in the range B6:D6 that will display the number of foggy days for each of the three months using the data in column G from the Raw Data worksheet.
On the Statistics worksheet, enter functions in the range B6:D6 that will display the number of foggy days for each of the three months using the data in column G from the Raw Data worksheet.
9.000
9.000
9.000
8
On the Statistics worksheet, enter functions in the range B7:D7 that will display the number of snowy days for each of the three months using the data in column G from the Raw Data worksheet.
9.000
8
8
888
On the Statistics worksheet, enter functions in the range B7:D7 that will display the number of snowy days for each of the three months using the data in column G from the Raw Data worksheet.
On the Statistics worksheet, enter functions in the range B7:D7 that will display the number of snowy days for each of the three months using the data in column G from the Raw Data worksheet.
On the Statistics worksheet, enter functions in the range B7:D7 that will display the number of snowy days for each of the three months using the data in column G from the Raw Data worksheet.
9.000
9.000
9.000
9
On the Statistics worksheet, enter functions in the range B8:D8 that will display the average high temperatures for each of the three months using the data from the Raw Data worksheet (use the AVERAGE function). Enter similar functions in the range B9:D10.
12.000
9
9
999
On the Statistics worksheet, enter functions in the range B8:D8 that will display the average high temperatures for each of the three months using the data from the Raw Data worksheet (use the AVERAGE function). Enter similar functions in the range B9:D10.
On the Statistics worksheet, enter functions in the range B8:D8 that will display the average high temperatures for each of the three months using the data from the Raw Data worksheet (use the AVERAGE function). Enter similar functions in the range B9:D10.
On the Statistics worksheet, enter functions in the range B8:D8 that will display the average high temperatures for each of the three months using the data from the Raw Data worksheet (use the AVERAGE function). Enter similar functions in the range B9:D10.
12.000
12.000
12.000
10
On the Statistics worksheet, enter functions in the range B11:D11 that will display the total precipitation for each of the three months using the data from the Raw Data worksheet. Enter similar functions in the range B12:D13 using the AVERAGE and MAX functions.
12.000
10
10
101010
On the Statistics worksheet, enter functions in the range B11:D11 that will display the total precipitation for each of the three months using the data from the Raw Data worksheet. Enter similar functions in the range B12:D13 using the AVERAGE and MAX functions.
On the Statistics worksheet, enter functions in the range B11:D11 that will display the total precipitation for each of the three months using the data from the Raw Data worksheet. Enter similar functions in the range B12:D13 using the AVERAGE and MAX functions.
On the Statistics worksheet, enter functions in the range B11:D11 that will display the total precipitation for each of the three months using the data from the Raw Data worksheet. Enter similar functions in the range B12:D13 using the AVERAGE and MAX functions.
12.000
12.000
12.000
11
Use columns B:D from the Raw Data worksheet to create three line charts – one per month – to plot the daily high, average, and low temperatures. Place each line chart on a separate sheet, and name the sheets November Temps, December Temps, and January Temps, respectively.
18.000
11
11
111111
Use columns B:D from the Raw Data worksheet to create three line charts – one per month – to plot the daily high, average, and low temperatures. Place each line chart on a separate sheet, and name the sheets November Temps, December Temps, and January Temps, respectively.
Use columns B:D from the Raw Data worksheet to create three line charts – one per month – to plot the daily high, average, and low temperatures. Place each line chart on a separate sheet, and name the sheets November Temps, December Temps, and January Temps, respectively.
Use columns B:D from the Raw Data worksheet to create three line charts – one per month – to plot the daily high, average, and low temperatures. Place each line chart on a separate sheet, and name the sheets November Temps, December Temps, and January Temps, respectively.November TempsDecember TempsJanuary Temps
18.000
18.000
18.000
12
Add the chart title November Temperatures to the November chart, December Temperatures to the December chart, and January Temperatures to the January chart.
5.000
12
12
121212
Add the chart title November Temperatures to the November chart, December Temperatures to the December chart, and January Temperatures to the January chart.
Add the chart title November Temperatures to the November chart, December Temperatures to the December chart, and January Temperatures to the January chart.
Add the chart title November Temperatures to the November chart, December Temperatures to the December chart, and January Temperatures to the January chart. November Temperatures December Temperatures January Temperatures
5.000
5.000
5.000
13
Save the workbook. Ensure that the worksheets are named correctly and in the following order: November Temps, December Temps, January Temps, Raw Data, and Statistics. Close the workbook and exit Excel. Submit the workbook as directed.
0.000
13
13
131313
Save the workbook. Ensure that the worksheets are named correctly and in the following order: November Temps, December Temps, January Temps, Raw Data, and Statistics. Close the workbook and exit Excel. Submit the workbook as directed.
Save the workbook. Ensure that the worksheets are named correctly and in the following order: November Temps, December Temps, January Temps, Raw Data, and Statistics. Close the workbook and exit Excel. Submit the workbook as directed.
Save the workbook. Ensure that the worksheets are named correctly and in the following order: November Temps, December Temps, January Temps, Raw Data, and Statistics. Close the workbook and exit Excel. Submit the workbook as directed.
0.000
0.000
0.000
Total Points
100.000
Total Points
Total Points
Total PointsTotal PointsTotal Points
100.000
100.000
100.000100.000100.000