Excel Functions Quizzes, Questions & Answers

Top Trending Excel Functions Quizzes

This quiz titled 'Statistical functions' assesses knowledge of Excel's statistical functions like AVERAGE, MIN, and COUNTIF. It tests understanding of function syntax and practical application in data analysis, essential for...

Questions: 8 | Attempts: 1425 | Last updated: Mar 22, 2025

Sample Question 1
Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

=AND()

=NOT()

=OR()

=COUNT()

Sample Question 2
Which of the following is the correct syntax for the COUNTIF function?

=COUNTIF(criteria, field_name, list_range)

=COUNTIF(criteria, field_range)

=COUNTIF(field_range, criteria

=COUNTIF(list_range, field_name, criteria_range)

=COUNTIF(field_name, list_range, criteria_range)

Sample Question 3
Which of the following Excel functions belongs to the Statistical category?

NOW()

TODAY()

AVERAGE

PMT

Excel Functions Quizzes, Questions & Answers

Popular Excel Functions Topics

Top Trending Excel Functions Quizzes