# 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]

##### 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.