When Using Excel's HYPGEOM

question 2

Multiple Choice

When using Excel's HYPGEOM.DIST function, one should choose TRUE for the fifth input if _____.

• A) a probability is desired
• B) a cumulative probability is desired
• C) the expected value is desired
• D) None of the answers is correct.

---

Definitions:

Heuristic

A problem-solving strategy or mental shortcut that allows people to solve problems and make judgments quickly and efficiently.

Language-like Skills

The abilities related to the use and understanding of complex systems of communication that resemble human language, including syntax, grammar, and the conveyance of abstract concepts.

Grammatical Rules

Guidelines in a language that dictate how words and phrases should be structured to convey clear and correct meaning.

Functional Fixedness

A mental shortcut that restricts an individual to employing an item solely in its conventional manner, obstructing innovative thinking and the ability to solve problems.