Which formula will appear in cell E6 if the formula in cell E5 is copied to cell E6? Text in cell A1 is Commission Rate and refers to the 10% showing in cell C1. Three sales reps are showing in the range A5:A7, with monthly sales displayed in the range B5:D7 for the months of January, February, and March. Column E calculates the total commission using the monthly sales data. The formula in cell E5 is: =SUM(B5:D5)*$C$1. Answer: A. =SUM(B5:D5)*$C$1 B. =SUM(B5:D5)*C1 C. =SUM(B6:D6)*$C$1 D. =SUM(B6:D6)*$D$6