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
Q31: Which of the following functions has the
Q32: Which of the following is the best
Q33: In the function =IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)),F5*K7 is the:
A)Value_if_true.
B)Value_if_false.
C)Logical_test.
D)Modifier.
Q34: Which of the following functions returns the
Q35: Which of the following is not a
Q37: When the DAVERAGE function returns #DIV/0:
A)there are
Q38: =IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9))is an example of a(n):
A)Database function.
B)Look Up
Q39: Returns the value or the reference to
Q40: Which of the following is not an
Q41: PPMT should be used to calculate the
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents