Spreadsheets Basics Lesson 1

Microsoft Excel Worksheet Exercise 1

These basic spreadsheet units are ideal for students, non-specialist computing teachers, NQTs and any person that would like to learn how to use Excel / spreadsheets. These worksheets cover the basics and are ideal for KS2 /3

This worksheet is designed for independent study by students. There are instructions for the students, a Microsoft Excel template for the students to work on, as well as a completed Excel document so that the teacher can show / compare what they have done.

**Learning Objectives **

1. Understand how to enter text, numbers and formula
2. Understand how to use the fill handle to replicate formula
3. Understand the AutoSum feature
4. Understand how to use currency formatting
5. Understand how to include your name and the date in the footer
6. Understand how to use page setup to properly format your work
7. Understand how to copy the spread sheet
8. Understand how to show the formulas in formula view

Please have a look at https://www.tes.com/teaching-resources/shop/wsparrow
to see other resources.