1 / 11

Introduction to Spreadsheets

Introduction to Spreadsheets. Year 7 ICT @ WBGS. Today's Lesson…. Introduce Excel Define a Cell Reference and Cell Range Create Formulas Use Functions. Toolbar. Formula Bar. Menu. Rows. Cell. Columns. Highlighted Cells. Range B2:B11. Range C3:E12. Using Formulas.

marin
Download Presentation

Introduction to 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. Introduction to Spreadsheets Year 7 ICT @ WBGS

  2. Today's Lesson… • Introduce Excel • Define a Cell Reference and Cell Range • Create Formulas • Use Functions

  3. Toolbar Formula Bar Menu Rows Cell Columns

  4. Highlighted Cells Range B2:B11

  5. Range C3:E12

  6. Using Formulas To Add these 2 values =b2+b3

  7. Using Formulas To subtract these 2 values =a3-a4

  8. Using Formulas To add these values =b2+b3+b4+b5

  9. Using Formulas To multiply these 2 values =a3*b3

  10. Using Formulas To divide A6 and B9 =a6/b9

  11. Your Tasks • Intranet • Excel Practical Test • Complete the Test • Read printing instructions • Print Test from Excel

More Related