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
N
Nsurani
Community Contributor
Quizzes Created: 14 | Total Attempts: 14,873
Questions: 8 | Attempts: 1,388

SettingsSettingsSettings
Statistical Functions - Quiz

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:

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

  • 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
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.