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

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock