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 learners aiming to enhance their Excel proficiency.
=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)
Rate this question:
NOW()
TODAY()
AVERAGE
PMT
Rate this question:
40
30
20
10
Rate this question:
MAX
MIN
Count
Rate this question:
It just Count the Blank Cells.
It just Count The cell in which Text is written.
It just Count The cell in which numbers are written.
Rate this question:
It just Count The cell in which Text is written.
It just Count The cell in which numbers are written.
It count the Text and Number both.
Rate this question:
Count
Average
Forcast
Quiz Review Timeline (Updated): Mar 22, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.