Spreadsheet Concepts

Descripción

A2 (4. Spreadsheet Concepts) ICT Mapa Mental sobre Spreadsheet Concepts, creado por eleanorbradbury el 11/04/2013.
eleanorbradbury
Mapa Mental por eleanorbradbury, actualizado hace más de 1 año
eleanorbradbury
Creado por eleanorbradbury hace más de 11 años
78
1

Resumen del Recurso

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
                                    Mostrar resumen completo Ocultar resumen completo

                                    Similar

                                    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