Microsoft Excel Assessment You need to determine the commission earned for each salesperson based on the Sales Amounts in B3:350 and the Commission Rate specified in cell A1. You want to enter the formula in c3 and copy it down to C50. Which formula will correctly calculate each salesperson's commission? 2018 Coin Sales Rep 2018 Sales Pordan Apel was 5128.00 5594310.00 5235,954.00 5684 760.00 5456.125.00 $412,354.00 $215.515.00 $11452100 581455.00 5965.458.00 SASA 25.00 52200098.00 595425.00 5035 12.00 Watch Pearl Davenport Amos Hope Ostom 04 01:24 Microsoft Excel Assessment You need to determine the commission earned for each salesperson based on the Sales Amounts in B3:850 and the Commission Rate specified in cell A1. You want to enter the formula in C3 and copy it down to C50. Which formula will correctly calculate each salesperson's commission? 45 .00 52706800 S54 72500 OAI $83 O-SA1-83 O-SA$1.33 -A1-83 Something wrong with this question? Give feedback Q4 01:21