Question

mr. robinson has asked his class to give an example of how to find the sum from data ranges. felix raises his hand. when called upon, he states that: a data ranges can be added together with the add function if they are the same data type, such as currency or numerals. b data ranges can be added together with the sum function even if there are different data types such as date, number and text. c data ranges can be added together with the add function even if there are different data types such as date, number and text. d data ranges can be added together with the sum function if they are the same data type, such as currency or numerals.

Explanation:

The SUM function is used for numerical summation. It requires compatible numeric types (e.g., currency, numerals) to calculate a sum. The ADD function typically handles individual values, not ranges, and neither function works with mixed non-numeric types (like text or incompatible dates). Option D correctly identifies the SUM function's requirement for same numeric data types.

Answer:

D. data ranges can be added together with the SUM function if they are the same data type, such as currency or numerals.