How to make a statistical table, how to make a statistical table

Presentation Tools Raw Materials: Computer, Excel2003 Step 1: First, we open the data that needs to be counted in Excel.

Step 2: Press the Ctrl key and select the data to be made into a chart.

Step 3: Click "Insert" on the upper toolbar and select, "Chart".

Step 4: Select the type of chart you want according to your needs.

Step 5: After selection, click "OK" to complete the chart.

1. First press Ctrl+A to select all**, then move the mouse to the number of rows and column lines, and drag to set the row width and column width of ** to make its **spacing larger.

2. Then center all the content in **, set the font size to 10, and change the font to [Microsoft Yahei].

3. Then fill the content of the header with a color, the filling color is [blue], the text color is set to [white], and [bold] is displayed.

4. Then fill the first line of ** content below with the color [talk blue], then select the second and third lines of content, select the format painter, and unify all the following ** content. and set the text color to Blue.

5. Finally, you can select the total sales of the individual on the right, and add [Data Bar] in [Condition**].

6. The statistical table is ready.

1.With electronics, you can make statistics, and use the filtering and advanced filtering functions in the tool to filter the content that needs to be filtered according to your requirements. 2.

Right-click in the bottom left corner of Excle's Electronics, add a chart, select a chart according to your requirements, and create another or insert it into an existing one.

If you can't say it clearly, just send you a statistical table, and you can refer to it yourself.

Data statistics** mainly includes the processing needs of other data such as data summary and filtering, so how to make a data statistics table? Here's how to do it.

1. First open **, enter the basic data and check**.

2. Use CTRL+T to create a super table, and you can add a filter button to the title bar, and filter according to your needs.

3. Next, click on Summary Rows.

4. Click the drop-down icon in the summary row and select the corresponding formula, such as sum.

5. Calculate the degree of completion according to the needs of the data.

6. Use Ctrl+ to bring up the cell format page and adjust the number format to percentages.

7. Then insert the data bar under Conditional Formatting.

8. In this way, the progress is displayed.

Answer: Pro, you are directly doing people counting**, right? If you only do the statistics of the members of the parent committee, it is relatively simple, make it directly, and enter the names of the members of the parent committee.

Question: I'm a member of the parent committee I have to count all kinds of data in the primary school class in the future** The mother of a first-time student I don't know what kind of data I will encounter when I come to count You are still working hard to reply so late.

I don't know what to count when I ask a question, I want to count those items and list those **, I haven't done this work, that's why I asked.

Question: If I could, I wouldn't ask here.

1.Open a blank document, select ** in the menu bar, and execute the "Insert"-"**" command;

2.In the dialog box that opens, enter the number of rows and columns. Set it according to the actual needs, and click the OK button after setting;

3.A ** is inserted into the area, and the corresponding content can be entered in the cell;

4.Select a row, right-click, and in the pop-up menu, you can operate on the row, re-insert a row or delete a row. In the same way, if you operate on columns, you can delete and add columns;

5.Select from the menu that pops up in Step 4"Properties" can be set for color, border, shading, height, etc.

Electronic statistical table: use EXCE or WPS to do, method: create a new workbook, fill in the statistical items, and enter the content to be counted. If you want to calculate with a formula; If you want to chart, select the region insert icon and select a style.

Open the file where you want to do the calculations. For example, I'm going to calculate the length of this pipe.

Click on cell G5. Enter an equal sign. Click on Formula --Insert Function --- find Evaluate

Function. After the function is found, the following active box will automatically pop up. Click on the location shown in the image below.

Select the corresponding formula position. ok！！

Tools Raw materials.

Computer excel2003

Method steps.

1. First of all, open the data that needs to be counted in Excel.

2. Press the CTRL key to select the data to be made into a chart.

3. Click "Insert" in the upper toolbar and select, "Chart".

4. Select the type of chart you want according to your needs.

5. After selection, click "OK" to complete the chart.

Problems that need to be paid attention to when making statistical tables:

First, the structure of the statistical table should be reasonably arranged, such as the position of row headings, column headings, and numerical data should be reasonably arranged.

Of course, due to the different issues emphasized, the row headings and column headings can be interchanged, but the horizontal and vertical lengths of the statistical table should be appropriately proportioned, and the ** form that is too high or too long should be avoided.

2. The header of the table should generally include the table number, the general title, and the unit of the data in the table.

The general title should concisely and clearly summarize the content of the statistical table, and generally need to indicate the time (when), place (where) and what kind of data (what) of the statistical data, that is, the content of the title should meet the requirements of 3W.

3. If all the data in the table are in the same unit of measurement, they can be placed in the upper right corner of the table, and if the units of measurement of each indicator are different, they should be placed after each indicator or listed in a separate column.

Fourth, the upper and lower lines in the table are generally thick lines, and the other lines in the middle should be thin lines, so that people look clear and eye-catching.

In general, the left and right sides of the table are not sealed, and the column headings are generally separated by vertical lines, while the row headings are usually separated by horizontal lines. In short, try to use as few horizontal and vertical lines as possible in the table. The data in the table is generally right-aligned, and when there is a decimal point, it should be aligned to a decimal point, and the number of decimal places should be uniform.

For the ** unit without numbers, it is generally indicated by "", and there should be no blank cells in the statistical table filled in the first line.

5. When using the statistical table, if necessary, you can add notes at the bottom of the table, and pay special attention to the information** to show respect for the fruits of others' labor and facilitate the reader's reference and use.

Introduction to Statistical Tables:

The original data obtained from the statistical survey are sorted out to obtain data that explain social phenomena and their development process, and these data are arranged in a certain order to form a "statistical table". Statistical tables are one of the most commonly used to show the results of numerical data collation**. A statistical table is a form of statistical data drawn by vertical and horizontal crossed lines.

Tools Raw materials. Lenovo Y7000P, Windows10, Excel20221, select the data content.

Open the excel software to enter the home page, and select the data that needs to be made into ** in the page.

2. Click ** function.

Then click Insert at the top of the page, and then click Option Settings in the Insert panel.

3. Click OK to make.

Then click OK in the pop-up page, and you can make the data into a ** style.

Production rules: 1. The statistical table is generally a horizontal rectangle, with closed and thick lines at the upper and lower ends, and open at the left and right ends.

2. When there are many columns in the statistical table, they should be numbered, and the general subject part should be divided into A, B, C; The object parts are numbered in the order of (1), (2), etc.

3. The general title of the statistical table should be concise and concise, in line with the content of the table.

4. The positions of the subject and object are interchangeable. The order of the columns should be arranged in a natural order such as chronological order, quantity size, spatial position, etc. 5. The unit of measurement is generally written in the upper right of the table or below the title of the general column.

7. Fill in the digital information without leaving a blank, that is, draw a diagonal line at the space. After the statistical form is reviewed, the tabulator and the reporting unit shall sign and seal to show responsibility.