Which of the Following Is a Nested Function

question 4

Multiple Choice

Which of the following is a nested function?

• A)=IF(AND(B7>5),"Yes","No")
• B)=SUM(B6:B10)
• C)=VLOOKUP(B8,A10:B20,2)
• D)=HLOOKUP(B8,A10:B20,2)

---

Definitions:

Equity Theory

is a theory of motivation that suggests individuals assess their job satisfaction based on the fairness of the rewards they receive relative to others.

Goal-setting Theory

A framework that suggests specific, challenging goals along with appropriate feedback contribute to higher and better task performance.

Comparable Worth

The concept that jobs of equal value to an organization should receive equal pay, regardless of the gender or minority status of the job holders.

Valence

The value an individual places on the expected outcome of an action or behavior, which can influence their motivation.