Tips for using exhibition sign-in sheets
Exhibition sign-in formPreparation of:
There are many ways to sign in. The simpler way is to sign with paper and pen. For example, the teacher in school asks students to sign to count the number of people available.
There are many electronic sign-in methods. Punch-in at work at the company is another form of sign-in to prove a day's work.
QR codes and facial recognition check-ins are also used to record guests.
General tips for exhibition sign-in forms
1: Quick sum and average
If you want to directly know the sum or average of certain numbers, just select those numbers to find out. After selection, the sum, average, and count will be displayed in the bottom status bar.
2: Format brush
The use of Format Painter is very simple. Just click on Format Painter, then select the format you want to copy, and finally select the cells you want to modify. You can modify it in batches.
3: Conditional summation
Use the SUMIF function to calculate the total score of a class:
=SUMIF(D2:D5,F2,C2:C5)
4: SUMIF usage is:
=SUMIF(condition area, specified summation condition, summation area)
In layman’s terms, it is described as:
If the class in the D2:D5 area is equal to the "first class" of the F2 cell, sum the corresponding area of the C2:C5 cell.
Recommended by the editor of Huajun Software Park
The exhibition sign-in form is a very practical form, and most of the forms are for general purposes. If you happen to need to download the Excel form of the exhibition sign-in form, please download it quickly.Construction Project Fire Protection Acceptance Application Form,Motor vehicle license plate application formIt is also a good form. Welcome to click to download and experience it!
it works
it works
it works