November data test, last question

Part D
https://www.crea.ca/housing-market-stats/national-price-map/

Part E
Yesterday, Mr. Kwok went shopping with his family.  They bought the following items:

https://docs.google.com/spreadsheets/d/1fQT8owrov3fccnlDU6RfTq8MVlMHNbzXf4ltarrR6FM/edit?usp=sharing




Use Google Sheets and appropriate formulae to calculate how much they spent on each item, and the total bill.

Hint:
This formula will calculate the product of multiplication
=product(B2:C2)

Then fill down the formula and apply that for all the items

To calculate the HST,
=sum(A1:A12)*0.13


If you are right, 
Total before tax = $646.83

HST = $84.08

Grand Total = $730.91

BONUS
- figure out how to add the $ sign to the unit price, the total, HST and Grand Total *go to format", top menu