1. Home
  2. Project Management
  3. Import and Export

When to Use Multi-Column Radio Buttons as Answer Types in Excel

Last edited:

Overview

When the questionnaire asks that you select one answer in a radio format from multiple columns, use a multi-column radio button as the answer type. Users can choose the multi-column radio button answer type while configuring the Excel file.

mceclip0.png

Question A has three responses in columns B, C, and D, all as possible options in different columns, and you are being asked to respond in one of them to fulfill the question requirements.

When to Use Multi-Column Radio Buttons as Answer Types in Excel

  1. Select the Answer column and map it with Answer from the left options.
    mceclip1.png
  2. Select Multi-Column Radio from the Select Answer Type drop-down.
    mceclip2.png
  3. Click Add Options to add values.
    mceclip3.png
  4. The Add Answer Type pop-up displays. Enter the answer types.
    mceclip4.png
  5. Answer the questions and export the responses.
    mceclip5.png

    The exported file displays:

    mceclip6.png
Was this article helpful?
3 out of 3 found this helpful
Top