How does the excel development tool design the questionnaire

This article shows you how the excel development tool designs the questionnaire, which is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Today, I would like to share with you the use of excel development tools to design questionnaires!

Although the current online questionnaire design and distribution platform has developed very mature (golden data, questionnaire stars), from the question design, channel distribution, simple preprocessing, preliminary analysis and other aspects have many advantages, but excel development tools can also be competent for many of the work, especially in the question design, the form controls in the development tools can play a very good effect!

It mainly involves tools:

Development tools-check box

Development tools-option buttons

The design of two types of questions:

Radio

Multiple selection

Single-choice topic design:

There is only one correct option for a single item, four option buttons need to be designed, and only one of the four buttons can be selected at a time.

Development tool-- insert-- option button

After inserting the option button, clearly drop the internal text, and then select the right-click to open the formatting menu of the control, and enter the cell link position into the adjacent cell to the right of the option button.

At the same time, hold down the Ctrl+ shift key and drag the secondary control vertically and downward with the mouse. Copy one on the right side of each option.

Clicking on the corresponding option at this point will display the corresponding option serial number on the right.

Finally, group the four option buttons (hold down the Ctrl key, click the four spaces one by one with the mouse, and select the group from the top menu-format-combination to facilitate subsequent movement. )

Multiple choice topics:

Insert the development tool-check box to the right of the serial number of multiple-choice questions, clearly check the text in the check box, drag and drop it using the same method as above, there should be a check box after each multiple-choice question, and open the formatting menu of each check box control. point the cell link to the adjacent cell range on the right side of each space.

Now try to click the button, if normal, you can show the click effect, select the display true, and click again to cancel the display false.

The above is how the excel development tool designs the questionnaire. Have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.