Spreadsheet Concepts

Beschreibung

A2 ICT (4. Spreadsheet Concepts) Mindmap am Spreadsheet Concepts, erstellt von eleanorbradbury am 11/04/2013.
eleanorbradbury
Mindmap von eleanorbradbury, aktualisiert more than 1 year ago
eleanorbradbury
Erstellt von eleanorbradbury vor mehr als 11 Jahre
78
1

Zusammenfassung der Ressource

Spreadsheet Concepts
  1. characteristics of modelling software
    1. used to model objects
      1. virtual representation
        1. use of layers
          1. questions can be asked
          2. used for financial modeling
            1. based on functions and formulae
              1. variables and constants can be used
                1. what-if questions can be asked
              2. variables, formulae, rules and functions
                1. variable - identifier asociated with a particular cell which contains a value
                  1. a formula is a calculation which uses numbers, addresses or cells and mathematical operators
                    1. rules are a set of procedures that must be followed and can also be the sequence of events required for a calculation to work
                      1. a function represents a complex formula that uses reserved words
                      2. worksheets, workbooks, cells, rows, columns, ranges
                        1. worksheets consists of all the cells in the sheet
                          1. workbook is a collection of work sheets
                            1. row is a range of cells denoted by a number that go across the worksheet
                              1. column is a range of cells denoted by a letter that go down the worksheet
                                1. range is a group of cells denoted by a name or cell references
                                2. absolute and relative referencing
                                  1. relative - the cell referenced in a formula changes when the formula is copied to other cells
                                    1. absolute - teh cell referenced in the formula remains exactly the same when the formula is copied to other cells
                                    Zusammenfassung anzeigen Zusammenfassung ausblenden

                                    ähnlicher Inhalt

                                    Types and Components of Computer Systems
                                    Jess Peason
                                    Input Devices
                                    Jess Peason
                                    Output Devices
                                    Jess Peason
                                    Networks
                                    Will8324
                                    General ICT Quiz
                                    leahshaw
                                    ICT Revison Flash Cards
                                    Arun Johal
                                    FLAT FILE VS RELATIONAL DATABASE
                                    rosiejones
                                    Online World - Learning Aim A
                                    andysedge
                                    Business Aims and ICT Strategies
                                    scrt
                                    User Interfaces
                                    Skeletor
                                    General ICT Quiz
                                    Jade Fantom