Programming the spreadsheet from with spreadsheet app and from CAS

[Anthony The Koala]

I am looking to do spreadsheet operations on the spreadsheet app and within the spreadsheet.

Note I am not interested in programming macros.

This is about entering data either from the cas or within the spreadsheet app.

To illustrate:
I want to do these commands programmatically either in the cas or spreadsheet:

1. Column A has numbers from 0 to 10
2. Column B has the numbers A^2
3. Column C has the num.
4. Column D has the numbers A^4

I tried the method of copying for example at this tutorial
https://bellebot.com/hp-prime-spreadsheet-tutorial but could not do a copy of the column values of A and for example column B is A^2.
I could not work out how to do a single paste of column B.

Again the questions are:
(a) is there a way to do steps 1. to 4. in the spreadsheet
(b) is there a a way to poluate the cells within the cas screen NOT the macro method.

Thank you
Anthony, Sydney[/align]