Question

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?

Answer 1

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.