Pages in this set

Page 1

Preview of page 1
IT chapter 4 spreadsheet revision

Modelling

Object modelling Financial modelling
Allow a virtual representation to be Often done with spreadsheets
created
Model is interactive: it can be rotated, Easy layout in rows and columns so
zoomed in and out, and different layers everything is logical and easy to follow.
(external…

Page 2

Preview of page 2
Or it could be a cell name e.g. VAT_RATE

Formulas

An instruction to the computer to process data held in specific cells
He way the calculation is represented on the spreadsheet
Formulas use addresses of cells (cell references or names) and mathematical
operators such as * or /
Example of…

Page 3

Preview of page 3
It can be shared with different people Some things have lots of variables and
via email are hard to model like human behaviour
No additional software is needed as
spreadsheets are standard business
software, most people know how to use
them so no training is needed
Quicker and cheaper to…

Page 4

Preview of page 4
Columns

A range of cells that run vertically down the page
They are identified by letters
If a column is deleted then they are renumbered automatically
A column can be hidden from the user

Cell

A data store that holds a piece of data
They are identified by their row…

Comments

Mr A Gibson

A decent set of notes which covers the basics and some more complex facts such as examples of some functions. Gives a good in depth coverage of the basics which will help with exam questions.

Similar ICT resources:

See all ICT resources »See all resources »