Returns the value or the reference to a value within a range based on X and Y coordinates.
A) DSUM
B) INDEX
C) IPMT
D) PPMT
Correct Answer:
Verified
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
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
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
Q44: The database argument of any database function
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