NEW
Font size
WorksheetsExcel If, Index and Match
Total questions: 11
Worksheet time: 6mins
Does Index & Match formula breaks up when a column is inserted?
Kya Coloumn insert karne par Index & match kaam nahi karta?
YES
NO
If function allows to choose between two actions based on whether the condition is true or ..................
If Function, Condition True hai ya _______ is aadhar par action lene ki anumati deta hai
false
1
Yes
-1
Fill the missing
=IF(....................., value_if_true, value_if_false)
lookup_value
criteria
condition
logical_test
Function inside another function?
Function ke andar Function?
vlookup function
nested function
nest function
if function
Which of the formula is correct about INDEX function?
Kon sa formula INDEX function ko sahi se bata raha hai?
=INDEX(Array, Lookup Range, Column No)
=INDEX(Lookup range, Row No , Col No)
=INDEX(Row No, ColumnNo, Lookup range)
..................search for an item of data in a table and then extract the rest of information relating to that item
...................table mein data ke ek item ki khoj karta hai aur phir us item se sambandhit baki jankari nikaalta hai
lookup ()
if ()
count()
sumif()
When using VLookUp, use _______________ if you want to look for approximate matches rather than an exact match.
VLookUp ka upyog karte samay, _________ ka upyog karen agar aap "exact match" karana chahte hai.
True
False
From the above table, what is the correct INDEX & MATCH formula should be fill in the highlight box?
Uper diye table me , INDEX & MATCH ke liye sahi formula jo yellow box me answer le aaye?
=INDEX(A14,MATCH(D3:D10,A3:A10,0))
=INDEX(D3:D10,MATCH(A14,A3:A10,0))
=INDEX(D3:D10,MATCH(A3:A10,A14,0))
If the mark is more than 50, the student passes. Which function we should use in D3? (We will use AutoFill for others)
50 से अधिक अंक होने पर छात्र पास हो जाता है। हमें D3 में किस फ़ंक्शन का उपयोग करना चाहिए? (हम दूसरों के लिए ऑटोफ़िल का उपयोग करेंगे)
=IF($B$3>50,"YES","NO")
=IF($C$3>50,"YES","NO")
=IF(C3>50,"YES","NO")
=IF(B3>50,YES,NO)
14 >= 14
15 > 15
16 != 16
18 >= 19
Cell G8 = 80
IF function example: =IF(G8>40,"Yes","No")
What would show in the cell after you hit enter
Yes
No
Nothing would show
