Transcript Functions Main Menu

Sum
AVERAGE CountIf
Add
Basic Way
Multiply
MAX
IF
Excel
Skill Menu
Min
Functions Main Menu
Welcome
Click the tasks at the top.
X
Click here for help.
Kingsbridge Community Collage
Main Menu
Sum and Add Function
There is two way of adding up using function:
• This ways most useful when adding 2 Cells of
2 numbers.
• =A1+A2+A3+A4+A5
But that way is really boring and take a lot of
time. This is what you should use
• =SUM(A1:A5)
X
Kingsbridge Community Collage
Main Menu
Multiply Formula
• Multiply Function is used for 2 things
multiplying Number or Cells
• =A1*A2
• =4*5
X
Pressed Enter
Kingsbridge Community Collage
Main Menu
If Function
• The IF Function is manly used in test to see if
the person got the question right or wrong:
• =IF(B1=5,”Well Done!”,”Fail”)
• IF Cell = 5 Put Well Done! If not put Fail.
X
This is what happens when you type the wrong number in cell B2.
Kingsbridge Community Collage
Main Menu
Average Formula
• The Average Function is used to show the
average number.
• =AVERAGE(A1:A2)
X
Kingsbridge Community Collage
Main Menu
Max
• The Max formula is used to find the maximum
number in a large list.
• =MAX(A1:A9)
X
Kingsbridge Community Collage
Main Menu
Excel
• To open Excel close presentation and go to
start, programs, office, Excel
X
Kingsbridge Community Collage
Main Menu
Min Function
• The MIN Function is used to find the of
Minimum numbers
• =MIN(A1:A2)
X
Pressed Enter
Kingsbridge Community Collage
Main Menu
COUNTIF
• The COUNTIF Function lets you add up
words.
X
Kingsbridge Community Collage
Main Menu
Basic way of doing formulas
• If typing it in is way to hard you can try doing
this but it is babyish!
Then chose a option
X
Go to fx
Then a formula
Kingsbridge Community Collage
Absolute cell reference ($),
Conditional Formatting
Main Menu
Excel
Skill Menu
Click the Options above
X
Kingsbridge Community Collage
Skill Menu
Add
Multiply
Absolute cell reference ($)
• This sign ($) means do not change it is really
useful when adding up cells or multiplying.
• =SUM(A1+$A$2)
X
Kingsbridge Community Collage
Skill Menu
Conditional Formatting
• Conditional Formatting is good for 2 things.
• When you what a cell to automatically change
colour when you type in a number.
• When some one types in a word and the text
go bold.
Step One
X
Kingsbridge Community Collage
Step Two
Step One
Go to Format
Go to Conditional Formatting
X
Kingsbridge Community Collage
Step Three
Step Two
Pick a option
Click format
Type in a word or number
X
Kingsbridge Community Collage
Skill Menu
Font
When done click Skill Menu
Step 3
Click Patterns
Click font
Choose a colour
Pick on of these
Click OK
X
Kingsbridge Community Collage
Colour
Skill Menu
Main Menu
Help ‘?’
You can click this to go to what is says
(Action Buttons)
Screen Shot
This button closes the presentation
X
Back
Kingsbridge Community Collage