Key Spreadsheet Concepts
- Sheet: a spreadsheet document containing multiple cells, used to organize and analyze data.
- Cell: a single box in a spreadsheet where data is entered, with a unique address.
- Address: the unique identifier of a cell, consisting of a column letter and row number (e.g., A1, B2).
- Formula: an expression used to calculate a value in a cell, using numbers, operators, and functions.
- Functions: pre-built formulas for common calculations, such as SUM, AVERAGE, and COUNT.
- Range: a group of cells selected for a calculation or formatting, defined by the address of the top-left and bottom-right cells.
Identifying the Address of a Cell
The address consists of the column letter and row number, used to locate and reference a cell. For example, cell A1 is located in column A, row 1.