The amount of sales tax on each sale is calculated as the selling price times the quantity sold times the sales tax rate. What formula would you use in celle E4 to then be able ro copy that cell to the rest of the column?

  • =C4D4$B$1
  • =(C4*D4)*B1
  • =C4D4B1
  • =C4*D4(*B1)

The correct answer is:

  • =C4D4$B$1

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