=IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9) ) is an example of a(n) :
A) Database function.
B) Look Up function.
C) Advanced Filter.
D) Nested IF function.
Correct Answer:
Verified
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
Q37: When the DAVERAGE function returns #DIV/0:
A)there are
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
Q43: In order for the AND function to
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