Example 3: Copy the example data in the following table and paste it in cell A1 of a new Excel worksheet. The following table represents the value of sales in different sales markets according to the three prices: $50,$45,$40. The required results are to determine the number of sales representatives that each market needs based on the following assumptions: 1. The market needs 5 sales representatives, if the sales value is less than or equal to $ 80,000. 2. The market needs 8 sales representatives if sales value is greater than $80,000 3. A scenario summary that shows how many sales representatives for each market Sales Market Sales Value (550) Sales Value ($45) Sales Value ($40) Number of sales representatives Oman 100,000.00 111,000.00 $ 120,000.00 80,000.00 $ 104,000.00 $ 118,000.00 75,000.00 $ 85,000.00 $ 90,000.00 50,000.00 $ 72,000.00 $ 79,000.00 $ 60,000.00 $ 74,000.00 $ B1,000.00 UAE KSA Qatar Bhrain $ $ $ $