Unit Award Scheme

105728 USING FORMULAE IN EXCEL

In successfully completing this unit, the Learner will have		Evidence needed
demonstrated the ability to
1	open a Microsoft Excel worksheet	Summary sheet
2	sort data within Excel	Summary sheet
3	insert a formulae using +, -, * or / to perform a simple calculation within the worksheet, eg total cost multiplied by quantity	Summary sheet
4	use the autosum facility within Excel, eg SUM, AV, MAX, MIN	Summary sheet
5	print out the worksheet, showing formulae	Student completed work
6	save the spreadsheet with an appropriate name	Summary sheet
7	exit the Microsoft Excel Program.	Summary sheet

All outcomes recorded on an AQA Summary Sheet

Approved 23 March 2017Level - Level One