This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Formatting 1. Format Cells A5:G40 to have a border like column H 2. Color background and font in Row 5 to be consistent with cell H5. 3. Format border and background color of rows 43-45 to be like row 42. Also make font bold. 4. Using conditional formatting, I want you to highlight all incomplete assignments (i.e. The assignment or quiz = 0) Calculations 1. Calucate each student's current grade in the course in column G. To do this sum all the students grades and divide by the potential points (i.e. 265) 2. Using cell B42 as a hint, calculate the average score of both homeworks, both quizes, and exam. 3. Use function lookup to calculate the MIN, MAX, and Standard Deviation for both homeworks, quizes, and the exam 4. In cells K12:K15 use the COUNTIF or SUMIF function to count the number of A's, B's, C's, D's, and F's overall. Only one will do the trick so try both and see which works. 5. In K15, use SUM function to sum the total number of grades. Grade Sheet Name Josephine Do This exercise will train you in computing SUM, AVERAGE, MIN, MAX, STD DEVIATION, COUNTIF, and some basic formatting...
View Full Document
- Spring '10
- potential points, 93.6%, 89.8%, 90.2%, 91.7%