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

=COUNTIF(criteria, field_name, list_range)

=COUNTIF(criteria, field_range)

=COUNTIF(list_range, field_name, criteria_range)

=COUNTIF(field_name, list_range, criteria_range)

What does Count Function Do ?

It just Count The cell in which numbers are written.

It just Count The cell in which Text is written.

What does Counta Function Do?

It count the Text and Number both.

It just Count The cell in which Text is written.

It just Count The cell in which numbers are written.

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.

Learn about Our Editorial Process

| By Nsurani

Nsurani

Community Contributor

Quizzes Created: 14 | Total Attempts: 15,086

Questions: 8 | Attempts: 1,398 | Updated: Mar 22, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Questions and Answers

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, 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:

1
0
3.

Which of the following Excel functions belongs to the Statistical category?
- A.
  
  NOW()
- B.
  
  TODAY()
- C.
  
  AVERAGE
- D.
  
  PMT
Correct Answer
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
Correct Answer
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:

1
0
5.

Which Function Gives the minimum value ?
- A.
  
  MAX
- B.
  
  MIN
- C.
  
  Count
Correct Answer
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.
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, 2023

Quiz Edited by
ProProfs Editorial Team
Apr 21, 2011

Quiz Created by
Nsurani

Statistical Functions

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

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

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

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

Which Function Gives the minimum value ?

What does Count Function Do ?

What does Counta Function Do?

In which Function we will find this Syntax ?