Learning Outcomes

After this practical, you should be able to:

  • insert or delete a worksheet in MS Excel file;
  • identify cells in a worksheet by their names;
  • enter and format data;
  • perform simple arithmetic calculations directly in a cell as well as by referring to another cell;
  • perform operations on a whole column or a row;
  • use absolute and relative references to refer to cells or cell ranges;
  • use Excel functions to calculate mean, median, standard deviation, minimum and maximum values;
  • create simple graphs and charts; and
  • create frequency tables using pivot table functions in Excel.