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