Understanding Averages in Google Sheets

What is the formula used in Google Sheets to calculate the mean of a set of numbers?

• MODE

• MEDIAN

• AVERAGE

• SUM

How do you determine the median of a dataset in Google Sheets?

• By finding the most frequent number

• By adding all numbers and dividing by the count

• By using the SUM function

• By finding the midpoint between the maximum and minimum values

Which function in Google Sheets helps you find the median value?

• MODE

• SUM

• AVERAGE

• MEDIAN

What is the mode in a dataset?

• The sum of all numbers

• The midpoint of the dataset

• The number that appears most frequently

• The average of all numbers

Which function would you use to find the most frequently occurring number in a dataset in Google Sheets?

• AVERAGE

• SUM

• MEDIAN

• MODE