How is the Microsoft Excel VLOOKUP tool used in data analysis?
- to summarize descriptive data sets
- to interpret inferential data sets
- to find specific information in a large spreadsheet
- to find the mean average of data sets
| Answers Explanation & Hints:
VLOOKUP is a very powerful data analysis tool in Microsoft Excel that is used to find information in a large spreadsheet. VLOOKUP is a vertical lookup function, so the data needs to be organized in a table where each row has different but related forms of data in each column. |