Year 7 ICT @ WBGS

1
Introduction to Spreadsheets

• Year 7 ICT _at_ 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 B2B11
5
Range C3E12
6
Using Formulas
To Add these 2 values
b2b3
7
Using Formulas
To subtract these 2 values
a3-a4
8
Using Formulas
To add these values
b2b3b4b5
9
Using Formulas
To multiply these 2 values
a3b3
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