Excel,

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.

H 5 exploring e10 grader h2 Weather LastFirst.xlsx Excel Insert Draw Page Layout Formulas Data Review view Power Pivot Q Tell me what you want to do File Home Cut E wrap Text A A Calib General Copy BIU A E Merge & Center 4.0.00 Conditional Format as Cel nsert Delete For 00 +0 Paste Format Painter Formatting Table Styles Clipboard Alignment Number Cells es G5 B 5 2012 Temp. F) Precip. (in) Events low sum Weather 6 Nov high avg 57 51 45 0.03 Rain 52 49 45 9 3 53 48 42 10 4 53 46 38 11 5 45 39 33 12 6 41 36 31 13 7 45 39 32 0.33 Rain, Snow 14 8 40 36 32 0.21 Rain, snow 15 9 53 46 38 10 55 48 40 11 61 51 40 18 12 66 57 47 19 13 63 52 40 0.29 Rain 20 14 45 41 36 21 15 41 38 34 22 16 45 40 35 23 17 47 42 36 24 18 47 40 33 0 19 Raw Data Statistics Ready H 5 exploring e10 grader h2 Weather LastFirst.xlsx Excel Insert Draw Page Layout Formulas Data Review view Power Pivot Q Tell me what you want to do File Home Cut E wrap Text A A Calib General Copy BIU A E Merge & Center 4.0.00 Conditional Format as Cel nsert Delete For 00 +0 Paste Format Painter Formatting Table Styles Clipboard Alignment Number Cells es G5 B 5 2012 Temp. F) Precip. (in) Events low sum Weather 6 Nov high avg 57 51 45 0.03 Rain 52 49 45 9 3 53 48 42 10 4 53 46 38 11 5 45 39 33 12 6 41 36 31 13 7 45 39 32 0.33 Rain, Snow 14 8 40 36 32 0.21 Rain, snow 15 9 53 46 38 10 55 48 40 11 61 51 40 18 12 66 57 47 19 13 63 52 40 0.29 Rain 20 14 45 41 36 21 15 41 38 34 22 16 45 40 35 23 17 47 42 36 24 18 47 40 33 0 19 Raw Data Statistics Ready