Data Analytics

What does VLOOKUP stand for?

• Vertical Lookup

• Value Lookup

• Vector Lookup

• Variable Lookup

Which of these is a correct VLOOKUP syntax?

• VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• VLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

• VLOOKUP(table_array, lookup_value, col_index_num, [range_lookup])

• VLOOKUP(lookup_value, table_array)

In VLOOKUP, what does the argument [range_lookup] control?

• A) Case sensitivity

• Column selection

• Exact or approximate match

• Table sorting

Which function is used to search for data horizontally in a table?

• VLOOKUP

• HLOOKUP

• LOOKUP

• INDEX

What does HLOOKUP stand for?

• Hidden lookup

• High Lookup

• Hybrid Lookup

• Horizontal Lookup

In an HLOOKUP function, what does the row_index_num specify?

• The table range

• The column number to search

• The row number to return data from

• The lookup value

Which formula returns TRUE if A1 is greater than 10 and less than 20?

• =IF(A1>10, A1<20)

• =OR(A1>10, A1<20)

• =AND(A1>10, A1<20)

• =NOT(A1>10, A1<20)

What does the NOT function do?

• Returns TRUE if the argument is FALSE

• Returns FALSE if the argument is FALSE

• Checks multiple conditions

• Looks up data in a table

Which function checks if either condition is TRUE?

• AND

• NOT

• OR

• IF

In a pivot table, what is the "Values" area used for?

• Grouping data

• Filtering data

• Sorting data

• Performing calculations like SUM, AVERAGE