Spreadsheet

Description

KS4 ICT Mind Map on Spreadsheet, created by Matthew Stentiford on 18/04/2017.
Matthew Stentiford
Mind Map by Matthew Stentiford, updated more than 1 year ago
Matthew Stentiford
Created by Matthew Stentiford about 7 years ago
5
1

Resource summary

Spreadsheet
  1. Benefits
    1. Automatic recalcuation
      1. Graphs/charts can be drawn
        1. Replication (drag the formula down)
          1. What-if calculations
            1. Formulae can be stored and resued
              1. Calculations involving large numbers are possible
                1. Fill feature to copy recently used formulae
                2. Relative cell referencing
                  1. When you drag a formulae down you use the cells relative address
                  2. Absolute cell referencing
                    1. Uses dollar signs to change the relative address but not the absolute address
                    Show full summary Hide full summary

                    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