|
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_Weather-Data. 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
|
