Question: You need to determine the commission earned by each Sales Rep, based on the Sales amounts in B3:B50 and the Commission rate specified in cell A1. You want to enter a formula in C3 and copy it down to C50. Which formula should you use?
- =\$A1\*B3
- =$A$1\*B3
- =A1\*\$B3
- =A1\*B3
Answer: The correct answer of the above question is Option B:=$A$1\*B3