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.