Excel Lookup and Data Extraction Functions
The Function ________ in Excel is used to look up information in a table and extract the corresponding data.
ایکسل میں کس فنکشن کا استعمال ٹیبل میں معلومات تلاش کرنے اور متعلقہ ڈیٹا کو نکالنے کے لیے کیا جاتا ہے۔
Answer: VLOOKUP
Explanation
The VLOOKUP is used when data is listed in columns.
This function searches for a value in the left-most column
You can use VLOOKUP to find data in a sorted or unsorted table.
VLOOKUP stands for Vertical Lookup function
This question appeared in
Past Papers (4 times)
District Sessions Court Past Papers (2 times)
IBA STS Past Papers, Syllabus, Jobs (2 times)
This question appeared in
Subjects (1 times)
COMPUTER (1 times)
Related MCQs
- MS-Excel uses the _____ function when creating a data table.
- Noor Fatima has collected the required data from her office. Now she wants to extract important information from this data. Which of the following can help her achieve this?
- The ______ function in Excel returns the highest value in a set of data that you specify.
- Who has the power to save data or information including real time data, videos?
- The function to insert data in a stack data structure is _____?
- Data in ________ bytes size is called Big Data.
- In MS Excel, through which of the following table options can charts be created?
- In Excel, The rows of a table correspond to _____?
- Which one is not a Function in MS Excel?
- In Excel, what is the function of the F11 key?
