Which of the following is the best choice to lookup values when VLOOKUP and HLOOKUP are not possible?
Category: Uncategorized
When #NAME? displays in a cell, you may have:
When #NAME? displays in a cell, you may have:
Which function will return the intersection of a specific ro…
Which function will return the intersection of a specific row and column?
When importing an Access database table, Excel:
When importing an Access database table, Excel:
The IPMT function should be used to calculate the specific i…
The IPMT function should be used to calculate the specific interest paid on one installment of a loan.
Which of the following is a nested function?
Which of the following is a nested function?
What is the first argument of the IF function?
What is the first argument of the IF function?
When editing a PivotTable where are values field settings ed…
When editing a PivotTable where are values field settings edited?
Which of the following functions will return the principal p…
Which of the following functions will return the principal payment of a loan?
If there are four possible outcomes, how many logical tests…
If there are four possible outcomes, how many logical tests are required?