The Spreadsheet App is a powerful application available in the HP Prime. It can perform many of the functions of spreadsheets but also can perform many of the Math, CAS and Catalog functions within its cells. As usual, you should check out the online Help before using this feature. .
In the examples below, we will build a named spreadsheet that will allow the user to define expression(s) and the application will automatically perform operations on them.
Example 1 - Build an App “Spreadsheet CALC1” that analyses expressions
Lets build an app that will allow you to input an expression (like 2x3-3x-1) and have the application automatically calculate its derivative, integral and find its zeros.
We can build a spreadsheet application from scratch by first “saving” a copy of the existing spreadsheet app. Open the Apps screen and highlight the Spreadsheet app. Click Save. then enter the new name of the spreadsheet (name: Spreadsheet CALC1). Open the new Spreadsheet CALC app and click on cell B2. Enter “Expression” and press Enter. Note - the quotes “ “ are needed if you just want text shown. Now, in cell C2, enter the the expression (), then name it Expr1 as shown
The screen should look as shown. Note the CAS is enabled in cell C2 and the cell is outlined due to the Expr1 name given to it .
Now, lets enter cells that will compute the first derivative of the expression in C2 (or Expr1). In cell B4, enter “=(Expr1)’ “. This is just text that shows the formula you will enter next. In cell C4, enter the CAS formula 
which should give the screen below. You can see the contents of C4 by pressing Show .
In a similar way, we can add integration and finding zeros for Expr1. In cells B5 and B6 enter “=int(Expr1,x)” and “CAS.zeros(Expr1)”. Enter the formulas for the integration and zeros in cells C5 and C6. The screen should show the additional labels and calculations below
At this point, you may want to Format the cells and adjust the row/column sizes. Here it is polished up somewhat. Now if you edit the expression in C2 (green), the revised expression will have its derivative, integral and zeros recalculated - cool huh?
Try the following on your own:
 Although you can build this completely on the HP Prime calculator, you may want to build on the HP Prime emulator as it is easier to type in characters quickly. Then highlight and Send from the emulator to the calculator
 Entering a single quote (prime symbol) in the calculator can be performed with Shift () then <x to delete one of the quotes. Wish it were easier...
 An alternate method is to use the Toolbox commands: press Toolbox 2 2 to load the command.
 Since you entered a CAS command with CAS in the name, then you don't need to enable the CAS button. Make sure the there is no dot to the right of the CAS.