Spreadsheets

Spreadsheets

1. Spreadsheets are used to preform calculations using a computer

2. Spreadsheets are made up of three main parts

   • Data is the text or numbers you type in.
     • Labels are headings explaining the data
       • Formulas are automatic calculations

3. There are four main types of formula used in spreadsheet

   • =A1+B1
   • =A2-B2
   • =A3*B3
   • =A4/B4
   • When data changes, formulas automatically recalculate

4. Functions are more advanced calculations that the spreadsheet can do.

5. Coloured borders, or lines can be added to the edge of each cell.

   • cells can be formatted according to their data type e.g cells with money can automatically have a pound sign placed in front of it

Bilder und Dateien der Mindmap