Create a survey with a customised report

KatieLDalton

New Member
Joined
Jan 3, 2020
Messages
1
Office Version
365
Platform
Windows
Hi - I need help!

I am trying to create a survey with multiple choice answers, after which completed, will give the respondent a score and report based on their answers. I have tried to do this in Microsoft forms with the questionnaire feature, but I need to weight the different answers within a question and this feature does not exist. So I have resorted to using a normal excel spreadsheet which lets me do the formulas I want to weight the answers and create the report. My problem is - how do I receive everyone’s responses if I am just creating the survey in excel? I want to create an aggregated view of all responses as well as them receiving their individual report.

Any help is greatly appreciated - it’s driving me crazy!

Thanks
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Watch MrExcel Video

Forum statistics

Threads
1,099,568
Messages
5,469,457
Members
406,653
Latest member
CBeeker

This Week's Hot Topics

Top