83286

ICT: CREATING AND USING A SPREADSHEET

Level: Entry Level

In successfully completing this unit, the learner will haveEvidence needed

demonstrated the ability to

1. load a speadsheet package

Summary sheet

2. use text to enter column and row headings

Summary sheet

3. enter numeric data into cells

Summary sheet

4. save and print out the initial spreadsheet

Summary sheet or student completed work

5. insert an additional row

Summary sheet

6. insert an additional column

Summary sheet

7. use the AutoSum key to total columns

Summary sheet

8. copy and paste a formula across a row

Summary sheet

9. insert a simple formula correctly, eg multiplying the sale price by the total sold to determine the total sales

Summary sheet

10. save the spreadsheet under a new name

Summary sheet

11. print the completed spreadsheet

Student completed work

12. print the completed spreadsheet to show formulae.

Summary sheet or student completed work

Approved 15 May 2002

Want more information or got a question?

Want more information or got a question?

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

Contact us

Call

01423 534 235

8am – 4pm Monday to Friday

Join the conversation

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

Follow us on Facebook Follow us on Instagram Follow us on LinkedIn Follow us on X