Microsoft Forms for test registration

Question

I am a testing coordinator at a public school and am looking for a way to use Microsoft forms to have students register for AP exams. I am planning on using the choice feature with multiple options to have students select what they want to take. However, we need to total the fees for all exams they choose. Is there a way to do this is forms?

Answer 1

Dear Smith,

I’m afraid that Microsoft Forms doesn’t have such a feature to calculate the total of the selected Exam fees.

To better achieve your requirement, you may use a list in SharePoint Online and Excel 2016.

First I suggest you create a list calling Exam List showing the exam names and the corresponding fees as follows.

 

Then create a list calling Choice for Exam for students to select the exams. You can create a look up column calling Choice for Exams to get the data from Exam List for students’ selection via clicking on Settings>List settings>Create column and make the column settings as follows.

 

Now when students select the exams they want, the corresponding fees will be popped up automatically in another look up column Choice for Exams: Fee.

 

For your reference: Create list relationships by using unique and lookup columns

Finally use the Export to Excel option to import the data to Excel 2016. However, the imported data’s format looks incorrectly and is unable to be calculated with a formula. You may need to copy the highlighted data to blank cells>select the copied data>Data>Text to Columns>Next>select Semicolon and Other>Next>Finish> then remove the unwanted rows.

 

After doing that, use the Sum formula to calculate the fees.

 

Moreover, I also suggest you submit your feedback on our Microsoft Forms UserVoice as it is the direct way for our product developers to know users’ requirements for product improvements. If they have some updated information about the feedback, they will post there directly.

Thanks for your understanding.

Cliff