Question: Padical DRAWING TOOL FILE HOME INGERT PAGE LAYOUT FORMAS DATA DEVELOPER NOURE ACROBAT POWERPIVOT FORMAT xox Caliberty) 11 AA Nama Copy hels Somat Fate

Padical DRAWING TOOL FILE HOME INGERT PAGE LAYOUT FORMAS DATA DEVELOPER NOURE

Padical DRAWING TOOL FILE HOME INGERT PAGE LAYOUT FORMAS DATA DEVELOPER NOURE ACROBAT POWERPIVOT FORMAT xox Caliberty) 11 AA Nama Copy hels Somat Fate tiples Opbo Textbox36 2 F xvf A B E F G CD Professor's Grade Book at Dete Format L M N WEN ra- Clear Test Semester Test 3 Test 4 Average Homework Average Comment 3 Name Student ID Test 1 Test 2 4 Adams, John 011-12-2333 5 Barber, Maryann 444-55-6666 6 Boone, Dan 777-88-9999 78 7 Carson, Kit 888-88-8888 90 B Couter, Sara 100-00-0000 9 Fegin, Richard 10 Ford, Judd 11 Glassman, Kris 12 Goodman, Nell 222-22-2222 75 200-00-0000 90 444-44-4444 555-55-5555 92 882882828 80 71 70 84 OK 98 97 90 Foor 81 70 78 OK 90 50 70 90 78 88 882828 90 70 OK 40 79 Poor 65 95 OK 80 90 OK 82 77 Poor 65 78 Poor 13 HW Bonus 3 14 Class Average 15 Highest Grade 16 Lowest Grade 17 822288ER Select Cells A3:112 and convert into a table. 18 Exam Weights 20% 20% 20% 40% 19 20 21 22 23 24 25 GradeBook Sort Table by Semester Average (High to Low) Display word "Excellent" for all students with a semester average greater than 85, and the word "Good" otherwise Test Average si calculated by adding Test 1 Exam Weights 1 to Test 2 Exam Weights 2 to Test 3* Exam Weights 3 to If Homework is OK, add bonus points in (Cell H14) to test Average, otherwise enter test average score only By using Conditional Formatting, highlight in red background all the homework that is of status Poor

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!