Home Blog Archive MS Office Excel: questionnaire to evaluate - how to

Excel: questionnaire to evaluate - how to

  • Oct 29, 2025
  • 723
  • 0

A questionnaire you can evaluate with MS Office Excel is relatively easy. How this works exactly, we show you in this practical tip.

Evaluation: questionnaire results in Excel

The questionnaire to evaluate, you must import the results in Excel. There are several possibilities. We will show you an.
  1. You can open in MS Office Excel, a new document.
  2. You can now create a kind of table in which you list the results. Write to you, for example, in a column the participants (Person1, Person2, Person3, ...) and in a row, the possible answers (answer1, Antwort2, Antwort3, ...). In order to make the table clearer, you can create a format with a right-click - > "cells" of the table.
  3. Now select for each Person the answer with a "1". Hilarious answers, you can simply leave blank.
  4. By repeating these steps for all of the questions on the questionnaire.
Questionnaire to evaluate visually

YOU MAY ALSO LIKE

0 COMMENTS

LEAVE A COMMENT

Human?
1 + 3 =