Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Facilities Managers Reference Management Planning Building Audits Estimating

Authors: Harvey H. Kaiser

1st Edition

0876291426, 978-0876291429

More Books

Students also viewed these Accounting questions

Question

A man weighs 0.80 kN on Earth. What is his mass in kilograms?

Answered: 1 week ago

Question

11.6 Prediction

Answered: 1 week ago

Question

48. Verify the formula given for the Pi of the M/M/k.

Answered: 1 week ago