spreadsheets

Cells containing formulas

Spreadsheets are documents organized into a grid of rows and columns, where each cell can hold data or formulas that calculate values from other cells.

The format dominates business and personal record-keeping—budgets, inventories, financial projections.

She tracks her expenses in a spreadsheet.

The singular spreadsheet refers to either the document or the software category: Open a new spreadsheet, I learned spreadsheet in college.

structure

rows

Side-by-side sequences

  • columnsUpright structural shafts
  • cellsBasic biological units
  • gridFramework of intersecting lines

table · matrix · header · worksheet · workbook · range · merge · split · tab · layout

calculation

formula

Fixed method or notation

compute · arithmetic · nested · operator · expression · array · lookup · concatenate · rounding · percentage

data

entry

Access or submission

  • valuesPrinciples held worthwhile
  • numericExpressed in digits
  • textWritten or printed words

sorting · filtering · validation · import · export · CSV · database · records · fields · dataset

software

Microsoft Excel

Tabular data calculation software

  • macrosAutomated command sequences
  • VBAOffice application scripting language
  • add-insSupplemental software components

plugin · cloud · collaboration · sharing · real-time editing · permissions · offline

analysis

pivot table

Interactive data summary matrix

statistics · correlation · forecast · scenario · what-if · solver · regression · variance · trend · comparison

charts

visualization

Forming mental or graphical images

line graph · histogram · scatter plot · trendline · axis · legend · series · sparkline · area chart · stacked

formatting

color coding

Assigning hues to categories

alignment · number format · currency · date format · highlighting · template · theme · bold · italic

Categories
Opposites
document type/data organization paradigm

spreadsheetsword processors

Software for writing documents

essays · novels · manuscripts · letters · memos

data management approach

spreadsheetsdatabases

Organized electronic information collections

word processors · enterprise software · PowerPoint · Microsoft Word · Google Docs

information medium

spreadsheetshandwritten notes

Text inscribed by pen

mental math · verbal accounts · memory · blank paper

Phrases
Family

spreadsheet

Familiarity
Top 50,000
Profile
Known to kids · Used worldwide · Timeless · Concrete · Everyday, not technical · Rated G