Unit Award Scheme

113533

USING FORMULAE AND GRAPHS IN SPREADSHEETS

Level: Level One

In successfully completing this unit, the learner will have	Evidence needed
demonstrated the ability to 1. open a spreadsheet	Summary sheet
2. use an AutoSum tool to successfully calculate the total of at least two cells	Summary sheet
3. input a formula for addition	Summary sheet
4. input a formula for subtraction	Summary sheet
5. input a multiplication formula	Summary sheet
6. input a division formula	Summary sheet
7. use the average function to find the average value of at least two cells	Summary sheet
8. format a table to make its content clear	Summary sheet
9. insert a graph	Summary sheet
10. label the graph	Summary sheet
11. outline what the graph shows	Summary sheet
12. save their work and exit the software	Summary sheet and/or student completed work
shown knowledge of 13. at least two ways spreadsheets can be used in business and industry.	Summary sheet

Approved 28 Apr 2020

If you're interested in registering or would like information on how to expand UAS within your school or college, please complete this online form

Call

8am – 4pm Monday to Friday

Updates and support 9:30am-3:30pm, Monday-Friday.