Lesson 22: Notions on Spreadsheets

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.

Leave a comment

Your email address will not be published. Required fields are marked *

sponsors Ads