Podcast
Play an AI-generated podcast conversation about this lesson
Questions and Answers
What does the hlookup function do?
What does the hlookup function do?
- Lookup information in a row or column
- Remove specific row or column from a data set
- Retrieve the reference of the cell at the intersection of a particular row and column
- Find data in a horizontal table (correct)
What is the purpose of the index function?
What is the purpose of the index function?
- Lookup information in a row or column
- Remove specific row or column from a data set
- Retrieve the reference of the cell at the intersection of a particular row and column (correct)
- Find data in a horizontal table
What does the vlookup function return if the condition is not met?
What does the vlookup function return if the condition is not met?
- True
- Error message
- False (correct)
- Null
What is the purpose of the round up function?
What is the purpose of the round up function?
Signup and view all the answers
What does the even function do?
What does the even function do?
Signup and view all the answers
What does the decimal function do?
What does the decimal function do?
Signup and view all the answers
What does INT function do?
What does INT function do?
Signup and view all the answers
What is the purpose of product function?
What is the purpose of product function?
Signup and view all the answers
What type of functions are we moving on to after finishing math functions?
What type of functions are we moving on to after finishing math functions?
Signup and view all the answers
