1. These are the options for sorting the list of field names in many parts of Manage | Database and other places where you as the designer need to select a field from a list. They are not the options for sorting records.
To sort records for the found set of records shown on a layout, you would select Sort Records from the Records menu. Please note that unsorted records will be displayed in the order they were created.