Excel Functions and Their Applications

What is the main reason to use Excel functions for data?

• To make data look pretty.

• To find information, make decisions, and clean up data.

• To play games.

• To draw pictures.

If you use VLOOKUP to find the salary of Employee ID 104 in the given table, what salary would be returned?

• 55000

• 62000

• 70000

• 48000

What is a limitation of the VLOOKUP function?

• It can only look for numbers.

• It can only look for text.

• It can only look to the right of the search column.

• It can only look to the left of the search column.

What is a special ability of the XLOOKUP function compared to VLOOKUP?

• It can only look to the right.

• It can look both left and right.

• It can only look for exact matches.

• It can only look for approximate matches.

If you use XLOOKUP to find the name of the employee with a salary of 55,000, what name would be returned?

• Mary Jones

• John Smith

• Lisa Davis

• Tom Wilson

Which two functions are combined to make the powerful INDEX+MATCH combo?

• SUM and AVERAGE

• COUNT and MAX

• INDEX and MATCH

• LEFT and RIGHT

What does the IF function help you do in Excel?

• Add up numbers.

• Sort data alphabetically.

• Make a choice based on a condition.

• Change the color of cells.

When would you use a Nested IF function instead of a simple IF function?

• When you only have one condition to check.

• When you want to check many conditions to give different results.

• When you want to add numbers together.

• When you want to find the average of numbers.

What does the IFS function help you do in a spreadsheet?

• Add numbers together.

• Change text to all capital letters.

• Check many conditions and give different results.

• Remove extra spaces from text.

What is the main job of the TRIM function in a spreadsheet?

• To make all letters uppercase.

• To remove extra spaces from text.

• To change numbers into words.

• To add spaces between words.