basic form of questionnaire

basic form of questionnaireResearchers use this tool to accurately and specifically measure the project process, and apply sociological statistical methods for quantitative description and analysis to obtain the required survey data. The free download of the basic form of the questionnaire is provided by Huajun Software Park. The source file is in xlsx format. You can edit and modify the content style by downloading the source file. For more free downloads of the basic form of the questionnaire, please pay attention to Huajun Software Park.

Introduction to basic forms of questionnaires       basic form of questionnaireContent enumeration:
​ ​ 1. 1. Open excel, click to select a cell, and click "Merge and Center" in the "Home" column.
2. Input the purpose of the survey into the form: introduce the purpose and significance of the survey, the overview and development of the unit or department, requirements, etc.
3. Single column title and serial number.
4. Investigation process: including time, content, location, etc., and then conduct quality system investigation item by item in the order of arrangement.

Basic common techniques for questionnaires

   1. Find duplicate content formula: =IF(COUNTIF(A:A,A2)>1, "Duplicate", "").
2. Use the birth year and month to calculate the age formula: =TRUNC((DAYS360(H6, "2009/8/30", FALSE))/360,0).
3. Calculation formula from the birth year and month of the entered 18-digit ID number:
=CONCATENATE(MID(E2,7,4),"/",MID(E2,11,2),"/",MID(E2,13,2)).
4. To let the system automatically extract the gender from the entered ID number, you can enter the following formula:
=IF(LEN(C2)=15, IF(MOD(MID(C2,15,1),2)+1."Male","Female),IF(MOD(MID(C2,17,1),2)=1,"Male","Female"))"C2" in the formula represents the cell where the ID number is entered.

Recommended by the editor of Huajun Software Park