When to Use Radio Buttons as Answer Types in Excel

Overview

When a questionnaire asks that you respond to a question which has choices in a column, use a radio button as the answer type. Users can choose this answer type while configuring the Excel file.

Question A has answer choices of Yes, No, or N/A and one needs to be selected as a response.

Using Radio Buttons as Answer Types in Excel

1. Select the Answer column and map it with Answer from the left options menu.
   
2. Select Radio from the Answer Type drop-down.
   
3. Click Add Answer Type and add answer types.
   
4. Import the file, respond to the question, and export the response.
   
   
   The exported file is displayed: