Question: 1. Professor 'Know-it-all' wants to implement another system to call upon a group of students at random. She has created 4 Group 1: Students 1-5
1. Professor 'Know-it-all' wants to implement another system to call upon a group of students at random. She has created 4 Group 1: Students 1-5 Group 2: Students 6-10 Group 3: Students 11-15 Group 4: Students 16-20 Her VLOOKUP function does not correctly return a random group. What is wrong with her function below? The lookup_value parameter should be "RANDBETWEEN (1,16) ". The table_array parameter should be "A3:B6". The col_index_num parameter should be " 1 ". The [range_lookup] parameter should be "TRUE". 2. You inform Professor K, that a much simpler solution to her problem above would be to just use the RANDBETWEEN function to randomly return a value of 1,2,3, or 4 directly. Which of the following would correctly implement this solution? =RANDBETWEEN(1,4) =RANDBETWEEN (1,16) =RANDBETWEEN (1,20) =RANDBETWEEN(0,5)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
