Match the following terms to their meanings:
I. INDEX function array
II. INDEX function reference
III. MATCH
IV. Lookup_value
V. Match_type
A. Searches for a specific item in a range and returns the relative position of the item
B. Returns a value of a component in a table or an array
C. Argument that specifies which value to return
D. Argument that specifies the value to be looked up
E. Returns the reference of a cell at the intersection of a specific row and column
Answer: B, E, A, D, C
You might also like to view...
The first phase of risk management is _________.
A. risk identification B. design C. risk control D. risk evaluation
Which of the following can be used to increase the visibility of your website?
A. A site map B. A social networking site C. An SSL certificate D. An HTTPS server
The email acronym "iow" stands for "____."?
A. ?inbox/outbox/work B. ?in other words C. ?in or win D. ?in one word
A slice can be created automatically or by using the _____ tool.
A. Selection B. Picker C. Slice D. Draft