Excel SUM() Function Quiz
3 Questions
1 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

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?

  • 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?

  • 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

More Like This

Excel Formulas and Functions
16 questions

Excel Formulas and Functions

FinestConstellation avatar
FinestConstellation
Excel Formulas and Functions
13 questions

Excel Formulas and Functions

PreferableTanzanite5672 avatar
PreferableTanzanite5672
Use Quizgecko on...
Browser
Browser