1. Complete row 6. Find the Total and average. Use =Sum and Average functions.

For the honor column. Use the If function. The student is on the honor roll if the average is 80 or higher.

For pass/fail. Use the if function. The student passes if the student gets a 65 or more.

For the new average , use the if function. The student gets an extra 5 points if the average is 75 or higher.

Class Assignment Student Scores Julian the Great Total Average Honor p/f new avg Names Harris Powell Smith Devlin Acevedo Ortiz Thomas Gerard Waters Exam#1 100 92 88 66 60 76 55 40 70 Exam2 90 84 82 88 90 55 87 100 63 Exam#3 80 80 84 77 70 81 68 66 50 Minimum Score: Maximum Score: Average: DIRECTIONS 1. Complete row 6. Find the Total and average. Use Sum and Average functions. For the honor column. Use the Il function. The student is on the honor roll if the average is 80 or higher For pass/fail. Use the if function. The student passes if the student gets a 65 or more. For the new average, use the if function. The student gets an extra 5 points if the average is 75 or higher Directions for sorting Sort the following by last name and then first name in ascending order. LAST FIRST RAMIREZ TODD RAMIREZ BOB BROWN CARLOS REYES JOSE SMITH ALICE SMITH MARIA WHITE JAMES WHITE ADAM BROWN BILL