Ma6ttecartrubysto
Answered

If you sort a portion of an Excel sheet and you get an error message such as #DIV/0, what is a likely cause of the error message?

AThe cell ranges are incorrect.
BOne or more cells contain absolute cell references.
CYou're attempting to sort too many cells.
DOne or more cells contain relative cell references.

Verified Answer :

If you sort a portion of an Excel sheet and you get an error message such as #DIV/0, the cause of the error message is (B) one or more cells containing absolute cell references. The possible reason of this error message includes: (1) entering division formula that divided by zero (0), (2) and that is being used as a reference.