Smartsheet Certification Practice Exam

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

Enhance your Smartsheet skills and prepare for certification with comprehensive quizzes and detailed explanations. Elevate your proficiency and confidence for the Smartsheet Certification Exam.

Practice this question and more.

Which of the following functions returns the average of numeric values in a specified range?

COUNT()
SUM()
AVERAGE()
AVG()

The correct answer is: AVERAGE()

The AVERAGE() function is the appropriate choice for returning the average of numeric values within a specified range. This function calculates the arithmetic mean of the numbers provided as arguments. For example, if you have a range of numbers such as 4, 8, 15, and 16, using AVERAGE() would total these values and then divide by the count of numbers, providing the mean. Other options serve different purposes: COUNT() counts the number of entries in a range, regardless of whether they are numeric or not. SUM() adds together all the numbers in a selected range, and while AVG() is commonly used in various programming languages and database queries to indicate average, it is not a recognized Smartsheet function. In Smartsheet, AVERAGE() is specifically designed for this calculation. Thus, AVERAGE() is the correct function to calculate the average of a set of numeric values.