97 98 |We have used the RANK function to randomize questions and alternative answers to questions in the Workbooks. 99 The RAND function in the gray cells automatically generates random numbers. 100 Write a formula using the RANK function that ranks in the green cells the random numbers in the gray shaded cells in descending order. 101) Use the 'S' to be able to copy the formula down. 102 103 0.9134 104 0.2408 105 0.0209 106 0.4380 107 0.9976 108 109 Notice that every time you recalculate the Workbook (fn9 key) Excel regenerates the random numbers and the ranking sequence changes. 110 - ERA A