Excel Mastery

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson
Download our mobile app to listen on the go
Get App

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

Flashcards are hidden until you start studying

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