A learner is analyzing a large volume of data in a Microsoft Excel spreadsheet and wishes to find duplicate data values. The data has been organized in a table where each row has different but related forms of data in each column. Which Microsoft Excel function can be used to do this?

VLOOKUP is a very powerful data analysis tool in Microsoft Excel that is used to find information in a large spreadsheet including duplicate values. 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.
The IF function makes logical comparisons.
The ISNA looks for cells with #N/A.
The SUM function is used to add the values in cells selected.