![]() Construct Your Survey: Select “Add Question” to start building your survey and pick between the Choice, Text, Rating, or Date options you can add as many questions as you’d like and amend the order of your questions by clicking the up or down arrows to the right of each question.Open the Program: Sign in to Office 365, click “New” and then “Forms for Excel,” enter your survey name and select “Create”.The steps to building a survey are quite simple: (Don’t worry, no one can see the results unless they’ve been given access.) This is a great option for internal and customer feedback, and will save all responses within an Excel workbook. ![]() In OneDrive, as part of the Office 365 package, it’s possible to build a survey that you can then see and share online. If you’d like to build a survey form, but don’t want to go through the hassle of using a converting tool, let Excel do all the hard work for you. View Your Online Form: Once the conversion process is complete, SpreadsheetConverter will automatically open the HTML web page containing your form for you to visualize.Convert the Spreadsheet Into an Online Form: To complete the process, select “Convert” from the SpreadsheetConverter menu.To add this option, simply choose a cell with the question where you’d like there to be a dropdown list of answers and select “Dropdown List” from the SpreadsheetConverter menu, and then follow the onscreen instructions Develop a Dropdown List Menu (Optional): Dropdown lists offer the user pre-set answer choices for their convenience.Identify the User Data Entry Cells: To tell SpreadsheetConverter which cells should be left blank for user input, pick a relevant cell and choose “Mark Input Cell” from the SpreadsheetConverter menu.For instance, type a label in a cell and then leave an empty cell next to it for the user to enter their data this could be “First Name” as A1 and then a blank cell as A2 to leave space for the user’s response ![]()
0 Comments
Leave a Reply. |