NEW
Font size
WorksheetsMS Excel VLookup
Total questions: 10
Worksheet time: 6mins
..................search for an item of data in a table and then extract the rest of information relating to that item
................. ek table mein kisi data ki khoj karke aur phir us item se sambandhit baki jaankari nikalta hai
vlookup ()
if ()
count()
sumif()
An example of a range address
A1;B3
A1:B3
A1-B3
A1.B3
What is the Keyboard shortcut to make a cell absolute reference?
Kisi cell reference ko Absolute cell reference ( $A$2 ) bnane ke liye keyboard shortcut key select krein.
F1
F2
F3
F4
Which of these Vlookup functions is searching for an exact match?
In Vlookup functions mein se kaunsa ekdum sahi match khoj raha hai?
=VLOOKUP (True, A2:B6, 2, C16)
= VLOOKUP (C16, A2:B6,3, TRUE)
=VLOOKUP (C16, A2:B6, 3, FALSE)
=VLOOKUP (C16, A2:B6,1, $C$4:$D$15)
We want to make a Payment Type Column as a drop-down list in a cell. Which feature should we use?
Ham ek "Payment Type" column ko ek cell me drop-down list ke roop mein banana chahte hain. Hamein kaunsa feature istemal karna chahiye?
Conditional formatting
Data validation
Bulleted list
Absolute cell reference
The first argument in a VLOOKUP function tells the function.................
VLOOKUP function mein pehla argument function ko batata hai.................
What to look for
Where to look
To use an approximate or exact match
The column index number
What value would excel return for this formula? =(82-32)*5+8*2
Is formula ke liye Excel kis maan (value) ko vapas karega? =(82-32)*5+8*2
230
21
226
26
VLOOKUP formula to be used to get result in the highlighted cell
Konsa formula highlighted cell me dikh rahe data ko lane ke liye use kiya gya hai
=VLOOKUP(A2:B9,2,FALSE)
=VLOOKUP(D3,A2:B9,FALSE)
=VLOOKUP(D3,A2,2,FALSE)
=VLOOKUP(D3,A2:B9,2,FALSE)
Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?
Neeche diye gaye formulas me se kaun se sahi syntax (formula arguments) VLOOKUP function ke liye hai?
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
=VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)
=VLOOKUP(lookup_value, table_array, col_index_num, value)
When using Formulas and Functions and using text within them, you need to write them in between " "
Jab aap Formulas aur Functions ka istemal karte hain aur unke andar text ka istemal karte hain, toh aapko unhe " " ke beech mein likhna zaruri hai.
TRUE
FALSE
