To add more questions, click the Add Item button at the top left of the window. To enter another question, hover your mouse over Sample Question 2 and click the pencil icon. If you’re requesting numerical data, select Text. In the Question Type dropdown field, select the type of answer you’re looking for-multiple choice, plain text, or whatever the case may be. You can provide explanatory text in the Help Text field if you wish (that text will appear above the question on the form). In the window that appears, type your first question into the Question Title field. To get started, open a new spreadsheet and click on the Form menu then choose Create a Form. Forms provide a quick way to satisfy this need, offering simple multiple-question interfaces that you can e-mail to people or include on Web pages. Sometimes you need to gather data from co-workers, customers, or other individuals. For example, to color-code all cells containing the name “Melvin,” select Text Contains from the dropdown list, and enter melvin into the text field. Then enter the filtering criterion that you want to use into the text field alongside. From the dropdown list in the dialog box, choose the criterion that you want the color coding to filter by-the text of the cell, say, or the date.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |