Unit Award Scheme

105727

Basic working with Excel spreadsheets

Level: Entry Level

In successfully completing this unit, the learner will have	Evidence needed
demonstrated the ability to 1. open a Microsoft Excel spreadsheet	Summary sheet
2. locate and identify given cells within the spreadsheet	Summary sheet
3. iIdentify at least two pieces of data from a given worksheet, eg items for sale, cost price	Summary sheet
4. identify the correct headings to be used when data is input into the spreadsheet	Summary sheet
5. enter given data into the relevant cells under the correct headings	Summary sheet and/or student completed work
6. set cell format on all relevant cells to a given currency to two decimal places	Summary sheet and/or student completed work
7. add the requested formatting to the worksheet, eg font, cell colour and border	Summary sheet and/or student completed work
8. rename individual worksheets in the spreadsheet with an appropriate name	Summary sheet and/or student completed work
9. save the spreadsheet with an appropriate name	Summary sheet
10. print the spreadsheet and exit the program.	Summary sheet and/or student completed work