BNB_ExcelTest

If a column has joint-data (such as last name, first name), you can automatically "pull" sections of the data into a new column by using:

• Flashfill
• Autofill
• Merge & Center
• Copy and Paste

This function looks for a value in the leftmost column of a table, and then returns a value in the same row from another column you specify.

• sum
• countif
• trim
• vlookup

And, Or, and Not are called __________ operator.

• comparison
• logical
• arithmetic
• connector

Which of the following has a syntax error?

• If(B3<=20,"good",If(B3=<30,"better","best))

• If(B3<=75,"pass",if(B3<=60,"credit","distinction"))

• If(B3="blue","Boy,"Girl")

How do you fix only one column

• $B$2

• $B2

• B$2

• B2$

The absolute cell reference uses which symbol:

• $

• %

• *

• &

To combine text that is in two different cells, use the formula:

• COMBINE

• MATCH

• CONCATENATE

• SUBTOTAL

Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?

• =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

• =VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)

• =VLOOKUP(lookup_value, table_array, col_index_num, value)

Which of the following is NOT possible with VLOOKUP?

• You can lookup values located in a different worksheet.

• You can lookup values located in a column to the right of the column that contains the lookup value.

• You can lookup values located in a column to the left of the column that contains the lookup value.

Study the screenshot above. To find the price for the selected product (coffee in the example above), what formula would you type into the highlighted cell (B19)?

• =VLOOKUP(A19,A2:C16,3,FALSE)

• =VLOOKUP(A19,A2:C16,1,TRUE)

• =VLOOKUP(A19,A2:C16,C,FALSE)

• =VLOOKUP(B19,A2:C16,3,FALSE)