Spreadsheet tools

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

Information: Spreadsheet tools