Google Data Analytics Professional Certification Practice Test

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

Prepare for your Google Data Analytics exam. Practice with comprehensive questions and descriptive explanations. Be exam-ready!

Each practice test/flash card set has 50 randomly selected questions from a bank of over 500. You'll get a new set of questions each time!

Practice this question and more.

What does the SUM function do in a spreadsheet?

Calculates average values
Multiplies values in selected cells
Adds values to a selected range of cells
Counts the total number of entries

The correct answer is: Adds values to a selected range of cells

The SUM function in a spreadsheet is designed specifically to add together all numeric values contained within a designated range of cells. When you use the SUM function, it evaluates each cell in the specified range and calculates the total by summing up these values. For example, if you apply the SUM function to a range containing the numbers 5, 10, and 15, the result would be 30, which is the cumulative total of those values. The other options focus on different types of calculations: calculating averages involves the AVERAGE function, multiplying values is conducted using the PRODUCT function or the multiplication operator (*), and counting entries typically relies on the COUNT function. These functions serve distinct purposes within data analysis and are not interchangeable with the SUM function.