Tuesday 22 November 2011

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!"))

No comments:

Post a Comment