Biology 201 - Cellular Biology
Midterm Exam Scores
Student ID Student Name Score Grade
50497 Jan Randall 49 F
18814 Leann Wynter 63 C
50255 Daniel Slavko 83 A
71523 Mabel Graff 73 B
37696 Victor Miguel 48 F
59879 Marcelo Houssam 92 A
45057 Isabell Pyle 89 A
78181 Jaylon Barth 62 C
59369 Daisy Ramsey 68 C
78446 Kirk Sauter 92 A
18814 Leann Wynter 63 C
35239 Kadon Garratt 83 A
64461 Reggie Fiddler 95 A
26291 Aura Kava 97 A
61052 Carson Turzanski 81 A
Average 75.86667
Highest 97
Lowest 48
Create a new formatting rule that highlights only values that rank in the top 20% of the m
Apply a conditonal format to C4:C18 that highlights scores below average in green
Apply a conditional format to D4:D18 that highlights any grade that is an A in yellow
Apply a conditonal format to B4:B18 that highlights any duplicate student names in red
at rank in the top 20% of the marks in the range C4:C18
below average in green
rade that is an A in yellow
uplicate student names in red
Format as table etc
Student Number Name Surname Year of Study Bursary Residence
g03b3245 Jane Baker 4 TRUE Truro
g03l1234 Ingrid Brandt 1 TRUE Atherstone
g03m2531 Amanda Jonker 3 TRUE Canterbury
g03m5520 Debra Jordan 2 FALSE Dingemans
g03s4583 Adam King 1 FALSE Adamson
g03t1122 Steven Klassens 2 FALSE Livingstone
g04j8883 Jill Knight 3 TRUE Beit
g04k5401 Patricia Lubelwana 3 FALSE Atherstone
g04l0101 Thadile Lusu 4 TRUE Gavin Relly
g04m4593 David Mackie 1 FALSE Goldfields
g04m9241 Jillian Magwizi 1 TRUE Dingemans
g05b4572 Zukhanya Masingi 3 TRUE Dingemans
g05j0385 Siya Mdlongwa 4 FALSE Truro
g05k2070 Babalwa Meintjies 3 TRUE Beit
g05n9103 Tham Moyo 4 FALSE Gavin Relly
g06k0087 Luthando Ntsibande 2 FALSE Goldfields
g06m0034 Jake Oppie 1 FALSE Adamson
g06m0736 James Shaw 1 FALSE Winchester
g06o9067 Vusi Siwisa 4 TRUE Truro
g06s7256 Mamelo Thinyane 4 FALSE Mathews
Format the data above as a table
Insert two comments. How do you delete one of them?
Insert a textbox and enter some related text
Filter your newly formatted table to show only bursary students
Page 3
Format as table etc
y bursary students
Page 4
Name
Adam
Amanda
Babalwa
David
Debra
Ingrid
Jake
James
Jane
Jill
Jillian
Luthando
Mamelo
Patricia
Siya
Steven
Thadile
Tham
Vusi
Zukhanya
Name Surname
Ingrid Brandt
Jane Brandt
Amanda Jonker
Debra Jordan
Adam King
Steven Klassens
Jill Knight
Patricia Lubelwana
Thadile Lusu
David Mackie
Jillian Magwizi
Zukhanya Masingi
Siya Mdlongwa
Babalwa Meintjies
Tham Moyo
Luthando Ntsibande
Jake Oppie
James Shaw
Vusi Siwisa
Mamelo Thinyane
Student Number Name Surname Year of Study Bursary Residence
g05b4572 Ingrid Brandt 1 TRUE Atherstone
g03b3245 Jane Brandt 4 TRUE Truro
g04j8883 Amanda Jonker 3 TRUE Canterbury
g05j0385 Debra Jordan 2 FALSE Dingemans
g06k0087 Adam King 1 FALSE Adamson
g05k2070 Steven Klassens 2 FALSE Livingstone
g04k5401 Jill Knight 3 TRUE Beit
g04l0101 Patricia Lubelwana 3 FALSE Atherstone
g03l1234 Thadile Lusu 4 TRUE Gavin Relly
g06m0034 David Mackie 1 FALSE Goldfields
g06m0736 Jillian Magwizi 1 TRUE Dingemans
g04m4593 Zukhanya Masingi 3 TRUE Dingemans
g03m5520 Siya Mdlongwa 4 FALSE Truro
g04m9241 Babalwa Meintjies 3 TRUE Beit
g03m2531 Tham Moyo 4 FALSE Gavin Relly
g05n9103 Luthando Ntsibande 2 FALSE Goldfields
g06o9067 Jake Oppie 1 FALSE Adamson
g06s7256 James Shaw 1 FALSE Winchester
g03s4583 Vusi Siwisa 4 TRUE Truro
g03t1122 Mamelo Thinyane 4 FALSE Mathews
Practice sorting and filtering
Growth of subscriber base since inception of publication
January February March April May June
Number of
Subscribers 2006 1 6 11 16 21 26
Number of
Subscribers 2007 51 53 55 57 59 61
Copy the data above and paste it transposed below
ception of publication
July August SeptemberOctober November December Total Subscriber
figures by year
31 36 41 46 51 51 337
63 65 67 69 71 73 744