null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
43442
Spreadsheet Concepts
Description
A2 ICT (4. Spreadsheet Concepts) Mind Map on Spreadsheet Concepts, created by eleanorbradbury on 11/04/2013.
No tags specified
4. spreadsheet concepts
ict
ict
4. spreadsheet concepts
a2
Mind Map by
eleanorbradbury
, updated more than 1 year ago
More
Less
Created by
eleanorbradbury
over 11 years ago
78
1
0
Resource summary
Spreadsheet Concepts
characteristics of modelling software
used to model objects
virtual representation
use of layers
questions can be asked
used for financial modeling
based on functions and formulae
variables and constants can be used
what-if questions can be asked
variables, formulae, rules and functions
variable - identifier asociated with a particular cell which contains a value
a formula is a calculation which uses numbers, addresses or cells and mathematical operators
rules are a set of procedures that must be followed and can also be the sequence of events required for a calculation to work
a function represents a complex formula that uses reserved words
worksheets, workbooks, cells, rows, columns, ranges
worksheets consists of all the cells in the sheet
workbook is a collection of work sheets
row is a range of cells denoted by a number that go across the worksheet
column is a range of cells denoted by a letter that go down the worksheet
range is a group of cells denoted by a name or cell references
absolute and relative referencing
relative - the cell referenced in a formula changes when the formula is copied to other cells
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
Want to create your own
Mind Maps
for
free
with GoConqr?
Learn more
.
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
Browse Library