A Multi Select column type can be used to select one or more options from a set of predefined options like selecting all the authors that you like or the appliances you have at your home.
The method to set the options is the same as a Single Select column type.
You can use the sort option to sort the rows from first to last or last to first based on the value of this column. Read more about sort here.
Each option can be assigned colors to make the visualization of the sheet better. You can assign these colors by clicking the colors option in the column properties and then selecting a color.