Assessment: Applied Activity 3 (7.

5%)

Name: Nithin Shajan

Student Number: A00256681

Date: Thursday, May 19, 2022

Grade: 0
7.5%)

22

/ 26
IMDB Movie Data *(from [Link]

Title Year Runtime (Minutes) Rating

(500) Days of Summer 2009 95 7.7
10 Cloverfield Lane 2016 104 7.2
10 Years 2011 100 6.1
12 Years a Slave 2013 134 8.1
127 Hours 2010 94 7.6
13 Hours 2016 144 7.3
1408 2007 104 6.8
17 Again 2009 102 6.4
2012 2009 158 5.8
20th Century Women 2016 119 7.4
21 2008 123 6.8
21 Jump Street 2012 110 7.2
22 Jump Street 2014 112 7.1
2307: Winter's Dream 2016 101 4
28 Weeks Later 2007 100 7
3 Days to Kill 2014 117 6.2
3 Idiots 2009 170 8.4
300 2006 117 7.7
300: Rise of an Empire 2014 102 6.2
31 2016 102 5.1
42 2013 128 7.5
5/25/1977 2007 113 7.1
50/50 2011 100 7.7
A Bigger Splash 2015 125 6.4
A Cure for Wellness 2016 146 6.5
A Dark Song 2016 100 6.1
A Good Year 2006 117 6.9
A Hologram for the King 2016 98 6.1
A Kind of Murder 2016 95 5.2
A Million Ways to Die in the West 2014 116 6.1
A Monster Calls 2016 108 7.5
A Quiet Passion 2016 125 7.2
A Street Cat Named Bob 2016 103 7.4
A United Kingdom 2016 111 6.8
A Walk Among the Tombstones 2014 114 6.5
About Time 2013 123 7.8
Absolutely Anything 2015 85 6
Across the Universe 2007 133 7.4
Adoration 2013 112 6.2
After Earth 2013 100 4.9
Ah-ga-ssi 2016 144 8.1

Alexander and the Terrible, Horrible, No Good, Very Bad Da 2014 81 6.2
Alice in Wonderland 2010 108 6.5
Alice Through the Looking Glass 2016 113 6.2
Aliens vs Predator - Requiem 2007 94 4.7
All Good Things 2010 101 6.3
All We Had 2016 105 5.8
Allegiant 2016 120 5.7
Allied 2016 124 7.1
Amateur Night 2016 92 5
American Gangster 2007 157 7.8
American Honey 2016 163 7
American Hustle 2013 138 7.3
American Pastoral 2016 108 6.1
American Reunion 2012 113 6.7
American Sniper 2014 133 7.3
American Wrestler: The Wizard 2016 117 6.9
Angry Birds 2016 97 6.3
Anna Karenina 2012 129 6.6
Annabelle 2014 99 5.4
Annie 2014 118 5.3
Anthropoid 2016 120 7.2
Antichrist 2009 108 6.6
Ant-Man 2015 117 7.3
Apocalypto 2006 139 7.8
Argo 2012 120 7.7
Arrival 2016 116 8
Assassin's Creed 2016 115 5.9
Atonement 2007 123 7.8
August Rush 2007 114 7.5
Australia 2008 165 6.6
Avatar 2009 162 7.8
Avengers: Age of Ultron 2015 141 7.4
Babel 2006 143 7.5
Bacalaureat 2016 128 7.5
Bad Moms 2016 100 6.2
Bahubali: The Beginning 2015 159 8.3
Ballerina 2016 89 6.8
Barbershop: The Next Cut 2016 111 5.9
Bastille Day 2016 92 6.3
Batman v Superman: Dawn of Justice 2016 151 6.7
Battleship 2012 131 5.8
Beautiful Creatures 2013 124 6.2
Before I Wake 2016 97 6.1
Before We Go 2014 95 6.9
Begin Again 2013 104 7.4
Below Her Mouth 2016 94 5.6
Ben-Hur 2016 123 5.7
Beowulf 2007 115 6.2
Beyond the Gates 2016 84 5.2
Big Hero 6 2014 102 7.8
Billy Lynn's Long Halftime Walk 2016 113 6.3
Birdman or (The Unexpected Virtue of Ignorance) 2014 119 7.8
Birth of the Dragon 2016 103 3.9
Black Mass 2015 123 6.9
Black Swan 2010 108 8
Blackhat 2015 133 5.4
Blair Witch 2016 89 5.1
Bleed for This 2016 117 6.8
Blended 2014 117 6.5
Blood Diamond 2006 143 8
Blood Father 2016 88 6.4
Blue Jasmine 2013 98 7.3
Blue Valentine 2010 112 7.4
Body of Lies 2008 128 7.1
Bone Tomahawk 2015 132 7.1
Bonjour Anne 2016 92 4.9
Boyhood 2014 165 7.9
Boyka: Undisputed IV 2016 86 7.4
Brave 2012 93 7.2
Bride Wars 2009 89 5.5
Bridesmaids 2011 125 6.8
Bridge of Spies 2015 142 7.6
Bridge to Terabithia 2007 96 7.2
Bridget Jones's Baby 2016 118 6.7
Brimstone 2016 148 7.1
Bronson 2008 92 7.1
Brooklyn 2015 117 7.5
Burnt 2015 101 6.6
Busanhaeng 2016 118 7.5
Café Society 2016 96 6.7
Captain America: Civil War 2016 147 7.9
Captain America: The First Avenger 2011 124 6.9
Captain America: The Winter Soldier 2014 136 7.8
Captain Fantastic 2016 118 7.9
Captain Phillips 2013 134 7.8
Carol 2015 118 7.2
Carrie 2013 100 5.9
Cars 2006 117 7.1
Cars 2 2011 106 6.2
Casino Royale 2006 144 8
Central Intelligence 2016 107 6.3
Centurion 2010 97 6.4
Chalk It Up 2016 90 4.8
Changeling 2008 141 7.8
Chappie 2015 120 6.9
Chef 2014 114 7.3
Child 44 2015 137 6.5
Children of Men 2006 109 7.9
Christine 2016 119 7
Chuck 2016 98 6.8
Cinderella 2015 105 7
City of Tiny Lights 2016 110 5.7
Clash of the Titans 2010 106 5.8
Closed Circuit 2013 96 6.2
Cloud Atlas 2012 172 7.5
Cloverfield 2008 85 7
Clown 2014 100 5.7
Coherence 2013 89 7.2
Collateral Beauty 2016 97 6.8
Collide 2016 99 5.7
Colonia 2015 106 7.1
Colossal 2016 109 6.4
Conan the Barbarian 2011 113 5.2
Concussion 2015 123 7.1
Contagion 2011 106 6.6
Contratiempo 2016 106 7.9
Coraline 2009 100 7.7
Couples Retreat 2009 113 5.5
Crawlspace 2016 88 5.3
Crazy, Stupid, Love. 2011 118 7.4
Creed 2015 133 7.6
Criminal 2016 113 6.3
Crimson Peak 2015 119 6.6
Custody 2016 104 6.9
Daddy's Home 2015 96 6.1
Dallas Buyers Club 2013 117 8
Dangal 2016 161 8.8
Dark Places 2015 113 6.2
Dark Shadows 2012 113 6.2
Dawn of the Planet of the Apes 2014 130 7.6
Dead Awake 2016 99 4.7
Deadpool 2016 108 8
Dear White People 2014 108 6.2
Dear Zindagi 2016 151 7.8
Death Proof 2007 113 7.1
Death Race 2008 105 6.4
Deepwater Horizon 2016 107 7.2
Deja Vu 2006 126 7
Demain tout commence 2016 118 7.4
Demolition 2015 101 7
Denial 2016 109 6.6
Despicable Me 2010 95 7.7
Despicable Me 2 2013 98 7.4
Detour 2016 97 6.3
Deuces 2016 87 6.6
Devil's Knot 2013 114 6.1
Diary of a Wimpy Kid 2010 94 6.2
Diary of a Wimpy Kid: Dog Days 2012 94 6.4
Diary of a Wimpy Kid: Rodrick Rules 2011 99 6.6
Dirty Grandpa 2016 102 6
Disaster Movie 2008 87 1.9
District 9 2009 112 8
Disturbia 2007 105 6.9
Divergent 2014 139 6.7
Django Unchained 2012 165 8.4
Doctor Strange 2016 115 7.6
Don Jon 2013 90 6.6
Don't Breathe 2016 88 7.2
Don't Fuck in the Woods 2016 73 2.7
Don't Think Twice 2016 92 6.8
Dope 2015 103 7.3
Dracula Untold 2014 92 6.3
Dragonball Evolution 2009 85 2.7
Dredd 2012 95 7.1
Drive 2011 100 7.8
Eagle Eye 2008 118 6.6
Eastern Promises 2007 100 7.7
Easy A 2010 92 7.1
Eddie the Eagle 2016 106 7.4
Edge of Tomorrow 2014 113 7.9
El secreto de sus ojos 2009 129 8.2
Elle 2016 130 7.2
Elysium 2013 109 6.6
En man som heter Ove 2015 116 7.7
Enchanted 2007 107 7.1
End of Watch 2012 109 7.7
Ender's Game 2013 114 6.7
Endless Love 2014 104 6.3
Enemy 2013 91 6.9
Entourage 2015 104 6.6
Equals 2015 101 6.1
Escape Plan 2013 115 6.7
Everest 2015 121 7.1
Everybody Wants Some!! 2016 117 7
Evil Dead 2013 91 6.5
Ex Machina 2014 108 7.7
Exodus: Gods and Kings 2014 150 6
Exposed 2016 102 4.2
Eye in the Sky 2015 102 7.3
Fallen 2016 91 5.6
Fantastic Beasts and Where to Find Them 2016 133 7.5
Fantastic Four 2015 100 4.3
Fantastic Mr. Fox 2009 87 7.8
Fast & Furious 2009 107 6.6
Fast Five 2011 131 7.3
Faster 2010 98 6.5
Fences 2016 139 7.3
Fifty Shades of Grey 2015 125 4.1
Filth 2013 97 7.1
Final Destination 5 2011 92 5.9
Final Girl 2015 90 4.7
Finding Dory 2016 97 7.4
Flight 2012 138 7.3
Florence Foster Jenkins 2016 111 6.9
Focus 2015 105 6.6
Folk Hero & Funny Guy 2016 88 5.6
Fool's Gold 2008 112 5.7
Footloose 2011 113 5.9
Forgetting Sarah Marshall 2008 111 7.2
Forushande 2016 124 8
Fracture 2007 113 7.2
Frantz 2016 113 7.5
Free Fire 2016 90 7
Free State of Jones 2016 139 6.9
Freedom Writers 2007 123 7.5
Friday the 13th 2009 97 5.6
Friend Request 2016 92 5.4
Friends with Benefits 2011 109 6.6
Frozen 2013 102 7.5
Funny Games 2007 111 6.5
Furious 6 2013 130 7.1
Furious Seven 2015 137 7.2
Fury 2014 134 7.6
G.I. Joe: Retaliation 2013 110 5.8
G.I. Joe: The Rise of Cobra 2009 118 5.8
Gangster Squad 2013 113 6.7
Genius 2016 104 6.5
Get Hard 2015 100 6
Ghost Rider 2007 114 5.2
Ghostbusters 2016 116 5.3
Gods of Egypt 2016 126 5.5
Godzilla 2014 123 6.4
Goksung 2016 156 7.5
Gold 2016 120 6.7
Gone Baby Gone 2007 114 7.7
Gone Girl 2014 149 8.1
Good Kids 2016 86 6.1
Goosebumps 2015 103 6.3
Gran Torino 2008 116 8.2
Gravity 2013 91 7.8
Green Lantern 2011 114 5.6
Green Room 2015 95 7
Grimsby 2016 83 6.2
Grindhouse 2007 191 7.6
Grown Ups 2010 102 6
Grown Ups 2 2013 101 5.4
Guardians of the Galaxy 2014 121 8.1
Hachi: A Dog's Tale 2009 93 8.1
Hacker 2016 95 6.3
Hacksaw Ridge 2016 139 8.2
Hail, Caesar! 2016 106 6.3
Hairspray 2007 117 6.7
Half of a Yellow Sun 2013 111 6.2
Hancock 2008 92 6.4
Hands of Stone 2016 111 6.6
Handsome Devil 2016 95 7.4
Hanna 2011 111 6.8
Happy Feet 2006 108 6.5
Hardcore Henry 2015 96 6.7
Harry Potter and the Deathly Hallows: Part 1 2010 146 7.7
Harry Potter and the Deathly Hallows: Part 2 2011 130 8.1
Harry Potter and the Half-Blood Prince 2009 153 7.5
Harry Potter and the Order of the Phoenix 2007 138 7.5
Hell or High Water 2016 102 7.7
Hellboy II: The Golden Army 2008 120 7
Hello, My Name Is Doris 2015 95 6.7
Her 2013 126 8
Hercules 2014 98 6
He's Just Not That Into You 2009 129 6.4
Hidden Figures 2016 127 7.8
High-Rise 2015 119 5.7
Home 2015 94 6.7
Horns 2013 120 6.5
Horrible Bosses 2011 98 6.9
Horrible Bosses 2 2014 108 6.3
Hostel: Part II 2007 94 5.5
Hot Fuzz 2007 121 7.9
Hotel Transylvania 2 2015 89 6.7
Hounds of Love 2016 108 6.7
How to Be Single 2016 110 6.1
How to Train Your Dragon 2010 98 8.1
How to Train Your Dragon 2 2014 102 7.9
Hugo 2011 126 7.5
Hunger 2008 96 7.6
Hunt for the Wilderpeople 2016 101 7.9
Hush 2016 81 6.6
I Am Legend 2007 101 7.2
I Am Number Four 2011 109 6.1
I Am the Pretty Thing That Lives in the House 2016 87 4.7
I Origins 2014 106 7.3
I Spit on Your Grave 2010 108 6.3
I, Daniel Blake 2016 100 7.9
I.T. 2016 95 5.4
Ice Age: Collision Course 2016 94 5.7
Idiocracy 2006 84 6.6
If I Stay 2014 107 6.8
Il racconto dei racconti - Tale of Tales 2015 133 6.4
Immortals 2011 110 6
Imperium 2016 109 6.5
In Bruges 2008 107 7.9
In Dubious Battle 2016 110 6.2
In the Heart of the Sea 2015 122 6.9
In Time 2011 109 6.7
Incendies 2010 131 8.2
Inception 2010 148 8.8
Independence Day: Resurgence 2016 120 5.3

Indiana Jones and the Kingdom of the Crystal Skull 2008 122 6.2
Indignation 2016 110 6.9
Inferno 2016 121 6.2
Inglourious Basterds 2009 153 8.3
Inherent Vice 2014 148 6.7
Inland Empire 2006 180 7
Inside Man 2006 129 7.6
Inside Out 2015 95 8.2
Insidious 2010 103 6.8
Insurgent 2015 119 6.3
Interstellar 2014 169 8.6
Into the Forest 2015 101 5.9
Into the Wild 2007 148 8.1
Into the Woods 2014 125 6
Iris 2016 99 6.1
Iron Man 2008 126 7.9
Iron Man 2 2010 124 7
Iron Man Three 2013 130 7.2
It Follows 2014 100 6.9
It's Only the End of the World 2016 97 7
Jack Reacher 2012 130 7
Jack Reacher: Never Go Back 2016 118 6.1
Jack Ryan: Shadow Recruit 2014 105 6.2
Jackie 2016 100 6.8
Jagten 2012 115 8.3
Jane Eyre 2011 120 7.4
Jason Bourne 2016 123 6.7
Jennifer's Body 2009 102 5.1
John Carter 2012 132 6.6
John Wick 2014 101 7.2
Joy 2015 124 6.6
Jumper 2008 88 6.1
Juno 2007 96 7.5
Jupiter Ascending 2015 127 5.3
Jurassic World 2015 124 7
Just Go with It 2011 117 6.4
Keanu 2016 100 6.3
Keeping Up with the Joneses 2016 105 5.8
Kick-Ass 2010 117 7.7
Kick-Ass 2 2013 103 6.6
Kickboxer: Vengeance 2016 90 4.9
Kicks 2016 80 6.1
Kimi no na wa 2016 106 8.6
King Cobra 2016 91 5.6
Kingsman: The Secret Service 2014 129 7.7
Knight of Cups 2015 118 5.7
Knock Knock 2015 99 4.9
Knocked Up 2007 129 7
Koe no katachi 2016 129 8.4
Kubo and the Two Strings 2016 101 7.9
Kung Fu Panda 2008 92 7.6
Kung Fu Panda 3 2016 95 7.2
Kynodontas 2009 94 7.3
La La Land 2016 128 8.3
La migliore offerta 2013 131 7.8
La tortue rouge 2016 80 7.6
La vie d'Adèle 2013 180 7.8
Lída Baarová 2016 106 5
Lady in the Water 2006 110 5.6
Lady Macbeth 2016 89 7.3
Lavender 2016 92 5.2
L'avenir 2016 102 7.1
Law Abiding Citizen 2009 109 7.4
Lawless 2012 116 7.3
Legend 2015 132 7
Legion 2010 100 5.2
Les Misérables 2012 158 7.6
Let Me In 2010 116 7.2
Let Me Make You a Martyr 2016 102 6.4
Let's Be Cops 2014 104 6.5
Life as We Know It 2010 114 6.6
Life of Pi 2012 127 7.9
Lights Out 2016 81 6.4
Limitless 2011 105 7.4
Lincoln 2012 150 7.4
Lion 2016 118 8.1
Little Miss Sunshine 2006 101 7.8
Live by Night 2016 129 6.4
Live Free or Die Hard 2007 128 7.2
Locke 2013 85 7.1
L'odyssée 2016 122 6.7
London Has Fallen 2016 99 5.9
Lone Survivor 2013 121 7.5
Looper 2012 119 7.4
Love 2015 135 6
Love & Friendship 2016 90 6.5
Love & Other Drugs 2010 112 6.7
Love, Rosie 2014 102 7.2
Lovesong 2016 84 6.4
Loving 2016 123 7.1
Lowriders 2016 99 6.3
Lucky Number Slevin 2006 110 7.8
Lucy 2014 89 6.4
Ma vie de Courgette 2016 66 7.8
Män som hatar kvinnor 2009 152 7.8
Macbeth 2015 113 6.7
Mad Max: Fury Road 2015 120 8.1
Magic Mike 2012 110 6.1
Magic Mike XXL 2015 115 5.7
Maleficent 2014 97 7
Mama 2013 100 6.2
Mamma Mia! 2008 108 6.4
Man Down 2015 90 5.8
Man of Steel 2013 143 7.1
Man on a Ledge 2012 102 6.6
Manchester by the Sea 2016 137 7.9
Marie Antoinette 2006 123 6.4
Martyrs 2008 99 7.1
Masterminds 2016 95 5.8
Maudie 2016 115 7.8
Max 2015 111 6.8
Max Steel 2016 92 4.6
Maze Runner: The Scorch Trials 2015 131 6.3
Me and Earl and the Dying Girl 2015 105 7.8
Me Before You 2016 106 7.4
Mean Dreams 2016 108 6.3
Mechanic: Resurrection 2016 98 5.6
Megamind 2010 95 7.3
Megan Is Missing 2011 85 4.9
Melancholia 2011 135 7.1
Men in Black 3 2012 106 6.8
Midnight in Paris 2011 94 7.7
Midnight Special 2016 112 6.7
Mike and Dave Need Wedding Dates 2016 98 6
Mindhorn 2016 89 6.4
Mine 2016 106 6
Minions 2015 91 6.4
Miracles from Heaven 2016 109 7
Miss Peregrine's Home for Peculiar Children 2016 127 6.7
Miss Sloane 2016 132 7.3
Mission: Impossible - Ghost Protocol 2011 132 7.4
Mission: Impossible - Rogue Nation 2015 131 7.4
Mission: Impossible III 2006 126 6.9
Moana 2016 107 7.7
Mommy 2014 139 8.1
Money Monster 2016 98 6.5
Moneyball 2011 133 7.6
Monster Trucks 2016 104 5.7
Monsters University 2013 104 7.3
Moon 2009 97 7.9
Moonlight 2016 111 7.5
Moonrise Kingdom 2012 94 7.8
Morgan 2016 92 5.8
Mother's Day 2016 118 5.6
Movie 43 2013 94 4.3
Mr. Brooks 2007 120 7.3
Mr. Church 2016 104 7.7
Mr. Nobody 2009 141 7.9
Mr. Right 2015 95 6.3
My Big Fat Greek Wedding 2 2016 94 6
Need for Speed 2014 132 6.5
Neighbors 2014 97 6.4
Neighbors 2: Sorority Rising 2016 92 5.7
Nerve 2016 96 6.6
Never Back Down 2008 110 6.6
Night at the Museum: Secret of the Tomb 2014 98 6.2
Nightcrawler 2014 118 7.9
Nine Lives 2016 87 5.3
No Country for Old Men 2007 122 8.1
No Escape 2015 103 6.8
No Strings Attached 2011 108 6.2
Noah 2014 138 5.8
Nocturnal Animals 2016 116 7.5

Norman: The Moderate Rise and Tragic Fall of a New York F 2016 118 7.1
Notorious 2009 122 6.7
Now You See Me 2013 115 7.3
Now You See Me 2 2016 129 6.5
Nymphomaniac: Vol. I 2013 117 7
Nymphomaniac: Vol. II 2013 123 6.7
Oblivion 2013 124 7
Ocean's Thirteen 2007 122 6.9
Oculus 2013 104 6.5
Office Christmas Party 2016 105 5.8
Old Boy 2013 104 5.8
Olympus Has Fallen 2013 119 6.5
One Day 2011 107 7
Only for One Night 2016 86 4.6
Orphan 2009 123 7
Ouija: Origin of Evil 2016 99 6.1
Out of the Furnace 2013 116 6.8
Oz the Great and Powerful 2013 130 6.3
P.S. I Love You 2007 126 7.1
Pacific Rim 2013 131 7
Pain & Gain 2013 129 6.5
Paint It Black 2016 96 8.3
Pan 2015 111 5.8
Pandorum 2009 108 6.8
Pan's Labyrinth 2006 118 8.2
Paper Towns 2015 109 6.3
Paris pieds nus 2016 83 6.8
Passengers 2016 116 7
Paterson 2016 118 7.5
Patriots Day 2016 133 7.4
Paul 2011 104 7

Percy Jackson & the Olympians: The Lightning Thief 2010 118 5.9
Percy Jackson: Sea of Monsters 2013 106 5.9
Perfetti sconosciuti 2016 97 7.7
Perfume: The Story of a Murderer 2006 147 7.5
Personal Shopper 2016 105 6.3
Pet 2016 94 5.7
Pete's Dragon 2016 102 6.8
Pineapple Express 2008 111 7
Piranha 3D 2010 88 5.5
Pirates of the Caribbean: At World's End 2007 169 7.1
Pirates of the Caribbean: Dead Man's Chest 2006 151 7.3
Pirates of the Caribbean: On Stranger Tides 2011 136 6.7
Pitch Perfect 2012 112 7.2
Pitch Perfect 2 2015 115 6.5
Pixels 2015 105 5.6
PK 2014 153 8.2
Planet Terror 2007 105 7.1
Point Break 2015 114 5.3
Pompeii 2014 105 5.5
Popstar: Never Stop Never Stopping 2016 87 6.7
Precious 2009 110 7.3
Predators 2010 107 6.4
Predestination 2014 97 7.5
Pride and Prejudice and Zombies 2016 108 5.8
Prince of Persia: The Sands of Time 2010 116 6.6
Prisoners 2013 153 8.1
Project X 2012 88 6.7
Prometheus 2012 124 7
Public Enemies 2009 140 7
Quantum of Solace 2008 106 6.6
Queen of Katwe 2016 124 7.4
Rambo 2008 92 7.1
Ratatouille 2007 111 8
Raw (II) 2016 99 7.5
Real Steel 2011 127 7.1
Realive 2016 112 5.9
RED 2010 111 7.1
Red Dawn 2012 93 5.4
Regression 2015 106 5.7
Relatos salvajes 2014 122 8.1
Remember Me 2010 113 7.2
Rescue Dawn 2006 120 7.3
Resident Evil: Afterlife 2010 97 5.9
Resident Evil: Retribution 2012 96 5.4
Resident Evil: The Final Chapter 2016 107 5.6
Revolutionary Road 2008 119 7.3
Riddick 2013 119 6.4
Rio 2011 96 6.9
Rise of the Planet of the Apes 2011 105 7.6
Robin Hood 2010 140 6.7
RoboCop 2014 117 6.2
Rock Dog 2016 90 5.8
Rock of Ages 2012 123 5.9
RocknRolla 2008 114 7.3
Rocky Balboa 2006 102 7.2
Rogue One 2016 133 7.9
Room 2015 118 8.2
Rules Don't Apply 2016 127 5.7
Rupture 2016 102 4.8
Rush 2013 123 8.1
Safe Haven 2013 115 6.7
Salt 2010 100 6.4
San Andreas 2015 114 6.1
Satanic 2016 85 3.7
Sausage Party 2016 89 6.3
Savages 2012 131 6.5
Saving Mr. Banks 2013 125 7.5
Scott Pilgrim vs. the World 2010 112 7.5
Scouts Guide to the Zombie Apocalypse 2015 93 6.3
Scream 4 2011 111 6.2
Search Party 2014 93 5.6
Secret in Their Eyes 2015 111 6.2
Self/less 2015 117 6.5
Selma 2014 128 7.5
Seven Pounds 2008 123 7.7
Seven Psychopaths 2012 110 7.2
Seventh Son 2014 102 5.5
Sex and the City 2008 145 5.5
Sex and the City 2 2010 146 4.3
Sex Tape 2014 94 5.1
Shame 2011 101 7.2
Sherlock Holmes 2009 128 7.6
Sherlock Holmes: A Game of Shadows 2011 129 7.5
She's Out of My League 2010 104 6.4
She's the Man 2006 105 6.4
Shin Gojira 2016 120 6.9
Shooter 2007 124 7.2
Shut In 2016 91 4.6
Shutter Island 2010 138 8.1
Sicario 2015 121 7.6
Silence 2016 161 7.3
Silent Hill 2006 125 6.6
Silver Linings Playbook 2012 122 7.8
Sin City: A Dame to Kill For 2014 102 6.5
Sing 2016 108 7.2
Sing Street 2016 106 8
Sinister 2012 110 6.8
Sisters 2015 118 6
Skyfall 2012 143 7.8
Sleeping Beauty 2011 101 5.3
Sleeping with Other People 2015 101 6.5
Sleight 2016 89 6
Slither 2006 95 6.5
Slumdog Millionaire 2008 120 8
Snakes on a Plane 2006 105 5.6
Snow White and the Huntsman 2012 127 6.1
Snowden 2016 134 7.3
Snowpiercer 2013 126 7
Solace 2015 101 6.4
Source Code 2011 93 7.5
Southpaw 2015 124 7.4
Spectral 2016 107 6.3
Spectre 2015 148 6.8
Spider-Man 3 2007 139 6.2
Split 2016 117 7.3
Spotlight 2015 128 8.1
Spring Breakers 2012 94 5.3
Spy 2015 119 7.1
Srpski film 2010 104 5.2
Stake Land 2010 98 6.5
Star Trek 2009 127 8
Star Trek Beyond 2016 122 7.1
Star Trek Into Darkness 2013 132 7.8
Star Wars: Episode VII - The Force Awakens 2015 136 8.1
Stardust 2007 127 7.7
Step Brothers 2008 98 6.9
Step Up 2006 104 6.5
Step Up 2: The Streets 2008 98 6.2
Steve Jobs 2015 122 7.2
Storks 2016 87 6.9
Straight Outta Compton 2015 147 7.9
Sucker Punch 2011 110 6.1
Suicide Squad 2016 123 6.2
Suite Française 2014 107 6.9
Sully 2016 96 7.5
Sunshine 2007 107 7.3
Super 2010 96 6.8
Super 8 2011 112 7.1
Superbad 2007 113 7.6
Superman Returns 2006 154 6.1

Sweeney Todd: The Demon Barber of Fleet Street 2007 116 7.4
Swiss Army Man 2016 97 7.1
Taare Zameen Par 2007 165 8.5
Take Me Home Tonight 2011 97 6.3
Taken 2008 93 7.8
Taken 3 2014 109 6
Tall Men 2016 133 3.2
Talladega Nights: The Ballad of Ricky Bobby 2006 108 6.6
Tangled 2010 100 7.8
Ted 2012 106 7
Ted 2 2015 115 6.3
Teenage Mutant Ninja Turtles 2014 101 5.9

Teenage Mutant Ninja Turtles: Out of the Shadows 2016 112 6

Terminator Genisys 2015 126 6.5
Terminator Salvation 2009 115 6.6
Texas Chainsaw 3D 2013 92 4.8
That Awkward Moment 2014 94 6.2
The 5th Wave 2016 112 5.2
The 9th Life of Louis Drax 2016 108 6.3
The Accountant 2016 128 7.4
The Adjustment Bureau 2011 106 7.1
The Age of Adaline 2015 112 7.2
The Age of Shadows 2016 140 7.2
The Amazing Spider-Man 2012 136 7
The Amazing Spider-Man 2 2014 142 6.7

The Assassination of Jesse James by the Coward Robert For 2007 160 7.5
The Assignment 2016 95 4.5
The A-Team 2010 117 6.8
The Autopsy of Jane Doe 2016 86 6.8
The Avengers 2012 143 8.1
The Babadook 2014 93 6.8
The Babysitters 2007 88 5.7
The Bad Batch 2016 118 6.1
The Belko Experiment 2016 89 6.3
The Best of Me 2014 118 6.7
The BFG 2016 117 6.4
The Big Short 2015 130 7.8
The Black Room 2016 91 3.9
The Blackcoat's Daughter 2015 93 5.6
The Blind Side 2009 129 7.7
The Book of Eli 2010 118 6.9
The Book of Life 2014 95 7.3
The Boss 2016 99 5.4
The Bourne Legacy 2012 135 6.7
The Bourne Ultimatum 2007 115 8.1
The Boy 2016 97 6
The Boy in the Striped Pyjamas 2008 94 7.8
The Boy Next Door 2015 91 4.6
The Break-Up 2006 106 5.8
The Butler 2013 132 7.2
The Cabin in the Woods 2012 95 7
The Choice 2016 111 6.6
The Comedian 2016 120 5.4
The Conjuring 2013 112 7.5
The Conjuring 2 2016 134 7.4
The Counselor 2013 117 5.3
The Curious Case of Benjamin Button 2008 166 7.8
The Da Vinci Code 2006 149 6.6
The Danish Girl 2015 119 7
The Dark Knight 2008 152 9
The Dark Knight Rises 2012 164 8.5
The Daughter 2015 96 6.7
The Departed 2006 151 8.5
The Descendants 2011 115 7.3
The Devil Wears Prada 2006 109 6.8
The Dictator 2012 83 6.4
The Disappointments Room 2016 85 3.9
The Do-Over 2016 108 5.7
The Dressmaker 2015 119 7.1
The Drop 2014 106 7.1
The DUFF 2015 101 6.5
The Edge of Seventeen 2016 104 7.4
The Equalizer 2014 132 7.2
The Escort 2016 88 6
The Exception 2016 107 7.7
The Expendables 2010 103 6.5
The Expendables 2 2012 103 6.6
The Expendables 3 2014 126 6.1
The Fall 2006 117 7.9
The Family 2013 111 6.3
The Fast and the Furious: Tokyo Drift 2006 104 6
The Fault in Our Stars 2014 126 7.8
The Fighter 2010 116 7.8
The Finest Hours 2016 117 6.8
The First Time 2012 95 6.9
The Founder 2016 115 7.2
The Fountain 2006 96 7.3
The Gambler 2014 111 6
The Ghost Writer 2010 128 7.2
The Gift 2015 108 7.1
The Girl Next Door 2007 91 6.7
The Girl on the Train 2016 112 6.5
The Girl with All the Gifts 2016 111 6.7
The Girl with the Dragon Tattoo 2011 158 7.8
The Giver 2014 97 6.5
The Golden Compass 2007 113 6.1
The Grand Budapest Hotel 2014 99 8.1
The Great Gatsby 2013 143 7.3
The Great Wall 2016 103 6.1
The Green Inferno 2013 100 5.4
The Guest 2014 100 6.7
The Gunman 2015 115 5.8
The Hangover 2009 100 7.8
The Happening 2008 91 5
The Hateful Eight 2015 187 7.8
The Headhunter's Calling 2016 108 6.9
The Heartbreak Kid 2007 116 5.8
The Heat 2013 117 6.6
The Help 2011 146 8.1
The Hills Have Eyes 2006 107 6.4
The Hobbit: An Unexpected Journey 2012 169 7.9
The Hobbit: The Battle of the Five Armies 2014 144 7.4
The Hobbit: The Desolation of Smaug 2013 161 7.9
The Hollars 2016 88 6.5
The Host 2006 120 7
The Host 2013 125 5.9
The House Bunny 2008 97 5.5
The Human Centipede (First Sequence) 2009 92 4.4
The Hunger Games 2012 142 7.2
The Hunger Games: Catching Fire 2013 146 7.6
The Hunger Games: Mockingjay - Part 1 2014 123 6.7
The Hunger Games: Mockingjay - Part 2 2015 137 6.6
The Huntsman: Winter's War 2016 114 6.1
The Hurt Locker 2008 131 7.6
The Illusionist 2006 110 7.6
The Imaginarium of Doctor Parnassus 2009 123 6.8
The Imitation Game 2014 114 8.1
The imposible 2012 114 7.6
The Incredible Hulk 2008 112 6.8
The Infiltrator 2016 127 7.1
The Intent 2016 104 3.5
The Intern 2015 121 7.1
The Internship 2013 119 6.3
The Interview 2014 112 6.6
The Intouchables 2011 112 8.6
The Invitation 2015 100 6.7
The Judge 2014 141 7.4
The Jungle Book 2016 106 7.5
The Karate Kid 2010 140 6.2
The Kings of Summer 2013 95 7.2
The King's Speech 2010 118 8
The Last Airbender 2010 103 4.2
The Last Face 2016 130 3.7
The Last Witch Hunter 2015 106 6
The Legend of Tarzan 2016 110 6.3
The Lego Movie 2014 100 7.8
The Levelling 2016 83 6.4
The Light Between Oceans 2016 133 7.2
The Lives of Others 2006 137 8.5
The Lobster 2015 119 7.1
The Loft 2014 108 6.3
The Lone Ranger 2013 150 6.5
The Longest Ride 2015 123 7.1
The Lost City of Z 2016 141 7.1
The Love Witch 2016 120 6.2
The Lovely Bones 2009 135 6.7
The Lucky One 2012 101 6.5
The Magnificent Seven 2016 132 6.9
The Man from U.N.C.L.E. 2015 116 7.3
The Man Who Knew Infinity 2015 108 7.2
The Martian 2015 144 8
The Master 2012 144 7.1
The Matchbreaker 2016 94 5.5
The Maze Runner 2014 113 6.8
The Midnight Meat Train 2008 98 6.1
The Mist 2007 126 7.2
The Mortal Instruments: City of Bones 2013 130 5.9
The Mummy: Tomb of the Dragon Emperor 2008 112 5.2
The Neighbor 2016 87 5.8
The Neon Demon 2016 118 6.2
The Nice Guys 2016 116 7.4
The Other Boleyn Girl 2008 115 6.7
The Other Guys 2010 107 6.7
The Other Woman 2014 109 6
The Perks of Being a Wallflower 2012 102 8
The Place Beyond the Pines 2012 140 7.3
The Prestige 2006 130 8.5
The Princess and the Frog 2009 97 7.1
The Promise 2016 133 5.9
The Proposal 2009 108 6.7
The Purge 2013 85 5.7
The Purge: Election Year 2016 109 6
The Pursuit of Happyness 2006 117 8
The Revenant 2015 156 8
The Ridiculous 6 2015 119 4.8
The Rise of the Krays 2015 110 5.1
The Road 2009 111 7.3
The Sea of Trees 2015 110 5.9
The Secret Life of Pets 2016 87 6.6
The Secret Life of Walter Mitty 2013 114 7.3
The Secret Scripture 2016 108 6.8
The Shallows 2016 86 6.4
The Siege of Jadotville 2016 108 7.3
The Skin I Live In 2011 120 7.6
The Social Network 2010 120 7.7
The Spectacular Now 2013 95 7.1
The Stakelander 2016 81 5.3
The Stanford Prison Experiment 2015 122 6.9
The Strangers 2008 86 6.2
The Survivalist 2015 104 6.3
The Theory of Everything 2014 123 7.7
The Thinning 2016 81 6
The Three Musketeers 2011 110 5.8
The Ticket 2016 97 5.4
The Town 2010 125 7.6
The Tree of Life 2011 139 6.8
The Twilight Saga: Breaking Dawn - Part 1 2011 117 4.9
The Twilight Saga: Breaking Dawn - Part 2 2012 115 5.5
The Twilight Saga: Eclipse 2010 124 4.9
The Ugly Truth 2009 96 6.5
The Visit 2015 94 6.2
The Void 2016 90 5.8
The VVitch: A New-England Folktale 2015 92 6.8
The Walk 2015 123 7.3
The Warriors Gate 2016 108 5.3
The Whole Truth 2016 93 6.1
The Wolf of Wall Street 2013 180 8.2
The Wolverine 2013 126 6.7
The World's End 2013 109 7
Their Finest 2016 117 7
There Will Be Blood 2007 158 8.1
This Beautiful Fantastic 2016 100 6.9
This Is 40 2012 134 6.2
This Is the End 2013 107 6.6
This Means War 2012 103 6.3
Thor 2011 115 7
Thor: The Dark World 2013 112 7
Tinker Tailor Soldier Spy 2011 122 7.1
To Rome with Love 2012 112 6.3
Tomorrowland 2015 130 6.5
Toni Erdmann 2016 162 7.6
Total Recall 2012 118 6.3
Toy Story 3 2010 103 8.3
Tracktown 2016 88 5.9
Trainwreck 2015 125 6.3
Tramps 2016 82 6.5
Trance 2013 101 7
Transcendence 2014 119 6.3
Transformers 2007 144 7.1
Transformers: Age of Extinction 2014 165 5.7
Transformers: Dark of the Moon 2011 154 6.3
Transformers: Revenge of the Fallen 2009 150 6
Transpecos 2016 86 5.8
Triangle 2009 99 6.9
Triple 9 2016 115 6.3
Trolls 2016 92 6.5
Tron 2010 125 6.8
Tropic Thunder 2008 107 7
True Crimes 2016 92 7.3
True Grit 2010 110 7.6
Trust 2010 106 7
Turbo Kid 2015 93 6.7
Tusk 2014 102 5.4
Twilight 2008 122 5.2
Twin Peaks: The Missing Pieces 2014 91 8.1
Unbroken 2014 137 7.2
Under the Skin 2013 108 6.3
Underworld Awakening 2012 88 6.4
Underworld: Blood Wars 2016 91 5.8
Underworld: Rise of the Lycans 2009 92 6.6
Unfriended 2014 83 5.6
Unknown 2011 113 6.9
Unstoppable 2010 98 6.8
Up 2009 96 8.3
Up in the Air 2009 109 7.4
USS Indianapolis: Men of Courage 2016 128 5.2
Vacation 2015 99 6.1
Vampire Academy 2014 104 5.6
Vicky Cristina Barcelona 2008 96 7.1
Victor Frankenstein 2015 110 6
Viking 2016 133 4.7
Vincent N Roxxy 2016 110 5.5
Viral 2016 85 5.5
Wakefield 2016 106 7.5
WALL·E 2008 98 8.4
Wanted 2008 110 6.7
War Dogs 2016 114 7.1
War on Everyone 2016 98 5.9
Warcraft 2016 123 7
Warm Bodies 2013 98 6.9
Warrior 2011 140 8.2
Watchmen 2009 162 7.6
We Are Your Friends 2015 96 6.2
We Need to Talk About Kevin 2011 112 7.5
We're the Millers 2013 110 7
What If 2013 98 6.8
What to Expect When You're Expecting 2012 110 5.7
What We Do in the Shadows 2014 86 7.6
What's Your Number? 2011 106 6.1
Whiplash 2014 107 8.5
Whiskey Tango Foxtrot 2016 112 6.6
Whisky Galore 2016 98 5
White Girl 2016 88 5.8
White House Down 2013 131 6.4
Why Him? 2016 111 6.3
Wild 2014 115 7.1
Winter's Bone 2010 100 7.2
Wolves at the Door 2016 73 4.6
Woman in Gold 2015 109 7.3
World War Z 2013 116 7
Wrath of the Titans 2012 99 5.8
Wrecker 2015 83 3.5
Wreck-It Ralph 2012 101 7.8
X: First Class 2011 132 7.8
X-Men Origins: Wolverine 2009 107 6.7
X-Men: Apocalypse 2016 144 7.1
X-Men: Days of Future Past 2014 132 8
X-Men: The Last Stand 2006 104 6.7
Yoga Hosers 2016 88 4.3
You Don't Mess with the Zohan 2008 113 5.5
Your Highness 2011 102 5.6
Youth 2015 124 7.3
Zack and Miri Make a Porno 2008 101 6.6
Zero Dark Thirty 2012 157 7.4
Zipper 2015 103 5.7
Zodiac 2007 157 7.7
Zombieland 2009 88 7.7
Zoolander 2 2016 102 4.7
Zootopia 2016 108 8.1
 Applied Activity 3 (7.5%)

Instructions (please do not erase

Use the VLOOKUP function in Q
Revenue (Millions) Title You must use A4:E1004 as
32.39 (500) Days of Summer
71.9 10 Cloverfield Lane
0.2 10 Years Movie Title
56.67 12 Years a Slave
18.33 127 Hours Use the VLOOKUP function in Q1
52.82 13 Hours use A4:E1004 as the table ar
71.98 1408
64.15 17 Again
166.11 2012 Movie Title
5.66 20th Century Women
81.16 21
138.45 21 Jump Street Use the VLOOKUP function in Q
that is listed in the table. Add y
191.62 22 Jump Street set the lookup_va
20.76 2307: Winter's Dream
28.64 28 Weeks Later
30.69 3 Days to Kill Movie Title
6.52 3 Idiots
210.59 300
106.37 300: Rise of an Empire Find the maximum Revenue (M
below to the title of the movie
0.78 31 then set the lookup_value
95 42
5/25/1977
34.96 50/50 Max Revenue (Millions)
1.98 A Bigger Splash
8.1 A Cure for Wellness
A Dark Song Select C4:C1004, click the Con
7.46 A Good Year 10% and en
4.2 A Hologram for the King
0 A Kind of Murder
42.62 A Million Ways to Die in the West
3.73 A Monster Calls
1.08 A Quiet Passion
0.04 A Street Cat Named Bob
3.9 A United Kingdom
25.98 A Walk Among the Tombstones
15.29 About Time
Absolutely Anything
24.34 Across the Universe
0.32 Adoration
60.52 After Earth

Select D4:D1004, click the Cond

and ente
 2.01 Ah-ga-ssi
Select D4:D1004, click the Cond
Alexander and the Terrible, Horrible, No Good, Very and ente
66.95 Bad Day
334.19 Alice in Wonderland
77.04 Alice Through the Looking Glass
41.8 Aliens vs Predator - Requiem
0.58 All Good Things
All We Had
66 Allegiant
40.07 Allied
Amateur Night
130.13 American Gangster
0.66 American Honey
150.12 American Hustle
American Pastoral
56.72 American Reunion
350.12 American Sniper Select E4:E1004, click the Cond
American Wrestler: The Wizard
107.51 Angry Birds
12.8 Anna Karenina
84.26 Annabelle
85.91 Annie
2.96 Anthropoid
0.4 Antichrist
180.19 Ant-Man
50.86 Apocalypto
136.02 Argo
100.5 Arrival
54.65 Assassin's Creed
50.92 Atonement
31.66 August Rush
49.55 Australia
760.51 Avatar
458.99 Avengers: Age of Ultron
34.3 Babel
0.13 Bacalaureat
113.08 Bad Moms
6.5 Bahubali: The Beginning
Ballerina
54.01 Barbershop: The Next Cut
0.04 Bastille Day
330.25 Batman v Superman: Dawn of Justice
65.17 Battleship
19.45 Beautiful Creatures
Before I Wake
 0.04 Before We Go
16.17 Begin Again
Below Her Mouth
26.38 Ben-Hur
82.16 Beowulf
Beyond the Gates
222.49 Big Hero 6
1.72 Billy Lynn's Long Halftime Walk
42.34 Birdman or (The Unexpected Virtue of Ignorance)
93.05 Birth of the Dragon
62.56 Black Mass
106.95 Black Swan
7.1 Blackhat
20.75 Blair Witch
4.85 Bleed for This
46.28 Blended
57.37 Blood Diamond
93.95 Blood Father
33.4 Blue Jasmine
9.7 Blue Valentine
39.38 Body of Lies
66.01 Bone Tomahawk
0.32 Bonjour Anne
25.36 Boyhood
Boyka: Undisputed IV
237.28 Brave
58.72 Bride Wars
169.08 Bridesmaids
72.31 Bridge of Spies
82.23 Bridge to Terabithia
24.09 Bridget Jones's Baby
Brimstone
0.1 Bronson
38.32 Brooklyn
13.65 Burnt
2.13 Busanhaeng
11.08 Café Society
408.08 Captain America: Civil War
176.64 Captain America: The First Avenger
259.75 Captain America: The Winter Soldier
5.88 Captain Fantastic
107.1 Captain Phillips
0.25 Carol
35.27 Carrie
244.05 Cars
191.45 Cars 2
167.01 Casino Royale
127.38 Central Intelligence
0.12 Centurion
Chalk It Up
35.71 Changeling
31.57 Chappie
31.24 Chef
1.21 Child 44
35.29 Children of Men
0.3 Christine
0.11 Chuck
201.15 Cinderella
City of Tiny Lights
163.19 Clash of the Titans
5.73 Closed Circuit
27.1 Cloud Atlas
80.03 Cloverfield
0.05 Clown
0.07 Coherence
30.98 Collateral Beauty
2.2 Collide
Colonia
2.87 Colossal
21.27 Conan the Barbarian
34.53 Concussion
75.64 Contagion
Contratiempo
75.28 Coraline
109.18 Couples Retreat
Crawlspace
84.24 Crazy, Stupid, Love.
109.71 Creed
14.27 Criminal
31.06 Crimson Peak
Custody
150.32 Daddy's Home
27.3 Dallas Buyers Club
11.15 Dangal
Dark Places
79.71 Dark Shadows
208.54 Dawn of the Planet of the Apes
0.01 Dead Awake
363.02 Deadpool
4.4 Dear White People
 1.4 Dear Zindagi
Death Proof
36.06 Death Race
61.28 Deepwater Horizon
Deja Vu
Demain tout commence
1.82 Demolition
4.07 Denial
251.5 Despicable Me
368.05 Despicable Me 2
Detour
Deuces
Devil's Knot
64 Diary of a Wimpy Kid
49 Diary of a Wimpy Kid: Dog Days
52.69 Diary of a Wimpy Kid: Rodrick Rules
35.54 Dirty Grandpa
14.17 Disaster Movie
115.65 District 9
80.05 Disturbia
150.83 Divergent
162.8 Django Unchained
232.6 Doctor Strange
24.48 Don Jon
89.21 Don't Breathe
Don't Fuck in the Woods
4.42 Don't Think Twice
17.47 Dope
55.94 Dracula Untold
9.35 Dragonball Evolution
13.4 Dredd
35.05 Drive
101.11 Eagle Eye
17.11 Eastern Promises
58.4 Easy A
15.79 Eddie the Eagle
100.19 Edge of Tomorrow
20.17 El secreto de sus ojos
Elle
Elysium
3.36 En man som heter Ove
127.71 Enchanted
40.98 End of Watch
61.66 Ender's Game
23.39 Endless Love
 1.01 Enemy
32.36 Entourage
0.03 Equals
25.12 Escape Plan
43.25 Everest
3.37 Everybody Wants Some!!
54.24 Evil Dead
25.44 Ex Machina
65.01 Exodus: Gods and Kings
Exposed
18.7 Eye in the Sky
Fallen
234.02 Fantastic Beasts and Where to Find Them
56.11 Fantastic Four
21 Fantastic Mr. Fox
155.02 Fast & Furious
209.81 Fast Five
23.23 Faster
57.64 Fences
166.15 Fifty Shades of Grey
0.03 Filth
42.58 Final Destination 5
Final Girl
486.29 Finding Dory
93.75 Flight
27.37 Florence Foster Jenkins
53.85 Focus
Folk Hero & Funny Guy
70.22 Fool's Gold
51.78 Footloose
62.88 Forgetting Sarah Marshall
3.4 Forushande
39 Fracture
0.86 Frantz
1.8 Free Fire
Free State of Jones
36.58 Freedom Writers
65 Friday the 13th
64.03 Friend Request
55.8 Friends with Benefits
400.74 Frozen
1.29 Funny Games
238.67 Furious 6
350.03 Furious Seven
85.71 Fury
122.51 G.I. Joe: Retaliation
150.17 G.I. Joe: The Rise of Cobra
46 Gangster Squad
1.36 Genius
90.35 Get Hard
115.8 Ghost Rider
128.34 Ghostbusters
31.14 Gods of Egypt
200.66 Godzilla
0.79 Goksung
7.22 Gold
20.3 Gone Baby Gone
167.74 Gone Girl
Good Kids
80.02 Goosebumps
148.09 Gran Torino
274.08 Gravity
116.59 Green Lantern
3.22 Green Room
6.86 Grimsby
25.03 Grindhouse
162 Grown Ups
133.67 Grown Ups 2
333.13 Guardians of the Galaxy
Hachi: A Dog's Tale
Hacker
67.12 Hacksaw Ridge
30 Hail, Caesar!
118.82 Hairspray
0.05 Half of a Yellow Sun
227.95 Hancock
4.71 Hands of Stone
Handsome Devil
40.25 Hanna
197.99 Happy Feet
9.24 Hardcore Henry
294.98 Harry Potter and the Deathly Hallows: Part 1
380.96 Harry Potter and the Deathly Hallows: Part 2
301.96 Harry Potter and the Half-Blood Prince
292 Harry Potter and the Order of the Phoenix
26.86 Hell or High Water
75.75 Hellboy II: The Golden Army
14.44 Hello, My Name Is Doris
25.56 Her
72.66 Hercules
 He's Just Not That Into You
169.27 Hidden Figures
0.34 High-Rise
177.34 Home
0.16 Horns
117.53 Horrible Bosses
54.41 Horrible Bosses 2
17.54 Hostel: Part II
23.62 Hot Fuzz
169.69 Hotel Transylvania 2
Hounds of Love
46.81 How to Be Single
217.39 How to Train Your Dragon
177 How to Train Your Dragon 2
73.82 Hugo
0.15 Hunger
5.2 Hunt for the Wilderpeople
Hush
256.39 I Am Legend
55.09 I Am Number Four
I Am the Pretty Thing That Lives in the House
0.33 I Origins
0.09 I Spit on Your Grave
I, Daniel Blake
I.T.
64.06 Ice Age: Collision Course
0.44 Idiocracy
50.46 If I Stay
0.08 Il racconto dei racconti - Tale of Tales
83.5 Immortals
Imperium
7.76 In Bruges
In Dubious Battle
24.99 In the Heart of the Sea
37.55 In Time
6.86 Incendies
292.57 Inception
103.14 Independence Day: Resurgence

317.01 Indiana Jones and the Kingdom of the Crystal Skull

3.4 Indignation
34.26 Inferno
120.52 Inglourious Basterds
8.09 Inherent Vice
Inland Empire
 88.5 Inside Man
356.45 Inside Out
53.99 Insidious
130 Insurgent
187.99 Interstellar
0.01 Into the Forest
18.35 Into the Wild
128 Into the Woods
Iris
318.3 Iron Man
312.06 Iron Man 2
408.99 Iron Man Three
14.67 It Follows
It's Only the End of the World
58.68 Jack Reacher
58.4 Jack Reacher: Never Go Back
50.55 Jack Ryan: Shadow Recruit
13.96 Jackie
0.61 Jagten
11.23 Jane Eyre
162.16 Jason Bourne
16.2 Jennifer's Body
73.06 John Carter
43 John Wick
56.44 Joy
80.17 Jumper
143.49 Juno
47.38 Jupiter Ascending
652.18 Jurassic World
103.03 Just Go with It
20.57 Keanu
14.9 Keeping Up with the Joneses
48.04 Kick-Ass
28.75 Kick-Ass 2
131.56 Kickboxer: Vengeance
0.15 Kicks
4.68 Kimi no na wa
0.03 King Cobra
128.25 Kingsman: The Secret Service
0.56 Knight of Cups
0.03 Knock Knock
148.73 Knocked Up
Koe no katachi
48.02 Kubo and the Two Strings
215.4 Kung Fu Panda
143.52 Kung Fu Panda 3
0.11 Kynodontas
151.06 La La Land
0.09 La migliore offerta
0.92 La tortue rouge
2.2 La vie d'Adèle
Lída Baarová
42.27 Lady in the Water
Lady Macbeth
Lavender
0.28 L'avenir
73.34 Law Abiding Citizen
37.4 Lawless
1.87 Legend
40.17 Legion
148.78 Les Misérables
12.13 Let Me In
Let Me Make You a Martyr
82.39 Let's Be Cops
53.36 Life as We Know It
124.98 Life of Pi
67.24 Lights Out
79.24 Limitless
182.2 Lincoln
51.69 Lion
59.89 Little Miss Sunshine
10.38 Live by Night
134.52 Live Free or Die Hard
1.36 Locke
L'odyssée
62.4 London Has Fallen
125.07 Lone Survivor
66.47 Looper
Love
14.01 Love & Friendship
32.36 Love & Other Drugs
0.01 Love, Rosie
0.01 Lovesong
7.7 Loving
4.21 Lowriders
22.49 Lucky Number Slevin
126.55 Lucy
0.29 Ma vie de Courgette
10.1 Män som hatar kvinnor
Macbeth
153.63 Mad Max: Fury Road
113.71 Magic Mike
Magic Mike XXL
241.41 Maleficent
71.59 Mama
143.7 Mamma Mia!
Man Down
291.02 Man of Steel
18.6 Man on a Ledge
47.7 Manchester by the Sea
15.96 Marie Antoinette
Martyrs
17.36 Masterminds
Maudie
42.65 Max
3.77 Max Steel
81.69 Maze Runner: The Scorch Trials
6.74 Me and Earl and the Dying Girl
56.23 Me Before You
Mean Dreams
21.2 Mechanic: Resurrection
148.34 Megamind
Megan Is Missing
3.03 Melancholia
179.02 Men in Black 3
56.82 Midnight in Paris
3.71 Midnight Special
46.01 Mike and Dave Need Wedding Dates
Mindhorn
Mine
336.03 Minions
61.69 Miracles from Heaven
87.24 Miss Peregrine's Home for Peculiar Children
3.44 Miss Sloane
209.36 Mission: Impossible - Ghost Protocol
195 Mission: Impossible - Rogue Nation
133.38 Mission: Impossible III
248.75 Moana
3.49 Mommy
41.01 Money Monster
75.61 Moneyball
33.04 Monster Trucks
268.49 Monsters University
5.01 Moon
27.85 Moonlight
 45.51 Moonrise Kingdom
3.91 Morgan
32.46 Mother's Day
8.83 Movie 43
28.48 Mr. Brooks
0.69 Mr. Church
Mr. Nobody
0.03 Mr. Right
59.57 My Big Fat Greek Wedding 2
43.57 Need for Speed
150.06 Neighbors
55.29 Neighbors 2: Sorority Rising
38.56 Nerve
24.85 Never Back Down
113.73 Night at the Museum: Secret of the Tomb
32.28 Nightcrawler
19.64 Nine Lives
74.27 No Country for Old Men
27.29 No Escape
70.63 No Strings Attached
101.16 Noah
10.64 Nocturnal Animals
Norman: The Moderate Rise and Tragic Fall of a New
2.27 York Fixer
36.84 Notorious
117.7 Now You See Me
65.03 Now You See Me 2
0.79 Nymphomaniac: Vol. I
0.33 Nymphomaniac: Vol. II
89.02 Oblivion
117.14 Ocean's Thirteen
27.69 Oculus
54.73 Office Christmas Party
Old Boy
98.9 Olympus Has Fallen
13.77 One Day
Only for One Night
41.57 Orphan
34.9 Ouija: Origin of Evil
11.33 Out of the Furnace
234.9 Oz the Great and Powerful
53.68 P.S. I Love You
101.79 Pacific Rim
49.87 Pain & Gain
Paint It Black
 34.96 Pan
10.33 Pandorum
37.62 Pan's Labyrinth
31.99 Paper Towns
Paris pieds nus
100.01 Passengers
2.14 Paterson
31.86 Patriots Day
37.37 Paul

88.76 Percy Jackson & the Olympians: The Lightning Thief

68.56 Percy Jackson: Sea of Monsters
Perfetti sconosciuti
2.21 Perfume: The Story of a Murderer
1.29 Personal Shopper
Pet
76.2 Pete's Dragon
87.34 Pineapple Express
25 Piranha 3D
309.4 Pirates of the Caribbean: At World's End
423.03 Pirates of the Caribbean: Dead Man's Chest
241.06 Pirates of the Caribbean: On Stranger Tides
65 Pitch Perfect
183.44 Pitch Perfect 2
78.75 Pixels
10.57 PK
Planet Terror
28.77 Point Break
23.22 Pompeii
9.39 Popstar: Never Stop Never Stopping
47.54 Precious
52 Predators
Predestination
10.91 Pride and Prejudice and Zombies
90.76 Prince of Persia: The Sands of Time
60.96 Prisoners
54.72 Project X
126.46 Prometheus
97.03 Public Enemies
168.37 Quantum of Solace
8.81 Queen of Katwe
42.72 Rambo
206.44 Ratatouille
0.51 Raw (II)
85.46 Real Steel
 Realive
90.36 RED
44.8 Red Dawn
0.05 Regression
3.08 Relatos salvajes
19.06 Remember Me
5.48 Rescue Dawn
60.13 Resident Evil: Afterlife
42.35 Resident Evil: Retribution
26.84 Resident Evil: The Final Chapter
22.88 Revolutionary Road
42 Riddick
143.62 Rio
176.74 Rise of the Planet of the Apes
105.22 Robin Hood
58.61 RoboCop
9.4 Rock Dog
38.51 Rock of Ages
5.69 RocknRolla
70.27 Rocky Balboa
532.17 Rogue One
14.68 Room
3.65 Rules Don't Apply
Rupture
26.9 Rush
71.35 Safe Haven
118.31 Salt
155.18 San Andreas
Satanic
97.66 Sausage Party
47.31 Savages
83.3 Saving Mr. Banks
31.49 Scott Pilgrim vs. the World
3.64 Scouts Guide to the Zombie Apocalypse
38.18 Scream 4
Search Party
Secret in Their Eyes
12.28 Self/less
52.07 Selma
69.95 Seven Pounds
14.99 Seven Psychopaths
17.18 Seventh Son
152.64 Sex and the City
95.33 Sex and the City 2
38.54 Sex Tape
 4 Shame
209.02 Sherlock Holmes
186.83 Sherlock Holmes: A Game of Shadows
31.58 She's Out of My League
2.34 She's the Man
1.91 Shin Gojira
46.98 Shooter
6.88 Shut In
127.97 Shutter Island
46.88 Sicario
7.08 Silence
46.98 Silent Hill
132.09 Silver Linings Playbook
13.75 Sin City: A Dame to Kill For
270.32 Sing
3.23 Sing Street
48.06 Sinister
87.03 Sisters
304.36 Skyfall
0.03 Sleeping Beauty
0.81 Sleeping with Other People
3.85 Sleight
7.77 Slither
141.32 Slumdog Millionaire
34.01 Snakes on a Plane
155.11 Snow White and the Huntsman
21.48 Snowden
4.56 Snowpiercer
Solace
54.7 Source Code
52.42 Southpaw
Spectral
200.07 Spectre
336.53 Spider-Man 3
138.12 Split
44.99 Spotlight
14.12 Spring Breakers
110.82 Spy
Srpski film
0.02 Stake Land
257.7 Star Trek
158.8 Star Trek Beyond
228.76 Star Trek Into Darkness
936.63 Star Wars: Episode VII - The Force Awakens
38.35 Stardust
100.47 Step Brothers
65.27 Step Up
58.01 Step Up 2: The Streets
17.75 Steve Jobs
72.66 Storks
161.03 Straight Outta Compton
36.38 Sucker Punch
325.02 Suicide Squad
Suite Française
125.07 Sully
3.68 Sunshine
0.32 Super
126.98 Super 8
121.46 Superbad
200.07 Superman Returns

52.88 Sweeney Todd: The Demon Barber of Fleet Street

4.21 Swiss Army Man
1.2 Taare Zameen Par
6.92 Take Me Home Tonight
145 Taken
89.25 Taken 3
Tall Men
148.21 Talladega Nights: The Ballad of Ricky Bobby
200.81 Tangled
218.63 Ted
81.26 Ted 2
190.87 Teenage Mutant Ninja Turtles

0.54 Teenage Mutant Ninja Turtles: Out of the Shadows

89.73 Terminator Genisys
125.32 Terminator Salvation
34.33 Texas Chainsaw 3D
26.05 That Awkward Moment
34.91 The 5th Wave
The 9th Life of Louis Drax
86.2 The Accountant
62.45 The Adjustment Bureau
42.48 The Age of Adaline
0.54 The Age of Shadows
262.03 The Amazing Spider-Man
202.85 The Amazing Spider-Man 2
The Assassination of Jesse James by the Coward Robert
3.9 Ford
The Assignment
 77.21 The A-Team
The Autopsy of Jane Doe
623.28 The Avengers
0.92 The Babadook
0.04 The Babysitters
The Bad Batch
10.16 The Belko Experiment
26.76 The Best of Me
55.47 The BFG
70.24 The Big Short
The Black Room
0.02 The Blackcoat's Daughter
255.95 The Blind Side
94.82 The Book of Eli
50.15 The Book of Life
63.03 The Boss
113.17 The Bourne Legacy
227.14 The Bourne Ultimatum
35.79 The Boy
9.03 The Boy in the Striped Pyjamas
35.39 The Boy Next Door
118.68 The Break-Up
116.63 The Butler
42.04 The Cabin in the Woods
18.71 The Choice
1.66 The Comedian
137.39 The Conjuring
102.46 The Conjuring 2
16.97 The Counselor
127.49 The Curious Case of Benjamin Button
217.54 The Da Vinci Code
12.71 The Danish Girl
533.32 The Dark Knight
448.13 The Dark Knight Rises
0.03 The Daughter
132.37 The Departed
82.62 The Descendants
124.73 The Devil Wears Prada
59.62 The Dictator
2.41 The Disappointments Room
0.54 The Do-Over
2.02 The Dressmaker
10.72 The Drop
34.02 The DUFF
14.26 The Edge of Seventeen
101.53 The Equalizer
The Escort
The Exception
102.98 The Expendables
85.02 The Expendables 2
39.29 The Expendables 3
2.28 The Fall
36.92 The Family
62.49 The Fast and the Furious: Tokyo Drift
124.87 The Fault in Our Stars
93.57 The Fighter
27.55 The Finest Hours
0.02 The First Time
12.79 The Founder
10.14 The Fountain
33.63 The Gambler
15.52 The Ghost Writer
43.77 The Gift
The Girl Next Door
75.31 The Girl on the Train
The Girl with All the Gifts
102.52 The Girl with the Dragon Tattoo
45.09 The Giver
70.08 The Golden Compass
59.07 The Grand Budapest Hotel
144.81 The Great Gatsby
45.13 The Great Wall
7.19 The Green Inferno
0.32 The Guest
10.64 The Gunman
277.31 The Hangover
64.51 The Happening
54.12 The Hateful Eight
The Headhunter's Calling
36.77 The Heartbreak Kid
159.58 The Heat
169.71 The Help
41.78 The Hills Have Eyes
303 The Hobbit: An Unexpected Journey
255.11 The Hobbit: The Battle of the Five Armies
258.36 The Hobbit: The Desolation of Smaug
1.02 The Hollars
2.2 The Host
26.62 The Host
48.24 The House Bunny
 0.18 The Human Centipede (First Sequence)
408 The Hunger Games
424.65 The Hunger Games: Catching Fire
337.1 The Hunger Games: Mockingjay - Part 1
281.67 The Hunger Games: Mockingjay - Part 2
47.95 The Huntsman: Winter's War
15.7 The Hurt Locker
39.83 The Illusionist
7.69 The Imaginarium of Doctor Parnassus
91.12 The Imitation Game
19 The imposible
134.52 The Incredible Hulk
15.43 The Infiltrator
The Intent
75.27 The Intern
44.67 The Internship
6.11 The Interview
13.18 The Intouchables
0.23 The Invitation
47.11 The Judge
364 The Jungle Book
176.59 The Karate Kid
1.29 The Kings of Summer
138.8 The King's Speech
The Last Airbender
The Last Face
27.36 The Last Witch Hunter
126.59 The Legend of Tarzan
257.76 The Lego Movie
The Levelling
12.53 The Light Between Oceans
11.28 The Lives of Others
8.7 The Lobster
5.98 The Loft
89.29 The Lone Ranger
37.43 The Longest Ride
8.01 The Lost City of Z
0.22 The Love Witch
43.98 The Lovely Bones
60.44 The Lucky One
93.38 The Magnificent Seven
45.43 The Man from U.N.C.L.E.
3.86 The Man Who Knew Infinity
228.43 The Martian
16.38 The Master
 The Matchbreaker
102.41 The Maze Runner
0.07 The Midnight Meat Train
25.59 The Mist
31.17 The Mortal Instruments: City of Bones
102.18 The Mummy: Tomb of the Dragon Emperor
The Neighbor
1.33 The Neon Demon
36.25 The Nice Guys
26.81 The Other Boleyn Girl
119.22 The Other Guys
83.91 The Other Woman
17.74 The Perks of Being a Wallflower
21.38 The Place Beyond the Pines
53.08 The Prestige
104.37 The Princess and the Frog
The Promise
163.95 The Proposal
64.42 The Purge
79 The Purge: Election Year
162.59 The Pursuit of Happyness
183.64 The Revenant
The Ridiculous 6
6.53 The Rise of the Krays
0.06 The Road
0.02 The Sea of Trees
368.31 The Secret Life of Pets
58.23 The Secret Life of Walter Mitty
The Secret Scripture
55.12 The Shallows
The Siege of Jadotville
3.19 The Skin I Live In
96.92 The Social Network
6.85 The Spectacular Now
The Stakelander
0.64 The Stanford Prison Experiment
52.53 The Strangers
The Survivalist
35.89 The Theory of Everything
The Thinning
20.32 The Three Musketeers
The Ticket
92.17 The Town
13.3 The Tree of Life
281.28 The Twilight Saga: Breaking Dawn - Part 1
 292.3 The Twilight Saga: Breaking Dawn - Part 2
300.52 The Twilight Saga: Eclipse
88.92 The Ugly Truth
65.07 The Visit
0.15 The Void
25.14 The VVitch: A New-England Folktale
10.14 The Walk
The Warriors Gate
The Whole Truth
116.87 The Wolf of Wall Street
132.55 The Wolverine
26 The World's End
3.18 Their Finest
40.22 There Will Be Blood
This Beautiful Fantastic
67.52 This Is 40
101.47 This Is the End
54.76 This Means War
181.02 Thor
206.36 Thor: The Dark World
24.1 Tinker Tailor Soldier Spy
16.68 To Rome with Love
93.42 Tomorrowland
1.48 Toni Erdmann
58.88 Total Recall
414.98 Toy Story 3
Tracktown
110.01 Trainwreck
Tramps
2.32 Trance
23.01 Transcendence
318.76 Transformers
245.43 Transformers: Age of Extinction
352.36 Transformers: Dark of the Moon
402.08 Transformers: Revenge of the Fallen
Transpecos
Triangle
12.63 Triple 9
153.69 Trolls
172.05 Tron
110.42 Tropic Thunder
True Crimes
171.03 True Grit
0.06 Trust
0.05 Turbo Kid
 1.82 Tusk
191.45 Twilight
Twin Peaks: The Missing Pieces
115.6 Unbroken
2.61 Under the Skin
62.32 Underworld Awakening
30.35 Underworld: Blood Wars
45.8 Underworld: Rise of the Lycans
31.54 Unfriended
61.09 Unknown
81.56 Unstoppable
292.98 Up
83.81 Up in the Air
USS Indianapolis: Men of Courage
58.88 Vacation
7.79 Vampire Academy
23.21 Vicky Cristina Barcelona
5.77 Victor Frankenstein
23.05 Viking
Vincent N Roxxy
Viral
0.01 Wakefield
223.81 WALL·E
134.57 Wanted
43.02 War Dogs
War on Everyone
47.17 Warcraft
66.36 Warm Bodies
13.65 Warrior
107.5 Watchmen
3.59 We Are Your Friends
1.74 We Need to Talk About Kevin
150.37 We're the Millers
3.45 What If
41.1 What to Expect When You're Expecting
3.33 What We Do in the Shadows
13.99 What's Your Number?
13.09 Whiplash
Whiskey Tango Foxtrot
Whisky Galore
0.2 White Girl
73.1 White House Down
60.31 Why Him?
37.88 Wild
Winter's Bone
 Wolves at the Door
33.31 Woman in Gold
202.35 World War Z
83.64 Wrath of the Titans
Wrecker
189.41 Wreck-It Ralph
146.41 X: First Class
179.88 X-Men Origins: Wolverine
155.33 X-Men: Apocalypse
233.91 X-Men: Days of Future Past
234.36 X-Men: The Last Stand
Yoga Hosers
100.02 You Don't Mess with the Zohan
21.56 Your Highness
2.7 Youth
31.45 Zack and Miri Make a Porno
95.72 Zero Dark Thirty
Zipper
33.05 Zodiac
75.59 Zombieland
28.84 Zoolander 2
341.26 Zootopia
%)

Instructions (please do not erase the instructions or grading scheme) Grade

Use the VLOOKUP function in Q7 below to find the Revenue (Millions) for the Movie Title given in K7.
You must use A4:E1004 as the table array and set the lookup_value, col_index_num, and /4
range_lookup appropriately.

Movie Title Star Trek Revenue (Millions)

Use the VLOOKUP function in Q13 below to find the Rating for the Movie Title given in K13. You must
use A4:E1004 as the table array and set the lookup_value, col_index_num, and range_lookup /4
appropriately.

Movie Title Zootopia Rating

Use the VLOOKUP function in Q20 below to find the Runtime (Minutes) for a movie of your choice
that is listed in the table. Add your movie title to K20. You must use A4:E1004 as the table array and /5
set the lookup_value, col_index_num, and range_lookup appropriately.

Movie Title Independence Day: Resurgence Runtime (Minutes)

Find the maximum Revenue (Millions) made by a movie in K27. Use the VLOOKUP function in Q27
below to the title of the movie that made the most revenue. HINT: copy the titles into column F and /5
then set the lookup_value, table_array, col_index_num, and range_lookup appropriately.

Max Revenue (Millions) 936.63 Movie Title

Select C4:C1004, click the Conditional Formatting button and select Top/Bottom Rules -> Top
/3
10% and enter the following in the dialog box and click OK.

Select D4:D1004, click the Conditional Formatting button and select Highlight Cell Rules -> Between
/3
and enter the following in the dialog box and click OK.
Select D4:D1004, click the Conditional Formatting button and select Highlight Cell Rules -> Between /3
and enter the following in the dialog box and click OK.

Select E4:E1004, click the Conditional Formatting button and select Colour Scales -> Green - White -
/2
Red Colour Scale.

OVERALL GRADE 0 /26

Comments

257.7

8.1

120

Star Wars: Episode VII - The Force Awakens