Excel online allows you to create survey forms. The free tool produces a quiz that can be shared with friends and business contacts via a link. Excel surveys make it possible to add multiple questions that receive different answer patterns. Therefore, users can define questions with yes or no style answers, multiple choice and text answers. The resource is suitable for students who need to conduct academic research or for businesses and professionals who want to receive feedback from their clients.
Excel formulas: the 68 most important functions of the program
To access Excel Online, users must use access credentials from a Microsoft account. Documents created on the platform are saved online and can be accessed at any time. For searches, data with results are displayed by clicking on the document in Excel Online files. Check out in the following tutorial how to create and track search results in Excel Online.
Tutorial shows how to create a survey form by Excel Online Photo: Divulgao / Microsoft
Want to buy a cell phone, TV and other discounted products? Meet the Compare TechTudo
How to create a survey form
Step 1. Access Excel online enter your email using to access Microsoft services;
When to log in to Excel online with a Microsoft account Photo: Reproduo / Marvin Costa
Step 2. Enter your Microsoft password and click the "Sign In" button;
When to log in to a Microsoft Excel account online Photo: Reproduo / Marvin Costa
Step 3. Open a blank document using the "New Blank Workbook" option;
When to open a blank document in Excel online to create a survey Photo: Reproduction / Marvin Costa
Step 4. Select the temporary document title at the top of the screen and enter a name for the search;
By naming an Excel document to be set to search Photo: Reproduction / Marvin Costa
Step 5. In the "Insert" tab, click on search and then on the "New Search" option;
By creating an Excel survey online Photo: Reproduction / Marvin Costa
Step 6. Retype a search name instead of the phrase at the top of the screen. Then click on the gear icon next to the "Type your first question here" description, as shown in the image below;
When to create a question in an Excel Online survey Photo: Reproduction / Marvin Costa
Step 7. In the "Edit Question" tab, type your question, add a subtitle and define which type of answer you want to add. You can choose "Text", "Paragraph Text", "Number", "Date", "Time", "Yes / No" or "Option". For this example, we will use "Opo";
Actions to edit a question in a new survey created in Excel Online Photo: Reproduction / Marvin Costa
Step 8. Under "Default Answer", type three answer options. To proceed, click "Done";
When to set answer options for a question in a survey form created in Excel Online Photo: Reproduction / Marvin Costa
Step 9. Keep adding new questions until you finish your quiz. To do this, click on the option "Add a new Question";
When to add new questions in a survey form created in Excel Online Photo: Reproduction / Marvin Costa
Step 10. When finished the search, click on the option "Save and Display";
By saving and displaying a survey created in Excel Online Photo: Reproduction / Marvin Costa
Step 11. Review your search data and click the "Share Search" button located at the bottom of the screen;
When to view the sharing link for a survey created in Excel Online Photo: Reproduo / Marvin Costa
Step 12. Just copy the generated link and send the search to person via email, social networks and messengers.
Share link to Excel Online survey Photo: Reproduo / Marvin Costa
Tracking Search Results
Step 1. Go to the Excel Online homepage and click on the search name in the list of saved documents;
By opening results from a survey created in Excel Online Photo: Reproduction / Marvin Costa
Step 2. You can check the answers of each person who received the questionnaire.
When viewing Excel Online survey results Photo: Reproduction / Marvin Costa
Ready. Take advantage of the tip to conduct academic research or customer activities using Excel Online.
How to delete all blank lines in Excel at once