🎧 New: AI-Generated Podcasts Turn your study notes into engaging audio conversations. Learn more

Excel Mastery
3 Questions
0 Views

Excel Mastery

Created by
@EagerRhodochrosite

Podcast Beta

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 Quizzes 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 2019 Mastery Quiz with Cindy
    5 questions
    Use Quizgecko on...
    Browser
    Browser