Spotlight Video, a premier video rental company in Denver, Colorado, offers the latest selections on DVD, game, and VHS releases

Spotlight Video, a premier video rental company in Denver, Colorado, offers the latest selections on DVD, game, and VHS releases. After customers view DVDs and VHS tapes a certain number of times, their quality deteriorates to the point that Spotlight Video considers them defective. Furthermore, some customers own defective DVD and VHS players that can ruin Spotlight Video’s merchandise. So, Spotlight wishes to maintain a certain level of acceptability. Spotlight hired you to create a spreadsheet that will evaluate each DVD and VHS using the data in SpotlightVideo_Data.xlsx which shows the number of times each title was rented and the number of reported defects for each title.

• Use the IF function to write a conditional expression that examines the criteria mentioned above.Spotlight wants to know how many (and which) videos they will need to replace if the percent acceptable is 80 percent or above. If the video has a percentage below 80 percent, they want to flag this video as REPLACE. Call this worksheet “80”.
• Use the IF function to write a conditional expression that examines the criteria mentioned above.Spotlight wants to know how many (and which) videos they will need to replace if the percent acceptable is 95 percent or above. If the video has a percentage below 95 percent, they want to flag this video as REPLACE. Call this worksheet “95”.

SPOTLIGHT VIDEO DEFECT REPORT ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 36 38 39 39 41 42 43 44 44 44 # OF # OF DEFECT STATUS RENTALS S Walk the Line (2005) 114 5 Yours, Mine and Ours (2005) 53 5 The Weather Man (2005) 112 54 North Country (2005) 23 12 Domino (2005) 100 12 Saw II (2005) 44 19 Rent (2005) 53 12 Just Like Heaven (2005) 42 26 Elizabethtown (2005) 92 26 Zathura: A Space Adventure (2005) 20 19 Flightplan (2005) 44 40 Waiting... (2005/I) 88 26 In Her Shoes (2005) 34 33 Corpse Bride (2005) 99 33 The Legend of Zorro (2005) 62 33 Proof (2005) 24 19 Lord of War (2005) 50 47 The Ice Harvest (2005) 9 5 Pride & Prejudice (2005) 34 5 Transporter 2 (2005) 74 54 Red Eye (2005/I) 55 54 Wallace & Gromit in The Curse of the Were-Rabbit (2005) 29 26 Doom (2005) 78 26 Wedding Crashers (2005) 66 61 The Man (2005) 51 47 The Constant Gardener (2005) 100 54 The Fog (2005) 50 40 Hustle & Flow (2005) 56 54 The Prince and Me 2 (2006) (V) 98 12 The Aristocrats (2005) 46 40 Supercross (2005) 72 33 MirrorMask (2005) 78 19 Where the Truth Lies (2005) 50 5 Into the Blue (2005) 74 69 Two for the Money (2005) 55 47 Broken Flowers (2005) 86 61 Four Brothers (2005) 87 75 Must Love Dogs (2005) 83 75 The River King (2005) 3 40 Stuart Little 3: Call of the Wild (2005) (V) 34 12 The Cave (2005) 90 61 The Thing About My Folks (2005) 19 19 Separate Lies (2005) 42 12 Cinderella Man (2005) 99 89 Mr. & Mrs. Smith (2005) 102 96 Underclassman (2005) 77 47 MOVIE TITLE 47 47 49 50 The 40 Year Old Virgin (2005) The Brothers Grimm (2005) Nine Lives (2005) Thumbsucker (2005) 100 100 22 42 82 75 19 40