1 Answer to Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For example, using the current data, you want the function to return the third quarter sales for Erica.
Download and open the file named exploring_e07_grader_a1_Sales.xlsx, and then save the file as exploring_e07_grader_a1_Sales_LastFirst, replacing LastFirst with your name. 0. 2. On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company.