Designing of a questionnaire in xls form

How do you design this kind of questions in xls form?

Question: How would you rate your knowledge and use of:
(Rate: 1 = No knowledge, 5 = Expert knowledge)

|Topic* *|1|2|3|4|5|
|Sphere Standards | ☐ | ☐ | ☐ | ☐ | ☐ |
|Core Humanitarian Standard (CHS) | ☐ | ☐ | ☐ | ☐ | ☐ |
|IASC gender and inclusion guidelines | ☐ | ☐ | ☐ | ☐ | ☐ |
|Accountability to Affected Persons | ☐ | ☐| ☐ | ☐ | ☐ |

Welcome to the community, @lm23! You should be able to do it by following this support article Rating vs Ranking Question Types. This community post discussed previously should also help you design a rating question by using an XLSForm:

1 Like