How to Input Data and Refer to Cells

Entering data and creating objects
[size=100]In GeoGebra’s [i]Spreadsheet View[/i] every cell has a specific name that allows you to directly address each cell.[br][u]Example[/u]: The cell in column [i]A[/i] and row [i]1[/i] is named [b]A1[/b].[br][br]You may use the [i]Spreadsheet [/i]cells in order to create mathematical objects that are directly displayed in the [i]Graphics View[/i] (e.g. points).[br][br][b]Task 1[/b][br][/size][table][tr][td][size=100]1.[/size][/td][td][center][size=100][b]A1[/b][/size][/center][/td][td][size=100][font=Arial]Enter the number [/font][code]10 [/code]into cell [b]A1[/b].[br][u]Hint[/u]: Always confirm your input by pressing the [i]Enter[/i] key.[/size][/td][/tr][tr][td][size=100]2.[/size][/td][td][center][size=100][b]B1[/b][/size][/center][/td][td][size=100]Enter the coordinates [code](-2, 2) [/code]into cell [b]B1[/b].[br][u]Note[/u]: The point [i]B1 = (-2, 2)[/i] is automatically shown in the [i]Graphics View[/i].[/size][/td][/tr][tr][td][size=100]3.[br][/size][/td][td][size=100][icon]/images/ggb/toolbar/mode_move.png[/icon][br][/size][/td][td][size=100]Select the [i]Move[/i] tool and drag point [i]B1[/i] in the [i]Graphics View[/i]. [br][u]Note[/u]: The [i]Spreadsheet View [/i]shows the current position of point [i]B1 [/i]in cell [b]B1[/b][i][/i].[br][/size][/td][/tr][tr][td][size=100]4.[br][/size][/td][td][size=100][icon]/images/ggb/toolbar/mode_delete.png[/icon][br][/size][/td][td][size=100]Delete the content of cell [b]B1[/b].[/size][/td][/tr][/table]
Try it yourself...
Cell references
[size=100]You may refer to another cell by using its name in your new input.[br][u]Note[/u]: If the content of this cell is modified, the new input adapts automatically.[br][/size][size=100][br][b]Task 2[/b][br][/size][table][tr][td][size=100]1.[/size][/td][td][size=100][b]A1[/b][/size][/td][td][size=100]Change the number in cell [b]A1[/b] to [code]1.5[/code] and confirm your input.[/size][/td][/tr][tr][td][size=100]2.[/size][/td][td][center][size=100][b]B1[/b][/size][/center][/td][td][size=100]Enter the formula [code]= 2 * [/code]into cell [b]B1[/b] and then select cell [b]A1[/b] in order to insert its name into the formula. Confirm your input.[br][u]Note[/u]: GeoGebra calculates [i]2 * 1.5[/i] and displays the solution [i]3[/i] in cell [b]B1[/b].[br][/size][/td][/tr][tr][td][size=100]3.[br][/size][/td][td][b][size=100][/size][/b][center][size=100][b]A1[/b][br][/size][/center][/td][td][size=100]Change the content of cell [b]A1[/b] to [font=monospace]3[/font].[br][u]Note[/u]: The content of cell [b]B1[/b] automatically adapts to your changes.[/size][/td][/tr][/table][size=100][br][br][b]Task 3[/b][br][table][tr][td]1.[/td][td][b]C1[/b][/td][td]Enter the coordinates [code](A1, B1) [/code]into cell [b]C1[/b] and confirm your input.[br][u]Hint[/u]: Cell [b]C1[/b][i] now [/i]shows the coordinates [i](3, 6)[/i]. The corresponding Point [i]C1[/i] is automatically displayed in the [i]Graphics View[/i].[/td][/tr][tr][td]2.[/td][td][b]A1[/b][/td][td]Change the value of cell [b]A1[/b] to [code]2[/code].[br][u]Note[/u]: The coordinates in cell [b]C1[/b] and the corresponding point automatically adapt to your changes.[/td][/tr][/table][/size]

The Spreadsheet Tools

The Spreadsheet View Toolbar
[size=100]The [i]Spreadsheet Tools[/i] are organized in GeoGebra's [i]Spreadsheet View Toolbar[/i]:[/size][br][size=100][br][img]https://wiki.geogebra.org/uploads/thumb/f/f1/Toolbar-Spreadsheet.png/146px-Toolbar-Spreadsheet.png[/img][/size][br][br][size=100]It contains a variety of [i]Spreadsheet Tools[/i] which are organized in [i]Toolboxes [/i]and can be operated with your pointing device.[/size]
Familiarize yourself with GeoGebra's Spreadsheet Tools
[icon]https://tube.geogebra.org/images/ggb/toolbar/mode_createlistofpoints.png[/icon][b]List of Points[/b][br]Highlight all cells of columns [i]A[/i] and [i]B[/i] that contain data. Then, select the tool [i]List of Points[/i] from the [i]Spreadsheet View Toolbar[/i]. [br]In the appearing dialog window you may...[br][list][*]change the name of the list.[/*][*]decide which column should determine the [i]x[/i]- and the [i]y[/i]-coordinate of the points.[/*][*]check the preview of the list of points.[/*][*]select [button_small]Create[/button_small] in order to create points from your data set.[br][/*][/list][br][u]Note[/u]: [br][list][*]Using this tool you can create a [b]Scatter Plot[/b] from the data.[/*][*]The resulting list of points is also shown in the [i]Algebra View[/i].[/*][/list][br][icon]https://tube.geogebra.org/images/ggb/toolbar/mode_createpolyline.png[/icon][b]Polyline[/b][br]Select a set of spreadsheet cells, where the selected cells form pairs across rows or columns. Then, activate the tool [i]Polyline[/i] to open a dialog for naming, modifying and creating a polyline. Click [button_small][i]Create[/i][/button_small] and the points and the polyline are shown in the [i]Graphics View[/i].[br][br][icon]https://tube.geogebra.org/images/ggb/toolbar/mode_sumcells.png[/icon] [b]Sum[/b][br]Highlight all cells whose numbers you would like to add up and then, select the [i]Sum[/i] tool. [br][u]Note[/u]: The sum is displayed in the next empty cell of the highlighted column.
Try it yourself...
[br][u]Hint[/u]: You might want to use the [img]https://wiki.geogebra.org/uploads/thumb/8/81/Menu-view-refresh-views.svg/16px-Menu-view-refresh-views.svg.png[/img] button to reset your construction in order to try out more [i]Spreadsheet Tools[/i].

Information