Upgrade to remove ads
Only $35.99/year

Quiz 10

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 EditionKenneth Rosen
4,284 explanations

Discrete Mathematics and Its Applications

8th EditionKenneth Rosen
4,399 explanations

Thinking Mathematically

6th EditionRobert F. Blitzer
7,466 explanations

Discrete Mathematics

7th EditionRichard Johnsonbaugh
4,028 explanations