Excel Test

Video Rentals

Video Rentals
Category	Title	Number of Rentals
Comedy	McHale's Navy	2
Drama	Murder At 1600	2
Comedy	Old Feeling	2
Comedy	Eight Heads In a Duffel Bag	3
Comedy	Gross Pointe Blank	4
Action	Metro	4
Drama	Devil's Own	5
Comedy	Liar, Liar	10
Drama	Jerry Maquire	15
Action	Double Team	19
Action	Anaconda	23
Comedy	Mother of the Groom	25
Drama	Proceedings	34
Action	Relic, The	34
Drama	Inventing the Abbotts	35
Action	Set It Off	35
Action	Saint, The	36
Drama	Proceedings	38
Action	Dante's Peak	51
Action	Twister	63
Action	Return of the Jedi	65
Action	Star Wars	69

Rental Costs

Rental Costs
Category	Title	Movie Length	Fee charged to customer for each rental
Comedy	Gross Pointe Blank	50	$0.99
Drama	Proceedings	50	$1.50
Action	Dante's Peak	60	$1.50
Comedy	Mother of the Groom	60	$1.50
Action	Relic, The	65	$0.99
Drama	Inventing the Abbotts	65	$1.50
Drama	Jerry Maquire	85	$1.50
Action	Return of the Jedi	85	$1.50
Comedy	Liar, Liar	95	$0.99
Action	Saint, The	95	$0.99
Action	Anaconda	120	$0.99
Comedy	McHale's Navy	120	$0.99
Action	Metro	120	$0.99
Comedy	Eight Heads In a Duffel Bag	120	$1.50
Drama	Proceedings	120	$1.50
Action	Set It Off	120	$1.50
Action	Twister	130	$0.99
Drama	Devil's Own	130	$1.50
Drama	Murder At 1600	130	$1.50
Comedy	Old Feeling	160	$1.50
Action	Double Team	160	$1.60
Action	Star Wars	200	$0.99