Podcast
Questions and Answers
Which function allows for summing numerical data in any number of columns or rows by selecting them or typing them?
Which function allows for summing numerical data in any number of columns or rows by selecting them or typing them?
- MAX()
- COUNT()
- AVERAGE()
- SUM() (correct)
How does the SUM() function handle non-numeric values in a range of cells?
How does the SUM() function handle non-numeric values in a range of cells?
- It converts them to numbers
- It ignores them (correct)
- It treats them as zeroes
- It returns an error
Can the SUM() function be used to sum values in non-contiguous ranges of cells?
Can the SUM() function be used to sum values in non-contiguous ranges of cells?
- Only if the ranges are in the same row
- No, it cannot
- Yes, it can (correct)
- Only if the ranges are in the same column