In this scenario, you're working with data from a restaurant chain called Mapleton Gourmet Burgers. You have a list of all employees and their phone numbers, as well as a list of the restaurant's products and prices. By using VLOOKUP, you can find any employee's phone number by entering their employee ID$.$ PivotTables will help you instantly create useful reports about your product data.

Perform the following tasks:

VLOOKUP:

On the Employees worksheet, use VLOOKUP to create a formula in H$3$ that returns the phone number of the employee whose ID is in G$3.$

Then, change the value of G$3$ to $7654321.$

Create a New PivotTable:

Create a new PivotTable based on A$1$:C$34$ of the Menu Items worksheet.

Use the new PivotTable to create a vertical report that shows each product grouped by Category.