How do i calculate a whole list in one column (B1-b6) (mathematical function
i.e. multiply, divide, summation) with another column (c1-c6) and have excel
display the output in another set of columns (d1-d6) i.e.

input X input = output by excel
b1 X c1= d1
b2 X c2= d2
b3 X c3= d3
b4 X c4= d4

without me having to change the column number row by row and insert the
value row by row after each calculation.

thank you