Spreadsheets can have the following features:

  • Workbooks containing multiple worksheets.
  • Extensive formula capabilities with carefully defined formula grammar.
  • The calculation chain, enabling developers to define the order of formula evaluation.
  • Comments, enabling users to annotate workbooks and worksheets.
  • Styles, similar in nature to styles in WordprocessingML, enabling developers to design carefully formatted spreadsheets.
  • Pivot tables, providing power users with extensive capabilities for examining their data from a wide variety of viewpoints.
  • External data connections, enabling users to bring data from a disparate variety of sources.