Which function enables a data professional to count the total number of spreadsheet values within a specified range?1 pointSUMWHOLETOTALCOUNTA

To determine which function allows a data professional to count the total number of spreadsheet values within a specified range, let's evaluate each of the given options:

1. SUM: This function is used to calculate the total of numeric values in a range but does not count the total number of values.

2. WHOLE: This is not a standard Excel function.

3. TOTAL: Like SUM, this term is not an Excel function for counting values (it is often mistakenly used to describe the sum or aggregate).

4. COUNTA: This function counts all non-empty cells in a specified range, including text, numbers, and logical values.

Final Answer

The correct function is COUNTA.