Google Data Analytics Professional Certification Practice Test

Disable ads (and more) with a membership for a one time $2.99 payment

Prepare for the Google Data Analytics Certification Test with engaging quizzes and comprehensive materials. Master analytics with multiple choice questions and explanations. Enhance your data skills and ace your exam today!

Start Multiple Choice Practice Test
Start Flash Cards

Practice this question and more.

Which function would you use to find the average of a set of values in a spreadsheet?

  1. SUM

  2. AVERAGE

  3. COUNTIF

  4. MEDIAN

The correct answer is: AVERAGE

The AVERAGE function is specifically designed to calculate the mean of a set of values in a spreadsheet. It adds together all the numbers in a specified range and then divides the sum by the count of the numbers. This function is particularly useful for analyzing data sets, as it allows users to quickly determine the central tendency of their data. The SUM function simply adds all the values together without providing insight into their average. COUNTIF is used to count the number of cells that meet a specified criterion, while MEDIAN calculates the middle value in a sorted list of numbers, which is distinct from calculating the average. Therefore, for calculating the average, AVERAGE is the appropriate function to use.

More Questions Like This