Smartsheet Certification Practice Exam 2026 – Your Comprehensive All-in-One Guide to Success!

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.