intro_to_spreadsheets_y56

intro_to_spreadsheets_y56 - Mr Watsons Introduction to...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Mr Watson’s Introduction to Spreadsheets The ‘Quick ’ and ‘Easy ’ guide to using Microsoft Excel
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
“I kno w wha t a s pre ads he e t is , I c a n e nte r  s im ple  da ta into  a s pre a ds he e t, and I c an  us e  s im ple  fo rm ulae  to  pe rfo rm   c a lc ula tio ns . With he lp I c a n c re a te   s im ple  g ra phs ” By the end of the lesson, I want you to be able to say…
Background image of page 2
Starting at the Beginning What is a Spreadsheet? What are they for? What can they do? A spreadsheet is a powerful tool for organising information. They are used to carry out lots of calculations quickly and  to  store large amounts of information for a range of purposes. Once you know how to do it – they can do almost any maths  that you could need!
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
So, how do they work then? Rows (Side to Side) [Numbered] Columns  (Up and Down) [Letters] Cell (Every one on these  boxes is a cell) Every cell has a name to help you find the right one.   Its name starts with the column letter and then the row number. So, this cell is called what? F22
Background image of page 4
Login and open Microsoft Excel Entering data in spreadsheets is really easy! You just click on the cell and type it in. Let’s do something more difficult then! Let’s use some formulae (that means sums!) In Numeracy, when we write a number sentence we write the ‘=’ sign just before the answer, in a spreadsheet we write it first, before the sum. So when you want a spreadsheet to work out a sum:
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 15

intro_to_spreadsheets_y56 - Mr Watsons Introduction to...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online