Multiple choice

A company while sending its data to consultancy, sent the salary in one file and rest of the information in other file. Which function can be used to make a consolidated data with salary and rest of the information?

  1. HLOOKUP function

  2. VLOOKUP function

  3. GETPIVOTDATA function

  4. GET function

  5. GOT function
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The function merges the two files in sequential and orderly manner and makes a consolidated files at user end.

Keep practicing — related questions