1 / 19

Spreadsheets

Spreadsheets. Lesson 1: Introduction. Lesson Objectives. To understand what a spread sheet is and how it can be used To identify the features of a spreadsheet To use basic formulae within excel. What is a spreadsheet?.

marklbrown
Télécharger la présentation

Spreadsheets

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Spreadsheets Lesson 1: Introduction

  2. Lesson Objectives • To understand what a spread sheet is and how it can be used • To identify the features of a spreadsheet • To use basic formulae within excel

  3. What is a spreadsheet? • A spreadsheet is used for storing information and data. Calculations can be performed on the data in a spreadsheet • Will be using Microsoft Excel to create and edit spreadsheets • http://www.bbc.co.uk/bitesize/ks3/ict/software_applications/spreadsheets/activity/ • Section 1

  4. This is a spreadsheet What is this? What is this? What is this?

  5. Cell Reference Every cell has a unique name called a Cell Reference. The cell reference for this cell is D12 The cell reference for this cell is G15

  6. What do we use a spreadsheet for? • Spreadsheets aren’t just used to hold tables of data. • We can use them to do calculations, like adding, subtracting, multiplying and dividing. • We do this using a FORMULA

  7. Let’s add the numbers in cells A3 and B3 All formulae start with an = sign Then put the cell reference of the first cell

  8. Let’s add the numbers in cells A3 and B3 All formulae start with an = sign Then put the cell reference of the first cell +

  9. Let’s add the numbers in cells A3 and B3 All formulae start with an = sign Then put the cell reference of the first cell + The cell reference of the second cell

  10. Using Formulae in Spreadsheets The correct answer will now be displayed when you press ENTER

  11. Using Formulae in Spreadsheets 10 If you change one of the numbers used in the calculation

  12. Using Formulae in Spreadsheets 10 16 If you change one of the numbers used in the calculation The answer is automatically updated

  13. Using Formulae in Spreadsheets

  14. Using Formulae in Spreadsheets

  15. Using Formulae in Spreadsheets

  16. Using Formulae in Spreadsheets

  17. Speeding up addition • Sometimes you might have to add a lot of numbers together. If you did this using the + formula it would take a very long time • Instead we can use a SUM formula

  18. Speeding up addition • Just like every formula it starts with an = • As it’s a SUM formula, type SUM • Open brackets • Highlight all the cells that you want to add togeher. It will come up like this (A1:A7) • Close the brackets • Press enter and the answer will appear (A1:A7) SUM =

  19. Speeding up addition • Just like every formula it starts with an = • As it’s a SUM formula, type SUM • Open brackets • Highlight all the cells that you want to add togeher. It will come up like this (A1:A7) • Close the brackets • Press enter and the answer will appear

More Related