MS Excel Skills Exam 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]))}Goal: Return a value of "Pass" in cell B3 if the score is 70 or above, or a value of "Fail" otherwise.Instructions: Fill in the missing piece of the following IF formula in order to achieve this.=IF( ,"Pass","Fail")Goal: Create an absolute reference to cell A2 in cell C2.Instructions: Complete the formula to achieve this.= What are the advantages of converting spreadsheet data into a table in MS Excel? (Select all that apply): A formula entered into a table cell automatically gets filled in for all table cells in that column. Tables are automatically added to the data model. Names of tables and columns can be used in functions instead of cell references. A table automatically expands when data is entered in the last row for easy data entry. Many formula functions can only be used with data in tables. Arrays can only be used for data that is stored in tables.Which of the following are pivot tables used for? (Select all that apply): Grouping large amounts of data to create more manageable chunks. Providing an efficient tool for data entry. Providing summary calculations on groups of data. Filtering data to be able to view subsets of data. Enabling users to quickly delete segments of data. Visualize large amounts of data graphically.Time is Up! Posted in .
