. Choose the most appropriate answer from the options following each question One set of information may be used for multiple questions! . Once you start the excam, you have to complete it in 90 minutes. You only have ONE attempt for the exam Time Runnin 1 Hour D Question 12 1 pts The information below.refers to THREE questions An operation analyst built a spreadsheet to study the relationship between order quantity and total inventory cost. Below is a one-way table screenshot) that was developed. 1 Least Cost 77.5 2 Optimal Order 80 3 4 Order Quantity Total Cost 5 115 6 60 80.0 7 70 77.9 80 77.5 9 90 78.3 10 100 80.0 Q: Based on what was shown in class, how was the 77.5 value in B8 highlighted? Conditional Formatting Located lowest value and used Full Color O-MINIB6:310) placed in cell B8 Used the Colors option under Page Layout Next Previous MacBook Air 56 BO ES * O % & 7 8 9 4 5 6 2 3 0 Y U T W E R G D F