# 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.