some analysis, which will be used for better decision-making for future class offerings. Steps to Perform: 1. Start Excel. Open the downloaded Excel file named Assignment4_problem.xlsx. Save the file with the name Assignment4_LastFirst replacing LastFirst with your last and first nam Copy the Enrollment worksheet to the end of the workbook to make a backup copy of the data. Rename the worksheet EnrollmentBackup. On the InputData worksheet, select range B4:H8. Create named ranges using the top row as the name for your named ranges. Each range includes fitness class details. With B4:H8 still selected, enter ClassInfo into the Name Box to name the table. Select range B11:H14. Create named ranges using the top row as the name for your namex ranges. Each range is the list of instructors that can teach individual classes. On the Enrollment worksheet, in cell A13, insert a table using range A13:D106 and the top row as the headers. In cell D14, enter an HLOOKUP function that will look up the class numberin cell B14 and will use the ClassiInfo table to return the Fee from the fifth row of the table with an exact match. In cell E13, create a new column header named Class_Name. In cell E14, enter an HLOOKUP function that will look up the class number in cell B14 and use the Classinfo