Spreadsheets 2

Lesson Objectives:

• Learn about data types in Excel
• Learn how to do condition formatting
• Learn how to create an IF statement

Spreadsheet Homework

                               Spreadsheet Homework

• Cells means every little square on the spreadsheet
• Active cell means the square that you are on
• A row means a range of cells that go across horizontally
• A column means a row that goes across vertically
• the symbol to multiply is *
• the symbol to divide is /

Spreadsheets 1

                                    

                                         Spreadsheets 1

• Learning Objectives
• Learn Spreadsheet Key Words
• Create Formulas in a spreadsheet to add,subtract,multiple and divide numbers.

                         To write a Formula you MUST start

                                             with an =

• Formula to add two cells:

      = A6+B7

•  Formula to subtract two cells:

      = A10-H5