Functions, Sort & Filter

This function helps you find the largest value in the cell range

• MAX

• MIN

• SUM

• AVERAGE

This function helps you find the middle value in the cell range

• MAX

• MIN

• SUM

• AVERAGE

This function helps you find the total value in the cell range

• MAX

• MIN

• SUM

• AVERAGE

This function helps you find the smallest value in the cell range

• MAX

• MIN

• SUM

• AVERAGE

This functions allows you to organise the data in ascending or descending order.

• Sort

• Spreadsheeet

• Worksheet

• filter

This functions allows you to hide and refine results to display data that matches criteria.

• Sort

• Spreadsheeet

• Worksheet

• Filter