The HLOOKUP Function

question 42

Multiple Choice

The HLOOKUP function

• A) is the periodic interest rate, such as a monthly interest rate.
• B) calculates the periodic payment for a loan with a fixed interest rate and fixed term.
• C) looks up a value in a lookup table where the first column contains the values to compare with the lookup value.
• D) looks up a value in a lookup table where the first row contains the values to compare with the lookup value.

---

Definitions:

Validity

The extent to which a concept, conclusion, or measurement is well-founded and corresponds accurately to the real world.

Psychometric Approach

The psychometric approach focuses on measuring mental capacities and processes through quantitative tests.

Correlations

Statistical measures that describe the extent to which two variables change together, indicating a relationship between them without implying causation.

Predictive Validity

How well a score from a given test or scale indicates an individual’s subsequent performance on a task that is related.