Spreadsheets Basics Lesson 2

Microsoft Excel Worksheet Exercise 2

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 using an absolute cell reference
3. Understand how to use the fill handle to replicate formula
4. Understand the AutoSum feature
5. Understand how to use currency formatting
6. Understand how to put name and date in the footer
7. Understand how to use page setup to properly format your work
8. Understand how to show formulas in formula view
9. Understand how to make a copy of a spread sheet
10. Understand the term variable
11. Understand how to model different outcomes by changing a variable in the spreadsheet

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