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:

Labour Standards Legislation

Laws and regulations that establish the minimum requirements for working conditions, such as hours of work, minimum wage, and safety standards.

Pay Equity Legislation

Laws and regulations designed to eliminate the gender pay gap by ensuring that men and women receive equal pay for work of equal value.

Human Rights Legislation

Laws enacted to protect individuals from violations of their rights by individuals, organizations, or governments.

Labour Market Constraints

External and internal factors that limit the availability, mobility, and efficiency of labour within the economy.