Excel Skills Challenge
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

What function should be used to assign grades based on the given range?

  • COUNTIF function
  • SUM function
  • IF function (correct)
  • VLOOKUP function
  • Which function should be employed to calculate the average grade for the 20 students?

  • AVERAGE function (correct)
  • VLOOKUP function
  • COUNTA function
  • SUMIF function
  • Which function is suitable for counting the number of students who received an A grade?

  • COUNTIF function (correct)
  • SUMIF function
  • IF function
  • VLOOKUP function
  • More Like This

    Test Your Excel Skills
    3 questions

    Test Your Excel Skills

    TrustworthyCarnelian avatar
    TrustworthyCarnelian
    Mastering Advanced Spreadsheet/Excel Skills
    5 questions
    IBM Excel Data Fundamentals 3
    18 questions
    Excel Chapter 1 Test Flashcards
    32 questions
    Use Quizgecko on...
    Browser
    Browser