Software features

• Features of spreadsheets

  -Formulas cam be used to perform complex calculations

  -Data can be sorted to be viewed in a particular order

  -conditional formatting can be used to emphasise certain cells based on teh cell content

  -charts can be created using spreadsheet data to display info in a more visual way

  -dynamic linkage can be used to link cell data from one sheet to another, and every time one cell is altered the other cell automatically updates

  -formula and value view can be printed

  -hlookup ans v lookup can be used to bring info over from other sheets and see it all in one place
• Database features

  -sorting

  -queries

  -reports

  -data validation

  -restricted choice

  -mail merge
• presentation software features

  -design template

  -action buttons

  -slide transition and animations

  -hyperlinks

  -notes and handouts can be printed

  -speaker notes can be added
• Word features

  -headers and footers

  -formatting

  -section and page breaks

  -spell check

  -tables

  -endnotes and footnotes
• spreadsheet features

  Formulas

  sorting

  charts

  conditional formatting

  dynamic linkage

  named cell range

  pivot table

  value and formula print outs