Multiple Choice
What best describes a criteria range?
A) The table upon which a filter is applied
B) The group of adjacent cells that specifies the conditions used to control the results of a filter
C) The filtered range of cells
D) The copied range of cells
Correct Answer:
Verified
Correct Answer:
Verified
Q27: If you need to find the day
Q28: An INDEX function returns the position of
Q29: Which is the Array argument in =INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)?<br>A)MAX(B2:B5)<br>B)MATCH(MAX(B2:B5),B2:B5,0)<br>C)1<br>D)A2:B5
Q30: What is the purpose of the Row_num
Q31: Which financial function calculates the net present
Q33: What is < > equivalent to in
Q34: The YEARFRAC function returns the number of
Q35: A MATCH function returns the value of
Q36: An OR function evaluates to TRUE only
Q37: A Truth Table is a matrix that