Lookup, logical and financial functions, pivot tables, data validation and spreadsheet modeling best practices.
46 cards · mixed cards · AI-written, checked twice. Edit anything.
- What does VLOOKUP do?
Show answer
Searches for a value in the first column of a table and returns a corresponding value from another column- What is the 4th argument of VLOOKUP?
Show answer
A logical value: FALSE for exact match, TRUE for approximate match- Why must VLOOKUP data be in a specific column order?
Show answer
The lookup column must be the leftmost column in the range- What error does VLOOKUP return when a value is not found?
Show answer
#N/A- When should you use INDEX and MATCH instead of VLOOKUP?
Show answer
When the lookup column is to the right of the return column, or when you need more flexibility- What does HLOOKUP do?
Show answer
Searches horizontally for a value in the first row of a table and returns a corresponding value from another row- What is the difference between INDEX and MATCH functions?
Show answer
INDEX returns a value from a range at a specified position, MATCH returns the position of a value in a range- Can MATCH work with text criteria?
Show answer
Yes, MATCH can find exact or approximate matches in text- What are the three required arguments of an IF function?
Show answer
A logical condition, a value if true, and a value if false- When should you use IFS instead of nested IF statements?
Show answer
When you have multiple conditions to evaluate, as IFS is cleaner and more readable- What does the AND function require to return TRUE?
Show answer
All conditions must be TRUE- What does the OR function require to return TRUE?
Show answer
At least one condition must be TRUE- What does the NOT function do?
Show answer
Reverses or negates a logical value (TRUE becomes FALSE, FALSE becomes TRUE)- Can logical functions be nested together in a formula?
Show answer
Yes, logical functions are commonly nested for complex conditions- What does NPV calculate?
Show answer
The net present value of a series of cash flows discounted at a specified rate
FlashKeepers