However, this is not a very useful trick. When we have a column of data, we can multiply that entire column by another column or a constant or another operation by referring to a cell location and writing the appropriate formula. Then we copy this formula valid for one cell into the rest of the c column, using the editing cut and paste keys. For formulas, where you do not wish the reference to a given cell to change as above, you refer to cells with absolute referencing. This ensures that the content of that specific cell is used.
All spreadsheets have a variety of mathematical, statistical, and other function built in.
There are a class of functions, called array functions, that require a little bit more care. These functions calculate a number of answers simultaneously and therefore they need to have a number of cells available in which to place them. That is, for 0.0, 0.1,0.2, or at some finer resolution in x. Once that decision is made, the rest is easy as the sin and cos are built-in mathematical functions. Say that we will advance x by 0.1 at a time.