Dig/It 9 23

1. Dig/It 9 23 Log into Dig/ It Set a goal for today Record goal in binder

2. Essential Question • How can we use computers to help organize our money? • Outcome 4: Select and Use Tools

3. Mini Lesson: Microsoft Excel • One of the oldest programs that has changed the least • Industry Standard for Business and Management • Located on Dock- green “X”

4. What is aSpreadsheet? A spreadsheet is used for storing information and data. Calculations can be performed on the data in a spreadsheet. Microsoft Excel is the most common spreadsheet application, although there are other spreadsheets available.

5. Parts of aSpreadsheet This is aCOLUMN. Columns are labelled with letters.

6. Parts of a Spreadsheet This is aROW Rows are labelled with numbers.

7. Parts of a Spreadsheet This is aCELL Each cell has a unique CELL REFERENCE

8. Parts of a Spreadsheet The CELL REFERENCEof this cell is E 4

9. Parts of a Spreadsheet The cell that you are currently clicked in is called the ACTIVE CELL.It has a thick black line around it. Any text you type will go in this cell.

10. Parts of a Spreadsheet A LABEL is a piece of TEXT that you add to a spreadsheet to help describe the numbers.

11. Parts of a Spreadsheet These are all LABELS.

12. Parts of a Spreadsheet A VALUE is a NUMBER that you type into a spreadsheet. It is a number that you already know.

13. Parts of a Spreadsheet These are all VALUES.

14. Using Formulas Start

15. Using Formulae in Spreadsheets Let’s add the numbers in cells A3 and B3

16. Using Formulae in Spreadsheets Let’s add the numbers in cells A3 and B3 All formulae start with an = sign

17. Using Formulae in Spreadsheets Let’s add the numbers in cells A3 and B3 All formulae start with an = sign Then put the cell reference of the first cell

18. Using Formulae in Spreadsheets Let’s add the numbers in cells A3 and B3 All formulae start with an = sign Then put the cell reference of the first cell +

19. Using Formulae in Spreadsheets Let’s add the numbers in cells A3 and B3 All formulae start with an = sign Then put the cell reference of the first cell + The cell reference of the second cell

20. Using Formulae in Spreadsheets The correct answer will now be displayed when you press ENTER

21. Using Formulae in Spreadsheets 10 If you change one of the numbers used in the calculation

22. Using Formulae in Spreadsheets 10 16 If you change one of the numbers used in the calculation The answer is automatically updated

23. Using Formulae in Spreadsheets

24. Using Formulae in Spreadsheets

25. Using Formulae in Spreadsheets

26. Using Formulae in Spreadsheets

27. Tutorial CompleteNow complete Budgeteer reward badge to check you understand