Weekly weather statistics electronic version

The specific steps to randomly generate weather in excel table are as follows:
1. First make a weather record table and merge A1: Q1 and write a title - select A2: Q9 - click start - set to all borders, that is, draw a table with 17 columns and 8 rows.
2. Fill in the weather-related content—pre ss the ctrl key and select B3:Q3 and B7:Q7 at the same time—click data—data verification—data verification.
3. Click Settings - Select: Series - Enter the source: Sunny, Cloudy, Rainy (note that they are separated by English commas, you can add more weather content) - Click OK.
4. Set the border by merging, draw a table with 4 rows and 4 columns - Insert - Shape - Straight line, make a diagonal header, and the title of the statistics is: weather, days and months.
5. Select cell C13 and enter the formula: =COUNTIF($B$3:$Q$7,C12) to count the number of cloudy days in May.
6. Finally, select cell C13 - move the mouse to the lower right corner, and when a black cross appears, drag to the right to fill in the formula. For manual drawing, just click on the picture above to complete the record table and statistical table, and then fill in the form manually to complete the statistics

1. Create an Excel table named "Weather Condition Record Table" and merge its header cell A1.
2. Select the area from A2 to Q9, click the "Border" button under the "Start" tab, and set the border lines of all cells.
3. Select the areas B3 to Q3 and B7 to Q7 at the same time, and click the "Data Verification" option under the "Data" tab.
4. In the pop-up data verification dialog box, select the "Settings" tab, then select "List", enter the weather conditions (such as sunny, cloudy, rainy, etc.) in the "Source" box, and Click OK.
5. Make a table with 4 rows and 4 columns, and merge the cells to create a statistical header. Use the "Shape" function under the "Insert" tab to add a slash header as a table decoration.
6. Enter the formula in cell C13: =COUNTIF($B$3:$Q$7,C12) to count the number of cloudy days in May.
7. Drag and fill the formula in cell C13 to other cells to automatically calculate the weather conditions for each month.
8. After completing the form, you can manually fill in the record form and statistics form, and then perform manual statistics.

(1) The total number of sunny, cloudy, rainy and snowy days is 3013953 (2) In this month, cloudy weather often occurs. (3) During this month, snowy weather occasionally occurs. (4) From the above statistical table, I know that the weather is changeable, with fewer sunny days and more rainy days.