Lab6_Ex6 - 48 FRASER Graduate 88 GRAVAS Graduate 95 HALL...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
This example uses VLOOKUPand MATCH to find the appropriate Letter Grade for students in different fac u Table contains the GradeTable that lists break points and corresponding letter grades for 3 ficticious facul t Class contains a list of names, associated faculties, and scores on a campus-wide test.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Arts Science Graduate 0 F F F 40 E F F 50 D Pass F 55 D+ C- F 60 C C Pass 65 C+ C+ Pass 70 B B- C 75 B+ B C 80 A B+ B 85 A A- B 90 A+ A A 95 A+ A+ A
Background image of page 2
Name Fac Score Grade BERNIER Graduate 59 BINCE Arts 89 BUSHBY Arts 47 CAMPBELL Science 78 CORREIA Graduate 73 CUKIER Arts 72 DA-COSTA Science 85 DHILLON Arts 63 FERNANDES Science
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 48 FRASER Graduate 88 GRAVAS Graduate 95 HALL Science 48 HUNT Arts 76 IVANOVA Science 75 JOHNSON Science 75 JOLLY Arts 76 KALICHARAN Arts 78 LUSSIER Arts 74 MUHIC Science 65 NACCI Arts 68 OLDFIELD Science 63 PARK Arts 62 PAULSON Graduate 91 ROY Graduate 86 RUSSO Graduate 84 SABHARWAL Arts 61 SHERRITT Arts 41 SIMPSON Graduate 64 SIN Science 49 SMYLIE Arts 72 THOMAS Graduate 89 TJANDRA Graduate 74 TROTTER Science 73 WONG Science 87 WRIGHT Arts 85...
View Full Document

Page1 / 3

Lab6_Ex6 - 48 FRASER Graduate 88 GRAVAS Graduate 95 HALL...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online