Question 1
________ functions look up a value in a defined range of cells located in another part of the workbook to find a corresponding value.
◦ Lookup
◦ Financial
◦ Statistical
◦ Logical
Question 2
For lookup functions to work properly, the data in the table array must be sorted ________.
◦ in descending order
◦ in ascending order
◦ in reverse alphabetic order
◦ by color