Excel 2: Applications (365)

microsoft-excel-365 This module provides more Microsoft Excel activities, including relative and absolute cell references, formulas, functions, sorting, filtering, and spreadsheet formatting.

Phase: Learn & Practice

learn-and-practice

Unit 1: Using Formulas and Functions

In this unit, students learn about Excel formulas, relative and absolute cell references, AutoFill, common functions, and the IF function.

Lessons:

A Pancake Recipe (Part 1)
A Pancake Recipe (Part 2)
Coffee Shop Inventory

Unit 2: Data Management and Analysis

In this unit, students learn about sorting in ascending and descending order, sorting based on multiple criteria, and filtering using column entries and custom criteria.

Lessons:

Sorting a Membership List
Filtering an Employee List

Unit 3: Formatting in Excel

In this unit, students learn about formatting and conditional formatting in Excel as they make an existing spreadsheet more visually appealing.

Lessons:

Overdue Library Books
Make It Look Great

Phase: Reinforce

Project: Who's Who - Age is Only a Number

In this project, students research and calculate the exact ages of well-known people. Students then calculate the youngest, oldest, and average ages. They also calculate the age differences between themselves and the famous people they chose.

Project: Using an Excel Template

In this project, students will download a template and customize it based on a specific assignment selected by the teacher.

Back to Catalog