# Statistical Functions

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Nsurani
N
Nsurani
Community Contributor
Quizzes Created: 14 | Total Attempts: 14,873
Questions: 8 | Attempts: 1,388

Settings

• 1.

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

• A.

=AND()

• B.

=NOT()

• C.

=OR()

• D.

=COUNT()

D. =COUNT()
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".

Rate this question:

• 2.

### Which of the following is the correct syntax for the COUNTIF function?

• A.

=COUNTIF(criteria, field_name, list_range)

• B.

=COUNTIF(criteria, field_range)

• C.

=COUNTIF(field_range, criteria

• D.

=COUNTIF(list_range, field_name, criteria_range)

• E.

=COUNTIF(field_name, list_range, criteria_range)

C. =COUNTIF(field_range, criteria
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.

Rate this question:

• 3.

### Which of the following Excel functions belongs to the Statistical category?

• A.

NOW()

• B.

TODAY()

• C.

AVERAGE

• D.

PMT

C. AVERAGE
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.

Rate this question:

• 4.

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

• A.

40

• B.

30

• C.

20

• D.

10

C. 20
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.

Rate this question:

• 5.

### Which Function Gives the minimum value ?

• A.

MAX

• B.

MIN

• C.

Count

B. MIN
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.

Rate this question:

• 6.

### What does Count Function Do ?

• A.

It just Count the Blank Cells.

• B.

It just Count The cell in which Text is written.

• C.

It just Count The cell in which numbers are written.

C. It just Count The cell in which numbers are written.
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.

Rate this question:

• 7.

### What does Counta Function Do?

• A.

It just Count The cell in which Text is written.

• B.

It just Count The cell in which numbers are written.

• C.

It count the Text and Number both.

C. It count the Text and Number both.
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.

Rate this question:

• 8.

### In which Function we will find this Syntax ?

• A.

Count

• B.

Average

• C.

Forcast

C. Forcast

Quiz Review Timeline +

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

Related Topics