LinkedIn Microsoft Excel Certification 

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?

Editorial Staff
                                    A                                       B                                        C
18.5%2018 Commission 
2Sales Rep2018 SalesComenion Earned
3Jordan Hinton$123,938.00 
4Lilah Douglas5594,810.00 
5Karyn Reese$235,954.00 
6Chiquita 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