Basic Formulas on MS Excel

Addition Formula:
  • If you like to find the sum of your data in rows in your spreadsheet, you may use following formula.
    • =Sum (A1:A3).


Average Formula:
  • If you'd like to find the average of your data, you may use following formula.
    • =Average (A1:A3).


Maximum and Minimum Formula:
  • These two formulas may be used to find the maximum and minimum numbers of data.
    • =Max (A1:A3).


    • =Min (A1:A3).


IF Function:
  • The IF function may be used to apply a condition to your data.
    • = IF(condition;value "if true";value "otherwise").


Freeze Cells:
  • To freeze specific tabs, head to the "View" tab, here, you have the option to either freeze top row or top column.


My notes images: