Spreadsheet

From WikiMD.org
Jump to navigation Jump to search

Spreadsheet

A Spreadsheet (/ˈspredˌSHēt/) is a file made of rows and columns that help sort, organize, and arrange data efficiently, and calculate numerical data.

Etymology

The term "spreadsheet" comes from "spread" in the sense of a newspaper or magazine item (text and/or graphics) that covers two facing pages, extending across the center fold and treating the two pages as one large page. The compound word "spread-sheet" came to mean the format used to present book-keeping ledgers—with columns for categories of expenditures across the top, invoices listed down the left margin, and the amount of each payment in the cell where its row and column intersect—which were, traditionally, a "spread" across facing pages of a bound ledger (book for keeping accounting records) or on oversized sheets of paper ruled into rows and columns in that format and approximately twice as wide as ordinary paper.

Related Terms

  • Cell (spreadsheet): A box in a spreadsheet where data can be entered. Each cell is identified by its unique column letter and row number.
  • Row (spreadsheet): A horizontal group of cells in a spreadsheet. Rows are identified by numbers.
  • Column (spreadsheet): A vertical group of cells in a spreadsheet. Columns are identified by letters.
  • Formula (spreadsheet): An expression telling the spreadsheet what to do with certain cells' data. Formulas can perform mathematical operations, such as addition and multiplication, or compare cell values, or combine text, or do conditional operations, such as IF...THEN...ELSE.
  • Function (spreadsheet): A predefined formula that performs calculations using specific values in a particular order or structure.
  • Worksheet (spreadsheet): A single "page" of a spreadsheet file, containing cells arranged by rows and columns. A spreadsheet file can contain multiple worksheets.
  • Workbook (spreadsheet): The file containing all the worksheets. It's what you're actually saving and opening when you work with Excel.

External links

Esculaap.svg

This WikiMD article is a stub. You can help make it a full article.


Languages: - East Asian 中文, 日本, 한국어, South Asian हिन्दी, Urdu, বাংলা, తెలుగు, தமிழ், ಕನ್ನಡ,
Southeast Asian Indonesian, Vietnamese, Thai, မြန်မာဘာသာ, European español, Deutsch, français, русский, português do Brasil, Italian, polski