Statistical Functions
8 Questions
| Attempts: 1304
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()
- 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
Recent Quizzes
Featured Quizzes
Popular Topics
- Algebra Quizzes
- Arithmetic Quizzes
- Calculus Quizzes
- Data Handling Quizzes
- Decimal Quizzes
- Discrete Mathematics Quizzes
- Equation Quizzes
- Multiplication Quizzes
- Number Quizzes
- Percentage Quizzes
- Place Value Quizzes
- Probability Quizzes
- Problem Solving Quizzes
- Ratio Quizzes
- Shape Quizzes
- Statistics Quizzes
- Trigonometry Quizzes
Back to top