IF & VLOOKUP Functions

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"

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)