Multiple Choice
When using Advanced Filtering,the criteria range must contain at least:
A) three rows.
B) one columns.
C) three columns.
D) two rows.
Correct Answer:

Verified
Correct Answer:
Verified
Q42: Which database function will return the smallest
Q43: Which database function should be used to
Q44: =INDEX(A2:<br>B5,MATCH(MAX(B2:<br>B5),B2:<br>B5,0),1)is an example of a nested function.
Q45: The MATCH function match_type must be set
Q46: In the function =IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)),F5*K7 is the:<br>A)Value_if_true.<br>B)Value_if_false.<br>C)Logical_test.<br>D)Modifier.
Q48: Match the following terms with the corresponding
Q49: Match the following terms with the corresponding
Q50: If payments are made at the beginning
Q51: Excel permits _ IF statements in one
Q52: The _ function should be used to