1 / 11

Introduction to Spreadsheets

Today's lesson focuses on introducing Microsoft Excel and foundational spreadsheet concepts for Year 7 ICT students. We will define cell references and cell ranges, create basic formulas, and learn to use the Functions Toolbar, Formula Bar, Menu, and manipulate rows and columns effectively. Students will practice using formulas to perform addition, subtraction, multiplication, and division on specified cell ranges. The lesson concludes with practical tasks to test understanding, including printing Excel documents.

marin
Télécharger la présentation

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