Spreadsheet Formulas Lesson Outline Created by The University

Spreadsheet Formulas Lesson Outline Created by The University of North Texas in partnership with the Texas Education Agency

II. Relevance of Spreadsheets to Everyday Life A. Purpose of a spreadsheet 1. 2. 3. 4. 5. Keep track of money Keep up with statistics Managing information Analyzing information Presenting information UNT in partnership with TEA, Copyright ©. All rights reserved. 2

II. Relevance of Spreadsheets to Everyday Life B. Before electronic spreadsheets… 1. How do you think businesses kept up with finances, payroll, inventory, etc. before computers? 2. How do you think electronic spreadsheets have transformed businesses today? UNT in partnership with TEA, Copyright ©. All rights reserved. 3

II. Relevance of Spreadsheets to Everyday Life C. Brainstorm some ways that spreadsheets can be used in everyday life: 1. Sports Stats (ex. Batting average) 2. Grades 3. Budgets 4. Inventory 5. Buying a car UNT in partnership with TEA, Copyright ©. All rights reserved. 4

III. Basic Formulas in Excel A. Addition – Formula is: =cell 1+cell 2+cell 3+cell 4 (and so on) Example: =a 1+a 2+a 3+a 4 will add the values in cells a 1, a 2, a 3 and a 4 UNT in partnership with TEA, Copyright ©. All rights reserved. 5

III. Basic Formulas in Excel B. Subtraction – Formula is: =cell 1 -cell 4 Example: =a 1 -a 4 will subtract the value in cell a 4 from the value in a 1 UNT in partnership with TEA, Copyright ©. All rights reserved. 6

III. Basic Formulas in Excel C. Multiply – Formula is: =cell 1*cell 4 Example: =a 1*a 4 will multiply the value in cell a 1 by the value in a 4 UNT in partnership with TEA, Copyright ©. All rights reserved. 7

III. Basic Formulas in Excel D. Divide – Formula is: =cell 1/cell 4 Example: =a 1/a 4 will divide the value in cell a 1 by the value in a 4 UNT in partnership with TEA, Copyright ©. All rights reserved. 8

IV. Assignment: Create a spreadsheet with formulas Create your own personal Budget………… Thing you might add: Salary, Allowance, Expenses (phone bill, gas, movies, eating out etc) You must include more then 6 expenses…(if you don’t have 6, I’ll give you 6 UNT in partnership with TEA, Copyright ©. All rights reserved. 9