Spreadsheets - Basic formula introduction.pptx

IGCSE ICT Formulas in Spreadsheets (Excel)

1. Spreadsheets Basic Formula Introduction

2. Value of the week “A Healthy living for a Strong body and mind”

3. Lesson objectives To be able to u se arithmetic operators in formulae including add, subtract, multiply, divide. 3

4. STARTER 4 Which are the 4 operators for calculation given on the right side of the keyboard?

5. Mathematical operators Excel uses standard operators for formulas All formulas in Excel must begin with an  equals sign  ( = ). This is because the cell contains, or is equal to, the formula and the value it calculates. 5

6. Examples of simple formula 6

7. TASK 1 - Excel Create the following excel sheet on Excel with all the right formatting as shown in the picture. Calculate the blank values using appropriate formula

8. TASK 2 - Excel Create the following excel sheet on Excel with all the right formatting as shown in the picture. Calculate the blank values using appropriate formula

9. Plenary 9 Which are the operators you used for today’s tasks ? Which are the other operators that are available in Excel?