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
The correct answer is:
- =$A$1*B3
🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers