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