How do I select all the cells in column A to be populated by the result of
the product of all the cells in two other columns, B and C.

In other words:

I would like A1:A10 = PRODUCT (B1:B10, C1:C10). However, the resultant ten
values ends up cell A1, not cells A1:A10.