Module 8 - Advance Functions & Charts
Pre-Assessments
Post-Assessments
Spreadsheet Advanced Functions PowerPoint
Spreadsheet_Advanced_Functions_PPT_updated.pptxGuided Practice: Use IF Statements
Copy of GP_Use_IF-Adv_3.xlsIndependent Practice: Use IF Statements Worksheet
Independent Practice Use if statements directions.docxIndependent Practice: Use IF Statements Spreadsheet
IP_Use_IF-Adv_4.xls
Guided Practice: Understanding the LookUp Functions
GP_Calories-Adv_7.xlsxIndependent Practice: Understanding the LookUp Function
You will need to use the Guided Practice Spreadsheet to continue with this activity.
Guided Practice: Create A List
Copy of Copy of GP_List-Adv_9-1.xlsxIndependent Practice: Create A List
Copy of IP_List-Adv_10.xlsxGuided Practice: Count Functions - We will make our own speadsheet for this task.
Independent Practice: Count Function
IP_Count-Adv_12.xlsxUse Both PowerPoints to Complete the Chart Components Notes
Use Both PowerPoints, below, to Complete the Chart Components Notes &
the 8.04 Spreadsheet Charts~PowerPoint Guide
Types_of_Charts_PPT.pptxSpreadsheet_Chart_Components_PPT.pptxCharting Non-Consecutive Data in MS Excel — Use this step-by-step guide to create chart number 3 (independent work).