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