Unit Award Scheme

72211 INTERMEDIATE EXCEL - DATA ENTRY

In successfully completing this unit, the Learner will have		Evidence needed
demonstrated the ability to
1	identify at least three pieces of data from a given worksheet, eg items for sale, cost, sales price	Summary sheet
2	identify the correct headings to be used when the data is inputted into a new Excel spreadsheet	Summary sheet
3	enter data into relevant cells under the correct headings	Summary sheet
4	insert a formula to perform a simple calculation within the worksheet, eg total cost multiplied by quantity	Summary sheet
5	link individual excel worksheets into one excel spreadsheet	Summary sheet
6	rename individual worksheets into one excel spreadsheet	Summary sheet
7	print out the completed spreadsheet with support.	Student completed work

All outcomes recorded on an AQA Summary Sheet

Approved 30 June 2015Level - Level One