Referencing Cells

Google Sheets uses referencing interactions between cells to relate and compare data.

Cells

Cells are the individual rectangles that make up the entirety of the sheet. They are identified as the cross section between its corresponding column and row. Rows are identified using letters of the alphabet, in alphabetical order. Columns are identified using numerical values. The name of the cell is characterized by the row it is in, followed by the column. For example, the first cell of the sheet is titled A1.

When selecting a group of cells, the selection is identified by its range. A range is characterized by the selection's left-most cell and the area created by its right-most cell. The title is separated by a colon. For example, a selection of the cells A1, A2, and A3 is marked by A1:A3. Selections can also be made by click-dragging over the desired cells.

Functions

Functions are how cells relate to one another based on their values. A function is created by selecting a cell, or a range of cells, and typing "=" followed by the desired function. Depending on the function, the values of the cell will interact with one another to create a desired output. For instance, the =SUM function takes the collective sum of the desired range of cells.

For a list of functions in Google Sheets, see: List of Functions