Unit Award Scheme
116322 MICROSOFT EXCEL: DEVELOPING AND PRESENTING INFORMATION
In successfully completing this unit, the Learner will have | Evidence needed | |
|---|---|---|
demonstrated the ability to | ||
| 1 | open a Microsoft Excel spreadsheet | Summary sheet |
| 2 | enter an appropriate title into the 'Sheet 1' tab of the spreadsheet | Summary sheet |
| 3 | enter given data into at least two columns of a blank Excel spreadsheet | Summary sheet |
| 4 | resize the column of descriptive data so that all data entered lies within the visible column width | Summary sheet |
| 5 | use autosum on the numeric column of data | Summary sheet |
| 6 | insert an empty column after the first column of data entered | Summary sheet |
| 7 | insert an empty row between the data entered and the numeric total | Summary sheet |
| 8 | copy, paste and move at least two pieces of data into different cells | Summary sheet |
| 9 | sort the data in the cells numerically and alphabetically | Summary sheet |
| 10 | identify at least three pieces of data from a given worksheet, eg items for sale, cost, sales price | Summary sheet |
| 11 | save and print off the completed spreadsheet. | Student completed work |
All outcomes recorded on an AQA Summary Sheet
Approved 27 November 2021Level - Entry Level