- Find average =AVERAGE(C2:C9)
- Find total =SUM(G2:G12,G16)
- Highest or lowest value =MAX(B3:B8)
- Check if a condition is met =IF(test,if true, if false)
- =SUMIF(range,criteria,sumrange)
Showing posts with label School. Show all posts
Showing posts with label School. Show all posts
Monday, 28 March 2011
What we learnt about Excel
Here are some Excel formula we used in IT today:
Sunday, 27 March 2011
Monday, 21 March 2011
Rules!
- No under lining
- Three colours max
- No centered titles
- Columns
- Use colours from within photos
- Make use of the space you have
- Only send or upload pdf
Subscribe to:
Posts (Atom)