Anna Is a Competitive Runner

question 22

Multiple Choice

Anna is a competitive runner.She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year she runs affects her performance.Her worksheet contains the following data: start and end time, total time, and distance.After three months, Anna wants to the know the average distance she runs.What should she do to calculate the average distance?

• A)Enter the text =av in a cell at the end of the distance data; then select the AVERAGE function from the Formula AutoComplete list and then enter the function's argument.
• B)Enter the text =ms in a cell at the end of the distance data; then select the MAX function from the Formula AutoComplete list and then enter the function's argument.
• C)Enter the text =function in a cell at the end of the distance data; then select the AVERAGE function from the AutoFunction list and then enter the function's argument.
• D)Enter the text =su at the end of the data in the Distance column; then select the SUM function from the Select Function list and then enter the function's argument.

---

Definitions:

Accumulated Benefit Obligation

The present value of benefits earned by employees in a defined benefit plan, to be provided at some time in the future based on their service to date.

Pension Liability

The present value of the future pension payments that a company is obligated to pay to its retired employees, representing a financial liability on the company’s balance sheet.

Projected Benefit Obligation

A liability amount in a company's pension plan, estimating the total benefits to be paid to employees in the future.

Plan Assets

Investments and other assets held by a pension fund to be used for the payment of retirement benefits to participants.