Sheets: Using functions

552 Learners | 561 Completed Lessons | 187 Hours of Learning Time

Learning Activity

A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells.

Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. Functions can be used to create formulas that manipulate data and calculate strings and numbers.

Resources

Google spreadsheets function list

Add formulas and functions to a spreadsheet

Watch from 22mins

Bring Google Sheets into Your Classroom Streamline workflows and unlock data-driven learning with Sheets. Alludo equips educators with real-world training to get the most from this versatile tool.

More Sheets Activities

Quickly deploy Sheets lessons to your entire district.

Sheets: Create a blank Sheet

Points 25 | Time 00:10

Sheets: Create a Sheet from a template

Points 25 | Time 00:10

Sheets: Restore a Previous Version

Points 25 | Time 00:15

Sheets: Format and Merge Cells

Points 50 | Time 00:30

Sheets: Sort your Data and Create a Filter

Points 50 | Time 00:25

Sheets: Upload a .CSV or .Xls to Sheets via Drive

Points 25 | Time 00:15

Sheets: Student Introduction and Lesson

Points 75 | Time 00:45

Sheets: Conditional Formatting

Points 50 | Time 00:30

Sheets: Using Charts and Graphs

Points 50 | Time 00:20

Sheets: Using Pivot Tables

Points 25 | Time 00:15

Sheets: Create a Student Resource Sheet

Points 50 | Time 00:30

Sheets: Spreadsheet Vocabulary

Points 50 | Time 00:30

Sheets: Quiz your Students on Spreadsheet Vocabulary

Points 25 | Time 00:15

Sheets: Create a Sheets Assignment

Points 75 | Time 00:45

Top districts trust Alludo to train teachers and staff

ALLUDO, the ALLUDO logo, and PLAY. LEARN. LEAP. are trademarks or registered trademarks of Alpenspruce Education Solutions Inc. in the United States and other countries around the world. All other product and company names are trademarks or registered trademarks of their respective holders. Unless specifically identified as such, Alpenspruce’s use of third-party trademarks does not indicate any relationship, sponsorship, or endorsement between Alpenspruce and the owners of these trademarks.