When to Use Drop-Downs as Answer Types in Excel

Overview

If you respond to a question which has choices, and respond only in a column or cells which have a predefined drop-down fields, select drop-down as the answer type.

There are two options for the drop-down answer type:

• Normal:
  
• Predefined: The application automatically identifies these.
  

Using Normal Drop-Downs

1. Select the answer column and map it with Answer from the left menu options.
   
2. Click Add Options.
   
3. Enter values in the Value in File and Value in UI fields.
   Note: Values in the UI must be unique; same values are not accepted.
4. Click Add Options to add more values; then click Save.
   
5. The Add Answer Type pop-up displays. Enter the answer types.
   
6. Click Select and choose values from the drop-down.
   
7. Answer the questions and export the responses in the source. You can find the responses in the exact column.
   

Using Predefined Drop-Downs

1. Click the auto-identify drop-down icon; then select the answer column and map it with Answer from the left options menu.
   
2. Click Auto-Identify Drop-Downs to view all fields.
   
3. Select the checkbox to change the answer header (if required) and then click Apply.
   
4. Answer the questions and export the response in the source file.
   
   
   The exported file displays as shown below: