Recent Lessons

Show all results for ""

Excel Functions Quiz

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 function in Microsoft Excel is used to sum a range of cells?

AVERAGE
SUM (correct)
MAX
COUNT

Which function in Microsoft Excel is used to find the highest value in a range of cells?

COUNT
AVERAGE
MIN
MAX (correct)

Which function in Microsoft Excel is used to count the number of cells that contain numbers in a range?

COUNT (correct)
AVERAGE
SUM
MAX

Which function in Microsoft Excel is used to find the average value in a range of cells?

AVERAGE Signup and view all the answers

Which function in Microsoft Excel is used to find the largest value in a range of cells?

MAX Signup and view all the answers

Which function in Microsoft Excel is used to find the smallest value in a range of cells?

MIN Signup and view all the answers

Flashcards

SUM function

Adds all numbers in a range of cells.

MAX function

Identifies the largest numerical value in a set of data.

COUNT function

Counts cells containing numbers.

AVERAGE function

Calculates the arithmetic mean of a range.

Signup and view all the flashcards

MIN function

Finds the smallest numerical value from a set of data.