Asked by Tabatha Magnuson on Jul 24, 2024
Verified
Which of the following functions can you use to locate information in a table?
A) MATCH
B) TEXT
C) LOCATE
D) LOOKUP
LOCATE
A command or function in programming and software applications that is used to find and identify the position of a specified piece of data within a file or database.
LOOKUP
A function used in spreadsheet programs that searches one or more rows or columns for a specified value and returns a corresponding value from a different row or column in the same range.
- Learn how to use lookup functions to retrieve and manage data across tables.
Verified Answer
SM
Sophia MontemaranoJul 24, 2024
Final Answer :
D
Explanation :
The LOOKUP function is designed specifically to search for and retrieve data from a table based on certain criteria. The other options listed (MATCH, TEXT, LOCATE) are not designed for this purpose.
Learning Objectives
- Learn how to use lookup functions to retrieve and manage data across tables.