Post Reply 
Programming the spreadsheet from with spreadsheet app and from CAS
10-24-2023, 06:06 PM (This post was last modified: 10-24-2023 06:10 PM by Guenter Schink.)
Post: #2
RE: Programming the spreadsheet from with spreadsheet app and from CAS
Open spreadsheet
enter 1 in A1
activate A2
enter: =1+A1
back to A2
<Copy> , that's shift View
Select -- changes to Sel■
cursor down to A10, watch column becoming blue
<Paste> that's shift Menu
choose 1+A1
Voilá column A has your numbers 1 through 10

activate B1
enter: =A1^2
back to B1
<Copy>
Select
Cursor down to B10, watch column becoming blue
<Paste>
choose A1^2
Voilá column B has squares of column A

activate A1
Select
cursor down to A10, watch column becoming blue
<Copy>
activate C1
<Paste>
choose {1,2,3,4,5,6,7,8,9,10}
Voilà numbers in column C

activate D1
enter: =A1^4
back to D1
<COPY>
Select
Cursor down to D10, watch column becoming blue
<Paste>
Choose A1^4
Voilá column D has column A^4

Maybe there is a simpler way, but this works at least

Günter
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Programming the spreadsheet from with spreadsheet app and from CAS - Guenter Schink - 10-24-2023 06:06 PM



User(s) browsing this thread: 1 Guest(s)