Year 7/8/9- Full Lesson If Statements and Graph - Excel Spreadsheet

Excel Spreadsheets

Full Lesson If Statements and Graph

**Objectives **
• Understand the use of absolute cell referencing.
• Understand the use of simple functions (sum,max,min and average in a spreadsheet.
• Understand the use of If statements including the logical, true and false statements.
• Understand how calculations can be used as True statements
• Understand the use of nested if statements including more than one true statement.
• Understand the use of count and sum if functions.
• Understand the need the need to present data in a graph format.
• Understanding the need to present information in different forms (graphs)