Excel Mastery
3 Questions
0 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 Excel function can be used to count the number of cells in a range that meet a certain criteria?

  • SUM
  • AVERAGE
  • MAX
  • COUNT (correct)
  • What is the measure of central tendency that is most affected by outliers in a dataset?

  • Range
  • Mean (correct)
  • Mode
  • Median
  • What is the Excel function used to search for a specific value in the first column of a table and return a corresponding value in the same row from another column?

  • VLOOKUP (correct)
  • HLOOKUP
  • INDEX
  • MATCH
  • More Like This

    Excel Mastery
    15 questions

    Excel Mastery

    EncouragingTaiga avatar
    EncouragingTaiga
    Excel Mastery Quiz
    5 questions

    Excel Mastery Quiz

    SupportedZeal avatar
    SupportedZeal
    Excel Mastery Quiz
    5 questions

    Excel Mastery Quiz

    EnchantedLepidolite avatar
    EnchantedLepidolite
    Excel Mastery Quiz
    5 questions

    Excel Mastery Quiz

    FeistyWoodland avatar
    FeistyWoodland
    Use Quizgecko on...
    Browser
    Browser