Instruction on using IF, COUNT, AVERAGE, SUM, and nested formulas to perform calculations.
What students will learn
- Define the purpose of spreadsheet functions in data analysis.
- Identify the correct syntax for SUM, AVERAGE, COUNT, and IF functions.
- Calculate totals and averages using range references in a worksheet.
- Apply the IF logical function to assign conditional results to cells.
- Construct nested formulas to solve multi-step problems.
Already available for this topic
Lesson note
Sign up free to generate these and download them as PDF, Word or PowerPoint.
Start your free 14-day trialLooking for a different topic? Browse all Digital Technologies topics or the full library.