# Statistical Functions

8 Questions | Attempts: 1304
Share  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()

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

• 3.
Which of the following Excel functions belongs to the Statistical category?
• A.

NOW()

• B.

TODAY()

• C.

AVERAGE

• D.

PMT

• 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

• 5.
Which Function Gives the minimum value ?
• A.

MAX

• B.

MIN

• C.

Count

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

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

• 8.
In which Function we will find this Syntax ?
• A.

Count

• B.

Average

• C.

Forcast

## Related Topics Back to top
×

Wait!
Here's an interesting quiz for you.