10 * 51% AT&T Keaa cnapters: z ana Task 1: 3:07 PM e mycourses.msstate.edu 1. Re

Question

10 * 51% AT&T Keaa cnapters: z ana Task 1: 3:07 PM e mycourses.msstate.edu 1. Reconstruct the worksheet containing student exam scores as shown below in Excel Overall Score xam1 Exam2 Final Ex Me S62 raham Richardson 92 Williams AVERAGE a Arrange the students alphabetically by name. b l the last column, determine the Overall Score for each student. Exams each count 30% each towards the Overal Score and the Final Exam counts the remaining 40%. e. Determine the average score for each of the three exams, and the overall average, in the cells on the bottom row 2. Then enhance its appearance by editing it in the following ways a. Add some empty space at the top of the worksheet. Place a worksheet title (e.g. Engineering Analysis 100 Semester Grade Reports) at some convenient location within this space. Try a single-Line title. decimal places. worksheets more readable b. Format the numerical values so that they all show two c. Adjust the column widths as required to make the d. Align the numerical values and their headings so that they are centered horizontally within their respective cells. Task 2:

Explanation / Answer

Engineering Analysis 100 Semester Grade Reports Student Exam1 Exam2 Final Exam Overall Score Davis 95.00 73.00 89.00 86.00% Graham 72.00 76.00 69.00 72.00% Jones 98.00 95.00 89.00 93.50% Meyers 55.00 62.00 75.00 65.10% Richardson 92.00 55.00 65.00 70.10% Thomas 91.00 77.00 77.00 81.20% Williams 66.00 59.00 61.00 61.90% AVERAGE 81.29 71.00 75.00 75.69%

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

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