Review Technology Plug-In 4 Decision Making Using Excel 2010. Complete exercise 1. Spotlight Video Rentals.Spotlight Video is a premier video rental company in Denver, Colorado, offering the latest selections on DVD, game, and VHS releases. After DVDs and VHS tapes have been viewed a certain number of times, their quality deteriorates to the point that Spotlight Video considers them to be defective. Furthermore, some customers own DVD and VHS players that are defective and can ruin Spotlight Video’s merchandise. Spotlight Video wants to maintain an inventory of DVDs and VHS tapes that are at least 85 percent acceptable, although 95 percent is preferable. However, since it can’t keep customers’ machines from damaging the rentals, Spotlight Video has had to relax its criterion a little. You have been hired to create a spreadsheet that will evaluate each DVD and VHS based on the following criteria:Number of times each title has been rented.Number of defects that have been reported.The percent acceptable must be above 85 percent based on usage. If the percent defective reported is above 15 percent (or percent acceptable below 85%), then Spotlight Video wants to flag this video as “REPLACE.”Spotlight Video has provided you with the data in a file called T4_SpotlightVideo_Data.xls. You will want to create an IF function to write a conditional expression that examines the criteria mentioned above. Figure T4.20 displays a sample of the output that Spotlight Video needs.
Do You Need A Similar Assignment Done For You From Scratch? We Have Qualified Writers To Help You. We Assure You An A+ Quality Paper That Is Free From Plagiarism. Order Now For An Amazing Discount!
Very professional support! Highly recommended.
Researched complicated topic and delivered report by the requested deadline. The paper is of a high standard reflecting careful research and clear assessments. I recommend iLecturers.com.com
It’s a 5 start for me. Excellent research and writing. The paper reflects a careful assessment of scientific information.
With Gib’s reflection, they wrote a really specific essay. Very well written, containing all of the languages I required and excellent references. The writer follows my instructions and writes clearly in English.
I am so grateful and I am 100% happy with your work.
A fantastic piece of work 👏. The writer demonstrated full knowledge of the topic and applying the relevant provided material. Well done.