MICROSOFT EXCEL SPREADSHEET FOR FREE

The Text option allows you to create long or short answer text questions.

The Choice option allows you to define a list of possible answers for the user to select one or more answers from.

There are 7 types of questions available. This will show the list of available questions choices, but note that some are hidden in a menu accessible by clicking on the Ellipses. The only difference between them is you can assign point values and correct answers to quiz questions in order to calculate a quiz score.Īll the questions can be accessed by clicking on the Add new button. They both allow you to create the same type of questions. Microsoft Forms currently has two types of forms. If you don’t land on the home page, you can always get there from any screen using the button in the top left corner of the screen that’s labelled Forms.įrom the home screen, click on either New Form or New Quiz. Creating a Form from the WebsiteĪfter you sign into you should be taken to the home page where you can create new forms and quizzes. This will create a form that’s linked to the current workbook. Go to the Insert tab ➜ click on the Forms button ➜ select New Form from the menu. If you’re working with Excel Online, you can also create forms. This also prompts you for a new workbook name where your form submissions will be saved. Navigate to the folder where you want to store your form results ➜ click on New ➜ select Forms for Excel. The same thing can be done to create a form if you have an Office 365 business account with SharePoint online.

This workbook will be saved in your chosen folder and will be where all the form submissions will be saved. You will then be asked to name the workbook associated with your form. You can create forms inside OneDrive personal or business. There are a couple different ways to create a form or quiz with Microsoft Forms.

MICROSOFT EXCEL SPREADSHEET FOR FREE

If you don’t have an Office account, then you can still sign up to use forms for free here by creating a Microsoft account. If you’re signed up with Office 365, then you already have Microsoft Forms and it can either be accessed from OneDrive, SharePoint, Excel Online or the Forms website. Let’s take a look! Sign Up For Microsoft Forms I also suggested them to a friend who was looking for a simple data entry solution. I’m using these using these forms in my courses to get student feedback and reviews so I can improve my teaching. You could use them to get customer feedback, collect reviews and testimonials or even use them as data entry forms. There is a wide variety of potential uses for these. It’s a great new tool from Microsoft that allows you to quickly and easily create surveys, quizzes and polls.

Microsoft excel spreadsheet