IF and Vlookup Function

If function allows to choose between two actions based on whether the condition is true or ..................

• false

• 1

• Yes

• -1

IF function makes use of something called

• functional operators

• relational operators

• relational database

• absolute reference

Fill the missing

=IF(....................., value_if_true,value_if_false)

• lookup_value

• criteria

• condition

• logical_test

Function inside another function

• vlookup function

• nested function

• nest function

• if function

..................search for an item of data in a table and then extract the rest of information relating to that item

• lookup ()

• 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?

• F1

• F2

• F3

• F4

Which of these is an absolute reference?

• A3

• A13

• A$3$

• A*3

Which of these Vlookup functions is searching for an exact match?

• =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. Which feature should we use?

• Conditional formatting

• Data validation

• Bulleted list

• Absolute cell reference