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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!