A single letter, number, symbol, etc.
It is a help character that is used in some versions of Excel.
Go to Insert Symbol and you can do it from the character sets you will find there. You can also use the Character Map facility in Windows to copy the character into Excel.
The name used in Excel for that data type is Text, but it is like the character data type in other computer systems.
Yes.
Usually a character is considered either text or number.
The hash character which looks like this: #
yes
The ampersand, which is this character: &
In Excel it is the "code" function. For example, Code("A") = 65
insert mode
In the default font used by Excel, a letter refers to any alphabet character, a number refers to any numeric character, a symbol refers to special characters like %, $, &, etc., and a punctuation mark refers to symbols like !, ?, comma, period, etc.
Go to Insert and Symbol and you will find the smiley face in the Winddigs character set.