Case EX 5-2 Sam Is Using the Functions Within Excel

question 35

Multiple Choice

Case EX 5-2 Sam is using the functions within Excel to complete questions in a school homework assignment. Sam needs to find the average of a range of numbers. What would be an example of a formula written correctly?

• A) =AVG(E4,E9)
• B) =AVERAGE(E4:E9)
• C) =AVG(E4:E9)
• D) +AVERAGE(E4:E9)

---

Definitions:

Lewin/Lippitt/White Study

A series of experiments by Kurt Lewin, Ronald Lippitt, and Ralph White that explored the effects of different leadership styles on group behavior.

Leader-Member Exchange Theory

A theory that explores how leader-member relationships develop over time into a system of in-group and out-group members, influencing organizational dynamics and individual outcomes.

Subordinates

Individuals who are ranked lower in terms of authority or position within an organizational hierarchy, often reporting to supervisors or managers.

Transformational Leadership

Is a style of leadership where the leader works with teams to identify needed change, creating a vision to guide the change through inspiration, and executing the change in tandem with committed members of a group.