Head of Department at an Outstanding School. I was nominated as one of the top 50 teachers in the Global Teachers Prize. I am a Microsoft Innovative Expert Educator, a Microsoft Fellow and a Microsoft Certified Trainer working in a Google School. I received the Microsoft Award for innovation in ICT, Education Department Provincial Award for Best ICT Practice and Eduweek鈥檚 Best Classroom Practice.

Last updated

6 July 2019

jpg, 772.17 KB
jpg, 772.17 KB
zip, 236.03 KB
zip, 236.03 KB

Microsoft Excel Worksheet Exercise 3

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. Enter text, numbers and formula
  2. Use several absolute cell references
  3. Use the fill handle to replicate formula
  4. Use the AutoSum feature
  5. Use currency formatting
  6. Include your name and date in the footer
  7. Use page setup to properly format your work
  8. Copy the spread sheet
  9. Show formulas in formula view
  10. Model different outcomes by changing several different variables in the spreadsheet

Please have a look at /teaching-resources/shop/wsparrow
to see other resources.

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

to let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.