When the DAVERAGE function returns #DIV/0:
A) there are no records that fit the criteria.
B) there is a typo in the function.
C) a second criteria is needed.
D) the incorrect function was used.
Correct Answer:
Verified
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
Q36: When using Advanced Filtering,the criteria range must
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
Q42: The FV function is best suited for
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