Font size
WorksheetsIF & VLOOKUP Functions
Total questions: 10
Worksheet time: 6mins
What does the > logical operator do?
Less than
Not equal to
More than or euqal to
More than
>=10 what does this logical operator mean?
More than or equal to 10
Not equal to 10
More than 10
Less than or equal 10
The IF function's syntax can be broken down in three parts
=IF(logical_test, [value_if_true], [value_if_false])
select from below the correct formula
=IF(A1="Umbrella", "It will rain", "It won't rain")
=IF(A1=1, A2+10, No ready yet)
=IF(A1>"10", "Hello", Goodbye)
=IF(A!<>A2), ("Buy"), ("Sell")
Looking at the data in the picture, use the IF function to add 10mph to the NEW (mph) column, if the cars are faster than 260mph, if they are not faster than 260mph return "Not a Fast Car"
(a)
When setting up two tables to use the VLOOKUP fucntion, is it recommended to name the tables?
TRUE
FALSE
You have been given a spreadhseet that has the following VLOOKUP function,
=VLOOKUP([@name], Table_Master, 8, 0)
What is the number 8 in the formula refering to?
The name of the table where you are getting the data from
The value you are looking for
The column number where the data you want is located
The number of characters the function will return
When writting a VLOOKUP function, the last bit of informatio you need to add to the function is if you want an Approximate match or an Exact match. If you write FALSE, what would the function return?
Approximate match
Exact match
Approximate and Exact match
None of the options
Explore the VLOOKUP function syntax below
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
What does it mean by table_array?
This is the table where I am copying the information to
This is the number of columns for the table
This is the table where I can find the information I need
This is the type of data the table will return
When using Formulas and Functions and using text within them, you need to write them in between " "
TRUE
FALSE
Write the 3 mistakes with the Function below
=IF([@[Miles Per Hour (mph)]]<260, [@[Average Cost]]-"20000" Fast Car)
(a)
