Spreadsheet Concepts

eleanorbradbury
Mind Map by eleanorbradbury, updated more than 1 year ago
eleanorbradbury
Created by eleanorbradbury about 7 years ago
73
1

Description

A2 ICT (4. Spreadsheet Concepts) Mind Map on Spreadsheet Concepts, created by eleanorbradbury on 04/11/2013.
Tags

Resource summary

Spreadsheet Concepts
1 characteristics of modelling software
1.1 used to model objects
1.1.1 virtual representation
1.1.2 use of layers
1.1.3 questions can be asked
1.2 used for financial modeling
1.2.1 based on functions and formulae
1.2.2 variables and constants can be used
1.2.3 what-if questions can be asked
2 variables, formulae, rules and functions
2.1 variable - identifier asociated with a particular cell which contains a value
2.2 a formula is a calculation which uses numbers, addresses or cells and mathematical operators
2.3 rules are a set of procedures that must be followed and can also be the sequence of events required for a calculation to work
2.4 a function represents a complex formula that uses reserved words
3 worksheets, workbooks, cells, rows, columns, ranges
3.1 worksheets consists of all the cells in the sheet
3.2 workbook is a collection of work sheets
3.3 row is a range of cells denoted by a number that go across the worksheet
3.4 column is a range of cells denoted by a letter that go down the worksheet
3.5 range is a group of cells denoted by a name or cell references
4 absolute and relative referencing
4.1 relative - the cell referenced in a formula changes when the formula is copied to other cells
4.2 absolute - teh cell referenced in the formula remains exactly the same when the formula is copied to other cells
Show full summary Hide full summary

Similar

MICROSOFT WORD 2013 SKILLS FOR WORK
John O'Driscoll
Types and Components of Computer Systems
Jess Peason
Input Devices
Jess Peason
Output Devices
Jess Peason
General ICT Quiz
leahshaw
ICT Revison Flash Cards
Arun Johal
Networks
Will8324
FLAT FILE VS RELATIONAL DATABASE
rosiejones
Online World - Learning Aim A
andysedge
General ICT Quiz
Jade Fantom
Data Types
Jacob Sedore