Please show and explain step by step how to complete the six part Excel problem.

Question

Please show and explain step by step how to complete the six part Excel problem. The link to the Excel file will be below the question.

J.G. Wentworth is the Financial Officer for the University of East Dakota. He needs help to determine funding for students. Formulas should be able to automatically update alone if an exam score or funding qualification amount is changed for a student.

1a. Insert a formula in Cell A61 that will count the number of students listed.

1b. In cell B63, insert a formula that will tell Wentworth the average score that the students achieved on the qualifying exams. Make sure the number is formatted to show two decimal places.

1c. In cell F9, insert a formula that will tell Wentowrth how many students scored equally or above the average score. NOTE: You will need to type in the # you got from B63. Do not use cell reference.

1d. In cell B64, insert a formula that will tell Wentworth the score that appeared the most on the qualifying exams.

1e. In cell B65, insert a formula that will tell Wentworth the midpoint score based on all qualifying exams.

1f. In cell C61, insert a formula that will give you the total amount of funding needed.

Link: https://1drv.ms/x/s!AnWxTJTVVD_IdokdFGYgZ_Msd_M

Explanation / Answer

1a. Insert a formula in Cell A61 that will count the number of students listed.

1b. In cell B63, insert a formula that will tell Wentworth the average score that the students

1c. In cell F9, insert a formula that will tell Wentowrth how many students scored equally or above the average score. NOTE: You will need to type in the # you got from B63. Do not use cell reference.

1d. In cell B64, insert a formula that will tell Wentworth the score that appeared the most on the qualifying exams.

1e. In cell B65, insert a formula that will tell Wentworth the midpoint score based on all qualifying exams.

1f. In cell C61, insert a formula that will give you the total amount of funding needed.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.