Excel Displays the Result of a Formula in Its Cell

question 46

True/False

Excel displays the result of a formula in its cell. You can display the formula itself by using the combination of Ctrl and ` (accent) keys at the same time.

---

Definitions:

Type I Error

The mistaken dismissal of an accurate null hypothesis, commonly known as a "false positive" result.

Type II Error

In statistical hypothesis testing, the error that occurs when one fails to reject a false null hypothesis (a false negative).

Significant

Indicates that the results in statistical analysis are likely not due to chance, and there is a certain degree of reliability in the findings.

Power

The probability that a statistical test will correctly reject a false null hypothesis, a measure of a test's capability to detect an effect when there is one.