Peter Is Creating a Spreadsheet to Summarize Labor Costs, Which

question 124

Multiple Choice

Peter is creating a spreadsheet to summarize labor costs, which is shown above. He has entered information into the Description column, Quantity/Shoe column, and Total Cost column. However, there are several errors in the Total Cost column.
-What does the #DIV/0 error in cell D15 indicate?

• A) insufficient column width to display data
• B) division by zero
• C) invalid numeric values in formula or function
• D) no answer

---

Definitions:

Drought

An extended period of deficient rainfall relative to the statistical multi-year average for a region, resulting in water scarcity.

Tar Content

The amount of tar, a toxic substance, that is produced and released by burning products, such as cigarettes.

Normally Distributed

A balanced probability distribution around the mean, underscoring that events happening close to the mean are more common than distant events.

Low Tar

A term often used in tobacco product descriptions indicating a lower content of tar compared to regular products.