Statistical Functions

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Nsurani
N
Nsurani
Community Contributor
Quizzes Created: 14 | Total Attempts: 15,778
| Attempts: 1,425 | Questions: 8
Please wait...
Question 1 / 8
0 %
0/100
Score 0/100
1. Which Function Gives the minimum value ?

Explanation

The function "MIN" gives the minimum value. It is commonly used in programming and mathematics to find the smallest value among a set of numbers or variables. The "MIN" function compares the values and returns the smallest one. This is useful when you need to identify the minimum value in a dataset or make decisions based on the smallest value.

Submit
Please wait...
About This Quiz
Statistical Functions - Quiz

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,... see moreessential for learners aiming to enhance their Excel proficiency. see less

2. Which of the following Excel functions belongs to the Statistical category?

Explanation

The AVERAGE function belongs to the Statistical category in Excel. This function is used to calculate the arithmetic mean of a range of numbers. It is commonly used to find the average value of a set of data, making it a statistical tool. The NOW() and TODAY() functions are used to retrieve the current date and time, while the PMT function is used to calculate the payment for a loan or investment.

Submit
3. In an Excel worksheet, what would result from =AVERAGE(A1:A3) if A1=10, A2=20 and A3=30?

Explanation

The correct answer is 20 because the AVERAGE function in Excel calculates the average of the numbers in the specified range. In this case, the range A1:A3 includes the numbers 10, 20, and 30. The average of these numbers is (10+20+30)/3 = 20.

Submit
4. What does Count Function Do ?

Explanation

The count function counts the number of cells in a range that contain numbers. It does not count blank cells or cells with text.

Submit
5. What does Counta Function Do?

Explanation

The Counta function counts the number of cells that contain any type of data, including both text and numbers. It does not differentiate between text and numbers and counts both types of data.

Submit
6. In which Function we will find this Syntax ?

Explanation

not-available-via-ai

Submit
7. Except for the …… function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result

Explanation

A formula with a logical function shows the word "TRUE" or "FALSE" as a result, except for the =COUNT() function. The =COUNT() function is used to count the number of cells in a range that contain numbers, and it does not return a logical value of "TRUE" or "FALSE".

Submit
8. Which of the following is the correct syntax for the COUNTIF function? 

Explanation

The correct syntax for the COUNTIF function is =COUNTIF(field_range, criteria). This formula counts the number of cells within the specified field_range that meet the specified criteria.

Submit
View My Results

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.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 21, 2011
    Quiz Created by
    Nsurani
Cancel
  • All
    All (8)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Which Function Gives the minimum value ?
Which of the following Excel functions belongs to the Statistical...
In an Excel worksheet, what would result...
What does Count Function Do ?
What does Counta Function Do?
In which Function we will find this Syntax ?
Except for the …… function, a formula with a logical...
Which of the following is the correct syntax for the COUNTIF...
Alert!

Advertisement