Counting with COUNTIF
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 can be used to count the number of cells that meet a specific criterion?

  • COUNTIF (correct)
  • AVERAGEIF
  • SUMIF
  • MAXIF

What is the syntax of the COUNTIF function?

  • =COUNTIF(What do you want to look for., Where do you want to look.)
  • =COUNTIF(Where do you want to look., What do you want to look for.) (correct)
  • =COUNTIF(Where do you want to look.)
  • =COUNTIF(What do you want to look for.)

How can you count cells that are not blank using a function?

  • SUM
  • COUNT
  • COUNTA (correct)
  • COUNTIF

More Like This

Excel 3 Flashcards
23 questions

Excel 3 Flashcards

ExceedingSodalite avatar
ExceedingSodalite
Excel Chapter 3: End-of-Chapter Quiz
30 questions
Use Quizgecko on...
Browser
Browser