NEW
Font size
WorksheetsVLOOKUP/HLOOKUP IGCSE Grade 11
Total questions: 17
Worksheet time: 34mins
Identify the formula for
VLOOKUP
=VLOOKUP(table_array, lookup_value, col_index_num, [range_lookup])
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(table_array, col_index_num, lookup_value,[range_lookup])
=VLOOKUP(lookup_value, table_array, [range_lookup], col_index_num)
What is the correct formula for this?
=HLOOKUP(A4, A1:F1,2, FALSE)
=VLOOKUP(B4, A1:F1,2, TRUE)
=HLOOKUP(A4, A1:F1,2, TRUE)
=VLOOKUP(A4, A1:F2,2, FALSE)
What formula is used to find East_01?
=HLOOKUP(A11, B1:B9,2, TRUE)
=VLOOKUP(A11, A1:B9,2, TRUE)
=HLOOKUP(A11, A1:B9,2, FALSE)
=VLOOKUP(A11, A1:B9,2, FALSE)
Jill wants to search her spreadsheet for a vaule in the first column of her tabel. What function should she use?
VLOOKUP
HLOOKUP
LOOKUP
SEARCH
What function is used to find price of Product_2?
HlookUp
Index
Match
VlookUp
What is the correct formula?
=VlookUp(A8, A1:B5, 2, FALSE)
= HlookUp(A8, A1:B5, 2, FALSE)
= VlookUp(A8, A1:B5, 2, TRUE)
What match type returns the exact value?
0(zero)
1(positive one)
-1(negative one)
2 (two)
What are columns in spreadsheet?
vertical
horizontal
upside down
downside
What are rows in spreadsheet?
vertical
horizontal
upside down
right
What is the first step to create a formula?
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that you're about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
the intersection of a single
row and a single column
range
reference
cell
argument
Absolute cell reference
is group of selected cells which are highlighted
is reference which is automatically fills other cells
does not change when the formula is copied or moved to a new location
There are two types of references:
1._____________ : (B2:B6), C4
2.Absolute : $A$2, ($B$2:$B$6),
Changing
Fluctuate
Relative
Linked
If the mark is more than 50, the student passes. Which function we should use in D3? (We will use AutoFill for others)
=IF($B$3>50,"YES","NO")
=IF($C$3>50,"YES","NO")
=IF(C3>50,"YES","NO")
=IF(B3>50,YES,NO)
