3 Questions
Which function allows for summing numerical data in any number of columns or rows by selecting them or typing them?
SUM()
How does the SUM() function handle non-numeric values in a range of cells?
It ignores them
Can the SUM() function be used to sum values in non-contiguous ranges of cells?
Yes, it can
Test your knowledge of the SUM() function and its capabilities in Excel with this quiz. Learn how to sum numerical data in multiple columns or rows by selecting them or typing them.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free