This is a comparatively small post
and today I am not writing on Excel’s statistical Function. But a rather new
topic. You have often seen that special symbols that very attractive, they are not pictures rather text!
Such symbols are created by using
Fonts that convert text to symbols when applied with certain fonts. I will
discuss only four that are by default present in Excel 2007 viz Symbols,
Webdings, Wingdings, Wingdings 2, and Wingdings 3.
Following is an overview of the Fonts that are present by Default in Excel:
Font Type – “Symbols”:
This mostly consists of Greek
Alphabets & Mathematical Symbols, you can use it to embed mathematical symbols
in you paragraphs, but it is not a replacement to Equation Editor that is
normally used to type Equations.
Font Type – “Webdings”:
Mostly consists of Font-Sized
Pictures that can be used in Texts. Example is a symbol showing Earth &
Clouds.
Font Type – “Wingdings 2”:
Consists of Directional symbols
(hands), clouds showing weather, numbers embedded in circle and squares, stars
and crossed signs (plus sign) etc
Font Type – “Wingdings 3”:
Directional arrows, triangles,
mainly consist of arrows in various variations.
Font Type – “Wingdings”:
Clock showing various times,
arrows, stars and circles, numbers embedded in filled circle, various hand
symbols, computer accessories and mail boxes etc.
The attached file constrains the
characters that you can produce using fonts.
Examples:
Well my posts are incomplete without example, so here are just few to tell you how to use it!
"Is weather cloudy outside??"
We know that we can create Clouds in our formulas using CHAR(213) to CHAR(217) of Webdings. See the example sheet and play with it>
"How was your performance in the Last Exam??"
Use we Wingdings-2's CHAR(60) and CHAR(61) to see a Thumb-Up and Thumb-Down Symbol
"Right, Left, Up or Down??"
Show Directions using Wingding-3's CHAR(33),CHAR(34),CHAR(35) and CHAR(36).
...and there are two more examples in the Example Sheet. You can download this file that contains details of the symbols that can be used in Excel plus examples.
Hopefully you will like the post!! :)
Take care
Faseeh
