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?

                                    A                                        B                                         C
1 8.5% 2018 Commission  
2 Sales Rep 2018 Sales Comenion Earned
3 Jordan Hinton $123,938.00  
4 Lilah Douglas 5594,810.00  
5 Karyn Reese $235,954.00  
6 Chiquita Walsh $684,760.00  
  • =$A1*B3
  • =$A$1*B3
  • =A1*$B3
  • =A1*B3

The correct answer is:

  • =$A$1*B3.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers