How do you make a spreadsheet in Excel where the data points correspond to the product of the x and y axis without having to manually type in the formula for every cell?

Answer 1

You write the formula in the first row: = a1*b1 where x is in column a and y is in column b beginning with the first row.

Then you copy and paste the formula down the column