Question: You need to determine the commission earned by each Sales rep, based on the Sales amount 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
- =A1\*B3
- =$A$1\*B3
- =$A1\*B3
Answer: The correct answer of the above question is Option C:=$A$1\*B3