Suppose you have a range of cells with numbers and a few blank entries. if you sort the range in ascending order (smallest to largest), where will the blank cells be located after sorting?

After sorting, the blank cells will be located at the bottom of the filled cells.

For the Microsoft excel software, the software has been designed in such a way that the empty cells will always be below the filled cell after sorting action is performed on the cells. Excel typically use blank column to set a data range.