Spotlight Video Rentals

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”.