Mrs Novotny Uses Excel to Track Her Students' Grades

question 40

Multiple Choice

Mrs. Novotny uses Excel to track her students' grades. The first students' quiz scores are stored in Row 2, Columns B through E. Which of the following is a multimath formula which represents the average of the students' quiz scores?

• A) =SUM(B2:E2)
• B) =(B2+E2)/5
• C) =SUM(B2:E2)/5
• D) =B2+C2+D2+E2/5

---

Definitions:

Variable Interest

Interest that can change over the lifetime of a loan, credit line, or other form of financing, usually linked to a fluctuating benchmark rate.

Loss Contingencies

Potential losses that may occur in the future and are recorded in financial statements if they are probable and can be reasonably estimated.

Accrue

The process of recording expenses and revenues that have been incurred or earned, respectively, but not yet received or paid, in order to reflect the true financial position of an entity.

Estimated Loss

An anticipated loss that a company might suffer due to various risks and uncertainties, and which is accounted for in advance.