click below
click below
Normal Size Small Size show me how
MIS Chapter 5
Functions of Chapter 5
Question | Answer |
---|---|
The function that looks up a value stored in the first column of a vertical lookup table and retrieves data stored in the same row of a subsequent column. | VLOOKUP |
The function that looks up a value stored in the first row of a horizontal lookup table and retrieves data stored in the same column of a subsequent row. | HLOOKUP |
The function that looks up the greatest value that does not exceed a specified value anywhere in a table or range, whether it is organized in a vertical or horizontal orientation. | LOOKUP |
The function that retrieves data from multidimensional tables. | INDEX |
The function that returns a value or a range for up to 29 different values. | CHOOSE |
The function that checks whether a specified value refers to an empty cell. | ISBLANK |