Spreadsheet tools
The
Spreadsheet View provides a Toolbar with a selection of Tools specific for working with a spreadsheet. Activate a Tool by clicking on the button showing the corresponding icon.
![](https://wiki.geogebra.org/uploads/thumb/7/73/Menu_view_spreadsheet.svg/16px-Menu_view_spreadsheet.svg.png)
Task
Calculate the sum of a series of numbers using the
Sum tool.
![Toolbar Image](https://www.geogebra.org/images/ggb/toolbar/mode_sumcells.png)
Instructions
1. | ![]() | Use the Move tool to highlight all cells of column B that contain numbers. |
2. | ![]() | Select the Sum tool from the Spreadsheet View Toolbar. Note: The sum of the numbers in the highlighted cells is displayed in the next empty cell of column B. |
Try it yourself...
Task
Create a list of points based on the numbers provided in the spreadsheet.
Instructions
1. | ![]() | Use the Move tool to highlight all cells of columns B and C down to row 6. |
2. | ![]() | Select the List of Points tool from the Spreadsheet View Toolbar. In the appearing dialog press Create to create points from your data set. Note: The values in column B determine the x-coordinates and the values in column C specify the y-coordinates of the plotted points. |
3. | ![]() | Highlight all cells of columns B and C down to row 6 again and select the Table tool. In the appearing dialog press Create to create a table in the ![]() ![]() |