Learn Excel Episode 570: Random Quiz

Posted in Companies, Podcasts on July 10, 2008


Learn Excel Episode 570: Random Quiz

Giovanni asks how he can create a random multiple choice question; present a definition and four answers, one of which is right and three are wrong. While this sounds simple, the solution requires a mix of VLOOKUP, RANK, RAND, RANDBETWEEN functions. Episode 570 walks through the solution.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel