If data is organized in rows, which function is used to search a value ?
यदि डेटा को पंक्तियों में व्यवस्थित किया जाता है, तो किसी वैल्यू को खोजने के लिए किस फंक्शन का उपयोग किया जाता है ?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: A. HLOOKUP
Explanation
HLOOKUP (horizontal lookup) searches across the top row of a table; VLOOKUP searches down the first column.
HLOOKUP पंक्ति (row) में खोजता है, जबकि VLOOKUP पहले कॉलम में ऊपर से नीचे खोजता है।
More Office Automation (MS Office) questions
- .............. 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 .............. .
- A small dark square in the right hand corner of the cell is called as :
- In MS-Excel ..... option can be used to keep the desired rows and columns visible while the rest of the sheet scrolls.
- In context of MS-Word, with a ......... indent, the second and all the following lines of a paragraph are indented more than the first line…