Values you enter in Categories are remembered and appear in a drop-down list that you can select from. A String is just a regular text field.

If you're going to re-use a string (for example, a type of CD), making that column a Category rather than a String will save you some keyboarding.