Google Educator L2

Google Certified Educator Level 2

Advanced SheetsEnglish
Exam overview

Practice session

In a QUERY-style approach to a Google Sheets gradebook, a teacher wants to summarize average scores grouped by class period without building a traditional pivot table. Which Google Sheets function uses an SQL-like syntax to select, group, and aggregate data in one formula?

Loading your practice session…