Home
Subjects
Textbook solutions
Create
Study sets, textbooks, questions
Log in
Sign up
Upgrade to remove ads
Only $35.99/year
Quiz 10
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (10)
Which one of the following options about Lookup is true?
Statement 1: Given a value in a row, it can retrieve the corresponding value from another row but under the same column.
Statement 2: Given a value in a column, it can retrieve the corresponding value from another column but in the same row.
- Statement 1 is true, and statement 2 is false.
- Both statements are true.
- Both statement 1 and statement 2 are false.
- Statement 1 is false, and statement 2 is true.
Both statements are true.
Which one of the following options about the nested function MATCH and INDEX is accurate?
Statement 1: The INDEX function can return a value given row and column positions.
Statement 2: MATCH function can return a position given row and column positions.
- Statement 1 is true, and statement 2 is false.
- Statement 1 is false, and statement 2 is true.
- Both statements 1 and statement 2 are true.
- Both statements 1 and statement 2 are false.
Statement 1 is true, and statement 2 is false.
Which one of the following options about the function INDEX is accurate?
Statement 1: INDEX function retrieves value given its position in an array.
Statement 2: INDEX function retrieves position given the value in an array.
- Statement 1 is true, and statement 2 is false.
- Both statement 1 and statement 2 are false.
- Both statement 1 and statement 2 are true.
- Statement 1 is false, and statement 2 is true.
Statement 1 is true, and statement 2 is false.
Which one of the following options about the MATCH & INDEX function "=INDEX(D3:D10,MATCH(33,B3:B10,0))" is accurate?
Statement 1: MATCH feeds the row position for the value 33 in column array B3:B10 to INDEX, which in turn uses it to retrieve a value in the column Array D3:D10
Statement 2: INDEX feeds a value in the column array D3:D10 to MATCH, which in turn uses it to retrieve row position for 33 in column array B3:B10.
- Statement 1 is false, and statement 2 is true.
- Statement 1 is true, and statement 2 is false.
- Both statement 1 and statement 2 are true.
- Both statement 1 and statement 2 are false.
Statement 1 is true, and statement 2 is false.
Which one of the following options about the nested function MATCH & INDEX is true?
Statement 1: Given a value, MATCH finds its position and feeds it to INDEX to retrieve the corresponding value.
Statement 2: Given a position, MATCH finds its value and feeds it to INDEX to retrieve the corresponding position.
- Both statement 1 and statement 2 are false.
- Both statement 1 and statement 2 are true.
- Statement 1 is false, and statement 2 is true.
- Statement 1 is true, and statement 2 is false.
Statement 1 is true, and statement 2 is false.
Which one of the following options about V Lookup accurate?
Statement 1: Given a value in the left-most column, it can retrieve the corresponding value from any other column.
Statement 2: Given a value in the top-most row, it can retrieve the corresponding value from any other row.
- Statement 1 is false, and statement 2 is true.
- Statement 1 is true, and statement 2 is false.
- Both statement 1 and statement 2 are true.
- Both statement 1 and statement 2 are false.
Statement 1 is true, and statement 2 is false.
Which one of the following options about the argument in the MATCH and INDEX functions is accurate?
Statement 1: The function INDEX (B3:E10, 4, 2) has a two-dimensions (2D) array argument.
Statement 2: The function MATCH (25, D3:D10, 0) has a two-dimensional (2D) array argument.
- Both statement 1 and statement 2 are true.
- Statement 1 is false, and statement 2 is true.
- Statement 1 is true, and statement 2 is false.
- Both statement 1 and statement 2 are false.
Statement 1 is true, and statement 2 is false.
Which one of the following options about the function MATCH is accurate?
Statement 1: MATCH function returns the value given its position in an array.
Statement 2: MATCH function returns position given the value in an array.
- Both statement 1 and statement 2 are true.
- Both statement 1 and statement 2 are false.
- Statement 1 is true, and statement 2 is false.
- Statement 1 is false, and statement 2 is true.
Statement 1 is false, and statement 2 is true.
Which one of the following options about the MATCH & INDEX function "=INDEX(B3:E10,MATCH(33,B3:B10,0),MATCH(21,B3:E3,0) is accurate?
Statement 1: MATCH feeds the position in column array B3:B10 and the position in row array B3:E3 to INDEX to retrieve a value from a 2D array B3:E10.
Statement 2: MATCh feeds column and row positions in a 2-D array B3:E10 to INDEX to retrieve a value from 2D array B3:E10.
- Statement 1 is false, and statement 2 is true.
- Both statement 1 and statement 2 are true.
- Both statement 1 and statement 2 are false.
- Statement 1 is true, and statement 2 is false.
Statement 1 is true, and statement 2 is false.
Which one of the following options about the H Lookup is accurate?
Statement 1: Given a value in the left-most column, it can retrieve the corresponding value from any other column.
Statement 2: Given a value in the top-most row, it can retrieve the corresponding value from any other row.
- Statement 1 is false, and statement 2 is true.
- Statement 1 is true, and statement 2 is false.
- Both statement 1 and statement 2 are true.
- Both statement 1 and statement 2 are false.
Statement 1 is false, and statement 2 is true.
Recommended textbook explanations
Discrete Mathematics and Its Applications
7th Edition
Kenneth Rosen
4,284 explanations
Discrete Mathematics and Its Applications
8th Edition
Kenneth Rosen
4,399 explanations
Thinking Mathematically
6th Edition
Robert F. Blitzer
7,466 explanations
Discrete Mathematics
7th Edition
Richard Johnsonbaugh
4,028 explanations
Sets found in the same folder
Quiz 9
10 terms
Quiz 8
10 terms
Quiz 11
10 terms
Quiz 5
10 terms
Other sets by this creator
Exam 2
100 terms
Chapter 13 Quiz
10 terms
Quiz 10
10 terms
Chapter 10 Quiz
10 terms
Other Quizlet sets
Pharm Midterm
51 terms
Concepts of Integrated Training (Flexibility, Card…
63 terms
Final for English: By Christopher Marroquin
50 terms
Clin Med Behavior Lecture #8 Substance Use Disorder
45 terms