Working with Ranking, Likert, Upload file and Net Promoter Score Questions in Microsoft Forms

Jun 16, 2022 | Microsoft 365 Hints and Tips

Microsoft Forms is a form creation app that is part of the Microsoft 365 suite.  There are a total of 8 question types available to use.  Here we explore 4 of the more advanced options available.  This is a follow on from the earlier blog covering the basic form question types of text, date, choice and rating. 

Most question types can have a picture added to the question if you want and a subtitle if a greater explanation of the question or answer is required. 

All the question types below, except upload file, also have the option of making the question required.  This stops the form filler from moving on to the next section until all required questions are completed.  Required questions show a red star beside them to indicate this. 


For ranking questions a list of options is provided and this is put in order of preference by the form filler by dragging them up or down in the list.  Any number of choices can be added to the list.  There are no additional options beyond those already mentioned. 



Likert questions are used where there are several questions that all require a ranking on a particular topic. 

An overarching question or topic is added at the top.  The options to select from are added as headers to the columns.  The number of columns and the headings used can be amended to those required.  The questions or statements are added on the left hand side. 

Note that the boxes below About your training are suggestions that Microsoft Teams provides to enable certain options to be added more quickly and to save typing. 


Upload File 

Upload File allows the person filling in the form to add a file as the response.  This could be an essay or dissertation or even a video or audio response where the other questions types do not give enough flexibility.  The file size can be a maximum of 10MB, 100MB or 1GB in size and can be Word, Excel, PowerPoint, PDF, Image, Audio or Video file types.  A limit to the number of files that can be uploaded can also be set.  This can range from 1 to 10. 

A new folder is created in OneDrive. Files uploaded by responders will be captured in this folder. The responder names and file details will automatically be recorded in OneDrive too. 

Upload File

Net Promoter Score 

The Net Promoter Score is a very specific type of question.  It is used to find out how likely someone is to recommend you to others.  The scale is always 1 to 10 and the descriptions for the extremes at 1 and10 can be labelled. 

Timescale in Outlook

Further Reading

If you’ve enjoyed reading about the more advanced question types in Microsoft Forms, there’s some other blogs below that you might find useful:

Want to learn more about other Microsoft 365 features? Then email to discuss how I can help or have a look at the Courses I run.