Excel Skills Challenge

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

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

Flashcards are hidden until you start studying

More Like This

Test Your Excel Skills
6 questions

Test Your Excel Skills

PrettySerpentine avatar
PrettySerpentine
Mastering Advanced Spreadsheet/Excel Skills
5 questions
Excel Chapter 1 Test Flashcards
32 questions
Basic Microsoft Excel Module
10 questions
Use Quizgecko on...
Browser
Browser