+ Reply to Thread
Results 1 to 3 of 3

Is possible to shuffle answers in multiple choice test in EXCEL?

  1. #1
    Registered User
    Join Date
    04-17-2020
    Location
    Slovakia
    MS-Off Ver
    2019
    Posts
    1

    Is possible to shuffle answers in multiple choice test in EXCEL?

    I have a lot of questions and I need to quickly shuffle answers in Multiple Choice Test. (1 question has 4 answers, A,B,C, or D)

    Is possible to do that by using VBA or with some formula?

    Thanks for the help.
    Attached Files Attached Files
    Last edited by t0m1noo; 04-17-2020 at 11:25 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,193

    Re: Is possible to shuffle answers in multiple choice test in EXCEL?

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,193

    Re: Is possible to shuffle answers in multiple choice test in EXCEL?

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    As you are new I will add the link for you.Please read forum rules. Thanks

    https://www.mrexcel.com/board/thread...excel.1131079/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help, I need a logical test for multiple ranges, returing various text answers, Excel 2010
    By Omegaman2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-24-2018, 05:12 AM
  2. [SOLVED] Shuffle four answers of one question with a condition and loop it
    By freeofcost in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-05-2014, 05:05 PM
  3. [SOLVED] Tallying a multiple choice test
    By Gippy222 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-06-2014, 03:45 PM
  4. Replies: 3
    Last Post: 12-16-2013, 05:16 AM
  5. Turning multiple choice answers into graph
    By aka_khan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-07-2008, 07:27 AM
  6. Grading a multiple choice test in Excel
    By mburch in forum Excel General
    Replies: 2
    Last Post: 06-10-2008, 02:30 PM
  7. [SOLVED] help - create a multiple choice test
    By robynhaga@gmail.com in forum Excel General
    Replies: 2
    Last Post: 07-17-2006, 07:35 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1