wd DemoLes 12 1 - MABS 101 Gradesheet Section 1 Name Keiko...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: MABS 101 Gradesheet Section 1 Name Keiko Moe Mei Joe Sue Becky Lee ID 1389 2345 3449 3458 5095 8911 8923 Highest Lowest Average Quiz1 69 95 40 85 78 43 75 95 40 69.29 Quiz2 70 0 55 95 95 65 72 95 0 64.57 Final Exam 75 79 67 98 84 70 89 98 67 80.29 Final Average 71.33 58.00 54.00 92.67 85.67 59.33 78.67 92.67 54.00 71.38 Group worksheet w/ Ctrl Ungroup by right clicking or choosing another worksheet Group worksheets and find average, find number of students, passed and failed Use Ctrl/Drag to copy for a third section. Erase data leaving formulas. Copy using the shortcut memu for the fourth section. Number of Students Number who Passed Number who Failed 7 4 3 heet w/ Ctrl right clicking or ther worksheet heets and find number of sed and failed g to copy for a Erase data ulas. Copy using emu for the . MABS 101 Gradesheet Section 2 Name Abdel Jane Jim Jorge Maria Olaya Rui ID 1345 1596 4432 4321 4589 2345 3419 Highest Lowest Average Quiz1 80 82 83 85 75 98 95 98 75 85.43 Quiz2 85 75 42 59 89 95 72 95 42 73.86 Final Exam 90 87 75 92 93 91 95 95 75 89.00 Final Average 85.00 81.33 66.67 78.67 85.67 94.67 87.33 94.67 66.67 82.76 Number of Students Number who Passed Number who Failed 7 6 1 MABS 101 Gradesheet Section 2 Name ID Quiz1 Quiz2 Final Exam Final Average #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Highest Lowest Average 0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DIV/0! Number of Students Number who Passed Number who Failed 0 0 7 Summary - Spring Classes Class M101, Section 1 M101, Section 2 Totals Number of Students 7 7 14 Passed 4 6 10 Failed 3 1 4 Highest Final Lowest Final Exam Exam 98 95 67 75 Simply click on corresponding cell in the corresponding worksheet MABS 101 Totals Number of Students 14 Passed 10 Failed 4 Highest Final Lowest Final Exam Exam 98 67 Use simple formulas Use + for cells and , in between ranges MABS 101 Totals Number of Students 14 Passed 10 Failed 4 Highest Final Lowest Final Exam Exam 98 67 Use 3D references Use sum function and shift to select more than one worksheet Simply click on corresponding cell in the corresponding worksheet Use simple formulas Use + for cells and , in between ranges Use 3D references Use sum function and shift to select more than one ...
View Full Document

This note was uploaded on 10/30/2010 for the course FINANCE Excel taught by Professor Vahn during the Spring '10 term at City College of San Francisco.

Ask a homework question - tutors are online