What is/are the primary functions to look up the information stored in a list or table in Excel?
एक्सेल में किसी सूची या तालिका में संग्रहित जानकारी को देखने के लिए प्राथमिक फंक्शन क्या है/हैं?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: D. All options are correctसभी विकल्प सही हैं
Explanation
Excel's lookup functions are VLOOKUP (searches down a column), HLOOKUP (searches across a row) and LOOKUP (searches a single row or column), so all are correct.
एक्सेल के लुकअप फंक्शन हैं: VLOOKUP (कॉलम में ऊपर से नीचे), HLOOKUP (पंक्ति में बाएँ से दाएँ) और LOOKUP (एक पंक्ति/कॉलम) — इसलिए सभी सही।
More Office Automation (MS Office) questions
- .............. allows you to alter all the slides in the presentation.
- ............ is a drawing object which is usually printed as the background of text on all the pages of document.
- If data is organized in rows, which function is used to search a value ?
- .............. allows you to synthesize and analyze data from list or existing table.
- ............ command is used to duplicate the active document under different names ?
- Chart created on worksheet is called as .............. .