86.1k views
0 votes
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?

A. You’re attempting to sort too many cells

B. One or more cells contains relative cell references

C. The cell ranges are incorrect

I didn’t include the last option because it was already wrong on my test

1 Answer

4 votes

this error occurs when a formula tries to divide a number by 0 or na empty cell

User Zstack
by
5.0k points