Excel Functions Quiz - Maya G8

In Task 8 of the Excel activity, what does the COUNTIF function calculate?

• The percentage of students who scored above 80 in the English subject.

• The average score of students in the English subject.

• The sum of scores in the English subject.

• The number of students with scores recorded in the English subject.

Which function is used to count the number of non-empty cells in a range?

• COUNTIF

• AVERAGE

• COUNTA

• SUMIF

In Task 4 of the Excel activity, what does the AVERAGE function calculate?

• The average score of students in the History subject.

• The sum of scores in the History subject.

• The median score in the History subject.

• The highest score in the History subject.

Which function is used to count the number of blank cells in a range in Excel?

• COUNTIF

• COUNTBLANK

• COUNTA

• SUMIF

What is the purpose of the MAX function in Excel?

• To find the lowest value in a range.

• To calculate the median value in a range.

• To calculate the sum of values in a range.

• To find the highest value in a range.

What is the primary use of the COUNTIF function in Excel?

• To calculate the sum of values in a range.

• To count the number of cells in a range.

• To count the number of cells meeting a specific condition.

• To find the highest value in a range.

Which function calculates the median score in Excel?

• MEDIAN

• MAX

• MIN

• MODE

How does the COUNTIF function differ from the COUNTA function in Excel?

• COUNTIF counts the number of non-empty cells, while COUNTA counts cells meeting a specific condition.

• COUNTIF counts cells meeting a specific condition, while COUNTA counts the total number of cells.

• COUNTIF calculates the average of values in a range, while COUNTA calculates the sum of values.

• COUNTIF calculates the sum of values in a range, while COUNTA calculates the average of values.

What is the correct formula to calculate the median score in Excel?

• =MEDIAN(range)

• =MEDIANIF(range, criteria)

• =MEDIANIF(range, criteria, [sum_range])

• =MEDIAN(range, criteria)

In Task 10 of the Excel activity, what does the AVERAGEIF function calculate?

• The average score of students in the Astronomy subject.

• The total number of students who scored above 60 in the Astronomy subject.

• The sum of scores of students who scored above 60 in the Astronomy subject.

• The average score of all students in the dataset.