Everything!!

To print certain things - set print area

To stop cells changing - cell protection

To find the highest

= max(b2:b4)

to find the lowest

= min (b2:b4)

to find the average

= average (b2:b4)

to find the total

= sum (b2:b4)

to subtract

= b2 - b4

to add

= b2+b4

to divide
=b2/b4


Four Labels of a fully labelled chart

x axis
y axis
title
key / legend

IF STATEMENTS!!!

= if (b2>b3, "True", "False")

= if(age >=18, "DRINK!!!!", "No drinking")

=if(age <=16, "No Lottery", if(age >=65, "BINGO!", "Play the lottery!"))

Spreadsheets!

What does Replication mean!?
Copying! (when you copy a formula!)

There are two types of replication (two ways we can copy a formula)

Relative Referencing
* When you copy a formula, the formula will change to suit the new cells it is copied into

Absolute Referencing
Absolute means the formula will not change when replicated and it uses the $$$$$$ to show it is absolute!

Intro To Spreadsheets

Spreadsheets are made up of CELLS!! ( and they can contain TEXT, NUMBERS OR FORMULAE)

A number of cells vertically (up and down) is called a COLUMN

A number of cells horizontally (left to right) is called a ROW


We use Spreadsheets for calculations using formula and can make charts

Four Labels a Fully Labelled Chart should have are ...

X Axis
Y Axis
Title
Key (Legend)

Some Important Stuff!

Search and Replace
lets you change all the occurrences of one word to another by "searching" for a word and telling it what to "replace" it with

Online Help
written instructions that you have to read and follow, better for experienced users

Online Tutorial
video demonstrations or guided lessons that show you what to do, better for beginners

Template
pre-made blank documents with placeholders that let you insert text, images, videos, sounds, charts ...

Wizard
a walk through guide that takes you through the steps to create documents, install programs etc

Static V Dynamic

Data Linkage

Static - when you create a document (eg spreadsheet) and copy into another document (eg a word processing) and you change the original the copy is unaffected.


Dynamic - in this case, when you change the original the copy changes to the exact same as the original!

Standard Paragraph

Pre typed saved paragraphs that you can INSERT! into documents saves time re-typing as its already made, spell checked, formatted etc!

Integrated Packages

Integrated Packages

A package with more than 2 GPPS (General Purpose Packages) combined in the one package


Advantages

+ cost less than buying all the individual GPPS
+ the interface (HCI) will be the same in each part of the package
+ you can transfer data between the seperate parts of the package

Disadvantages

- some of the features are removed(like Grammar Checker)