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

Question

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

Quizplus · Accepted Answer

The #DIV/0 error in cell D15 indicates that there is a division by zero error in the formula in that cell, meaning that Peter has attempted to divide a number by zero, which is mathematically impossible.

Peter Is Creating a Spreadsheet to Summarize Labor Costs, Which