Introduction to thermometer table
During the epidemic, it is particularly important to monitor body temperature in public places. The thermometer form is a recording form developed for this need.
List of contents of thermometer: 1. Open the EXCEL worksheet,
2. Select the tabulation area and click [Insert] → [Table].
3. The system pops up [Create Table], click [OK] to start creating.
4. Enter the form content information: header, specific information, including: name, detection time, etc.
5. Enter the measured temperature, once in the morning and once in the afternoon each day.
6. Automatically count the number of people whose body temperature exceeds the standard, using the COUNTIF function.
7. Use the filling sequence method to fill to the right to calculate the number of people who exceed the standard on other days.
General Tips for Thermometers
1. Modify the font
First, let’s start with input and adjust the font. You can find the font tool box at the beginning of the toolbar, where you can quickly change the font type, size, color, etc.
2. Insert and delete cells
In the cell tool box, you can quickly insert or delete cells with one click. For example, sometimes when typing, a row of data is missed. Here, click "Insert Row" in "Insert Cell" under "Rows and Columns" and it will be OK.
3. Fill merged cells
As long as the data range is selected, unmerge the cells first. Then press Ctrl+G to locate the null value. Then enter the equal sign, press the up arrow of the direction key, and finally press Ctrl+Enter.
Recommended by the editor of Huajun Software Park
ThermometerIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Year-end fiscal appropriation balance table,Score Assessment Registration FormDownload to get the source file, which can be edited, modified and replaced. To download the thermometer, go to Huajun Software.
Useful
Useful
Useful