Statistical Functions
- 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()
Correct Answer
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)
Correct Answer
C. =COUNTIF(field_range, criteriaExplanation
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
Correct Answer
C. AVERAGEExplanation
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
Correct Answer
C. 20Explanation
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
Correct Answer
B. MINExplanation
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.
Correct Answer
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.
Correct Answer
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
Correct Answer
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, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 21, 2011Quiz Created by
Nsurani