Mapa mental

Spread sheet mindmap

Danielle Zondo Computing GCSE Inglês

Mind map: spreadsheet mind map

Conteúdo do mapa

Functions
- =SUM
  - =MIN
    - =MAX
      - =Today()
  - =AVERAGE
    - Autosum()
  - =MAX
- Goal seek
  - IF statement
- Graphinig
- Results can be compared visually
Formatting
- Borders
- Text styles
  - Sheet background
- Text size
- Text colour
- information can be stored in a cell/rows/columns/tables
Data
- Import
- Export
- This software can be saved on this type of software
- Each cell has a unique cell address which acts like a pair of co-ordinates,it tells you which row(numbers) or column (letter) the cell is in.
In a suitable format for future use, spread sheets have sets of format.
- Number
- Time/date
- Accounting
- Fractions
- Percentages
- Text
- Currency
- Used data can 0be used from this type of software
Operating systems have their own spread sheet application
- Numbers (ios)
- Microsoft excel
Uses
- Allow calculations to be made
- Show figures
  - That can be entered by the user
  - Using formulas and/or functions
- Listing formulas and/or functions
- Auto-update- allows users to change figures and results
- A single page of a spread sheet is called a worksheet