1. The survey content itself refers to the specific items investigated, which is the most important part of the questionnaire.
2. The contents of the questionnaire mainly include the purpose and requirements for filling in the form, matters for the respondent to note, and the time for submitting the form, etc.
3. Numbering Some questionnaires need to be numbered for classification, filing and summary statistics.
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, summation, 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 can be 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.
The market survey form template is a very practical form, and most of the forms are for general purposes. If you happen to need to download the market survey form template, please download it quickly.Weekly meal plan,personal reading scheduleIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works