COMPUTING REVISION

COMPUTING REVISION

1. FUNCTION FORMULA

   • =SUM
   • =AVERAGE
   • =MAX
   • =MIN

2. TYPES OF CHART AND WHAT THEY ARE USED FOR

   • BAR
     • When you want to compare different groups of data
   • SCATTER
     • When you want to compare correlation between sets of data
   • LINE
     • When you want to compare changes over time
   • RADAR
     • When you want to compare similar data with each other
   • PIE
     • When you want to show data proportionally

3. CELL REFERENCES (MATHEMATICAL OPERATORS)

   • + is add
   • - is subtract
   • / is divide
   • * is multiply