The criteria range is a range of cells that specifies the conditions used to filter a table.
Correct Answer:
Verified
Q6: IF and AND are examples of _
Q7: MATCH and INDEX are logical functions.
Q8: A loan amortization table is a schedule
Q9: When a loan is repaid,the total principal
Q10: DMIN is a database function.
Q11: When constructing an advanced filter,the _ range
Q12: =IF(AND(D7="manager",F7<F$3),"Due for raise","NA")is an example of a
Q13: CUMIPMT and CUMPRINC are lookup functions.
Q15: Which of the following is NOT a
Q16: The _ function results in a TRUE
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