AI Computer Science Academy · Faisalabad

IT Professional

AVERAGE, MIN and MAX

Task 26 of 56 IT Professional Excel and Google Sheets
All tasks
Read first Task 26

AVERAGE, MIN and MAX

AVERAGE calculates a mean; MIN and MAX return the smallest and largest values. They summarize data without manual sorting. Practice: Calculate average, minimum and maximum for five practice scores. Try this in the application, check the result, then save your work in your IT Practice folder. If an option is unavailable on your device, use the equivalent Microsoft or Google app and record what you observed.

Definition and example

AVERAGE, MIN and MAX means AVERAGE calculates a mean; MIN and MAX return the smallest and largest values. They summarize data without manual sorting. Practice: Calculate average, minimum and maximum for five practice scores. Try this in the application, check the result, then save your work in your IT Practice folder. If an option is unavailable on your device, use the equivalent Microsoft or Google app and record what you observed For example, Which function returns the largest value in a range? Do this in the named application, inspect the result, and save a clearly named copy. This makes the skill repeatable in school, work and everyday online tasks.

IT Professional Excel and Google Sheets

Read this lesson, then create a free account to mark it complete and continue in order.

Sign in to use up to 8 optional task skips in this course.

Next task (mark this task read first)