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
Correct Answer:

Verified
Correct Answer:
Verified
Q119: The _ function calculates a minimum in
Q120: When the formulas are displayed, the worksheet
Q121: If 5% is displayed in a cell,
Q122: If a column shows the numbers 1,
Q123: A cell reference that has only one
Q125: Describe three ways to correct the formatting
Q126: The Excel error message for "no answer"
Q127: The _ function calculates the maximum in
Q128: The Excel operator for exponent is _.<br>A)
Q129: The error message ###### means that there