You are working as a summer intern for the office of admissions at your local university. You have been given historical enrollment information and you want to forecast potential student enroll-ment in 2025. After using the FORECAST.LINEAR function to complete the forecast, you decide to manually check your work. Unfortunately, you determine there is an error in the worksheet. To locate the error and complete the forecast do the following: Open e08d1StudentEnrollment and save it as e08d1StudentEnrollment_LastFirst. Locate the FORECAST.LINEAR function used in cell E6. Note the known_x’s and known_y’s arguments are reversed. Edit the function’s arguments to the correct known_x’s and known_y’s. If this step is done correctly, the Check cell will match and a green fill color will automatically be added. Next, complete the High and Low threshold cal-culations in the range F6:G6. Create a footer with your name, the sheet name, and the file name on each worksheet. Save and close the workbook. Based on your instructor’s directions, submit e08d1StudentEnrollment_LastFirst.

You are working as a summer intern for the office of admissions at your local university. You have been given historical enrollment information and you want to forecast potential student enroll-ment in 2025. After using the FORECAST.LINEAR function to complete the forecast, you decide to manually check your work. Unfortunately, you determine there is an error in the worksheet. To locate the error and complete the forecast do the following: Open e08d1StudentEnrollment and save it as e08d1StudentEnrollment_LastFirst. Locate the FORECAST.LINEAR function used in cell E6. Note the known_x’s and known_y’s arguments are reversed. Edit the function’s arguments to the correct known_x’s and known_y’s. If this step is done correctly, the Check cell will match and a green fill color will automatically be added. Next, complete the High and Low threshold cal-culations in the range F6:G6. Create a footer with your name, the sheet name, and the file name on each worksheet. Save and close the workbook. Based on your instructor’s directions, submit e08d1StudentEnrollment_LastFirst.

You are working as a summer intern for the office of admissions at your local university. You have been given historical enrollment information and you want to forecast potential student enroll-ment in 2025. After using the FORECAST.LINEAR function to complete the forecast, you decide to manually check your work. Unfortunately, you determine there is an error in the worksheet. To locate the error and complete the forecast do the following: Open e08d1StudentEnrollment and save it as e08d1StudentEnrollment_LastFirst. Locate the FORECAST.LINEAR function used in cell E6. Note the known_x’s and known_y’s arguments are reversed. Edit the function’s arguments to the correct known_x’s and known_y’s. If this step is done correctly, the Check cell will match and a green fill color will automatically be added. Next, complete the High and Low threshold cal-culations in the range F6:G6. Create a footer with your name, the sheet name, and the file name on each worksheet. Save and close the workbook. Based on your instructor’s directions, submit e08d1StudentEnrollment_LastFirst.