Welcome to your MS Excel Skills Exam

Goal: Using the name typed in cell A8, return the corresponding email address from the table in cell B9.
Instructions: Complete the formula below by typing the missing function that is used to return a value based on a matching value in a table.
=
(A8,EmployeeTable,4,FALSE)

Goal: Using the name typed in cells A9 and B9 (first name, last name), return the corresponding email address from the table in cell C9.
Instructions: Complete the formula below by typing the missing function used in conjunction with MATCH in order to return the email address based on multiple criteria.
{=
(EmployeeTable2[Email],MATCH(A9&B9,EmployeeTable2[First Name]&EmployeeTable2[Last Name]))}
What are the advantages of converting spreadsheet data into a table in MS Excel? (Select all that apply):
Which of the following are pivot tables used for? (Select all that apply):