Standards for student information registration form template:
1. Name, gender, date of birth, start and end years of study;
2. Forms that are saved centrally on an individual basis for reference.
General Tips for Student Information Registration Form Template 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, then sum the area corresponding to the C2:C5 cell.
Recommended by the editor of Huajun Software Park
Student information registration form templateIt is a very practical form, and most of the forms to be filled in are for general purposes. If you happen to need to download the student information registration form template, please download it quickly. also,Visitor registration form,Student information registration formIt is also a good form template. Welcome to click to download and experience it!
it works
it works
it works