ࡱ> %'$q` #bjbjqPqP 86::V $ $ )2!(>!>!>!>!>!>!>!())))))$*h-$)>!>!>!>!>!$)>!>!9)""">!>!>!(">!("":(,(>! ! )!o# T!FF( (O)0)P(R-!-(-(\>!>!">!>!>!>!>!$)$)" >!>!>!)>!>!>!>! D > >40"R Formatting Cells in Excel (Version 2) What do I mean when I say formatting cells in Excel? To format a cell means to change how whats in the cell looks. Formatting a cell does not change whats in the cell, only how it looks. This is a very important thing to remember. The Big Three You already know (I hope) how to use the Big Three of formatting: bold, italics, and underline. In case you forgot, you can manipulate those using these three buttons:  EMBED Photoshop.Image.7 \s  EMBED Photoshop.Image.7 \s  Color Me Crazy! You can change the colors of your text and background in Excel very easily. To change the text color, you can highlight the cell you want to change the color of and click on the  button. Clicking on the  will give you a list of colors to choose from. The bar under the A will always show the currently selected color. To change the background color of a cell, click on the  button. Again, clicking on the  will give you a list of colors. A Different Kind of Formatting In Excel, we work with all kinds of data. Data are simply pieces of information. Some different kinds of data are regular numbers (i.e. 1, 2 13, 233, and so on), dates, currency (i.e. how much was your electric bill), ZIP codes, a list of names, and so on. Excel can format your data in dozens of ways. For example, if you type March 1, 2005 into Excel and press enter, Excel changes it to 1-Mar-05. This is just one way Excel can format a date. >> Important Information: To format a cell to hold a certain type of data, right-click on the cell and select Format Cells tthen click on the Number tab. << Different Format Categories and a Description of Each General: This is used if youre not really sure what kind of data is going into a cell. This is the default value. (A default value is the one that is selected when you start a new spreadsheet.) Number: This setting is used if you know youre going to have numbers in your cells. You can change the following settings in the Number category: Decimal Places: This changes how many numbers there are after a decimal place. For instance, if you set Decimal Places to 2, the number 2.5456 would be displayed as 2.55. Excel rounds to the nearest decimal place you set. Use 1000 separator (,): Use this setting if you want your numbers to have a , between each thousands place. For example, 1433 gets displayed as 1,433 if this box is checked. Negative Numbers: This changes how Excel handles negative numbers. You can change them to show a negative sign, turn red, turn red in parentheses, etc. Currency: Use this setting if youre going to be dealing with money but you dont need the decimal places to line up. Currency works just like the Numbers category except you can choose the symbol that goes in front of the number. (The default symbol is the $ sign, which is the American symbol for money.) Accounting: Use the accounting format if you want the decimal places to line up in the columns. Otherwise, its just like currency. Date: Use this category if your cell will hold a date. There are a bunch of Date types to choose from. For example, you can make March 1, 2005 look like: 3/1 1-Mar Mar-1 Remember, formatting a date to look a certain way does not change the actual date. Time: Use this category if youre going to store a time (i.e. 5pm). Like Date, there are a ton of ways to represent a time. Percentage: Use this setting if youre going to have percentages in your cell. It adds a percent sign and you can set the number of decimal places. >> Important Information: You must enter your percentages in decimal form even if you format a cell as a percentage. For example, if you have formatted your cell as a Percentage and want your cell to show 50%, you must enter .5 in the cell. If you try to enter 50, Excel will show 5000% << Fraction: Use this setting if you want decimal numbers to be shown in a fractional format. If you format a cell as a fraction and enter .5 in the cell, it will appear as 1/2. This is very useful for converting fractions to decimals and vice versa. >> Important Information: The best setting for the Fraction category is Up to Three Digits. This will give you the most accurate fractional representation of your decimal numbers. << Scientific: This is used to display numbers in scientific notation. We wont be using it in our class, but I would like you to know that its there. If you really want to know what scientific notation is, visit: http://www.nyu.edu/pages/mathmol/textbook/scinot.html or you can ask me. Text: Use this setting if you want Excel to interpret anything you put in the cell as text. If you set the format to text, if you put 1 in a cell and 2 in a cell, you wont be able to do any math on those numbers: Excel will treat them the same way as the letter A or the word Hello! Special: This is a really neat category. It has settings for all the following kinds of information: ZIP Code ZIP Code + 4 Extra Digits (used in bigger cities) Phone Numbers Social Security Numbers Custom: The custom category is very powerful but beyond the scope of this class. See me after class if you would like to know more about how to use it! Assignment Using All This Use the knowledge above to format an Excel spreadsheet as follow. Read each step very carefully. Open a new spreadsheet. Click on File | Page Setup and select the Page tab. Select Fit to 1 Pages Wide by 1 Pages Tall (This shrinks the text of the spreadsheet so that no matter how much stuff you put on the screen, it will all fit on one page.) In cell A1, type your first and last name. In A2, type My Birthday (without the quotation marks). In B2, type your birthday like Jan 16, 1982 (without the quotation marks) and press enter. Notice how Excel formats the date you typed in. In cell A3, type My Birthday Another Way. In cell B3, type your birthday again. Right click on B3, go to Format Cells, make sure the Date category is selected, and change the type to the format that looks like this: January 16, 1982 In A4, type: Minimum Wage In B4, type 5.15 Right click on B4, go to Format Cells, select the Currency category, and make sure Symbol is set to $. Note: Now youll have to figure out how to format this stuff yourself! Refer to the list of categories above it you need help! In A5, type Minimum Wage as a Fraction: In B5, type 5.15. Format B5 so that the number appears as a fraction up to three digits. In A6, type: A Decimal Number In B6, type: .5 In A7, type: A Percentage In B7, type: .5 Format B7 as a percentage. In A8, type: A Fraction In B8, type: .5 Format B8 as a fraction up to three digits. In A9, type: 5PM as Military Time. In B9, type: 5 pm Format B9 so that it appears as military time (i.e. 17:00:00) Choose any 3 cells in column 2 and change the font colors to whatever you prefer. Choose any 3 cells in column 2 and change the background colors to whatever you prefer. What have you learned? Hopefully, you learned how to format numbers in Excel depending on what they represent. %&  ` d f m s |       ^ zvnvfvjZh_Uj h_Uh_j hUTUjH hUTU hUThUTjhUTUjZhUTUjE hUTUVjE hUTUVjhUTUhUThUT>*hUThUT6hUThUT5 hT3hUThT3hT3hUT56hT3hUT5h=h|hUT&&   ZTUu ABbgdG  & Fgd*$a$gdUTgd*gdUT$a$gd*#  ! I *7KQVWYZU]tu  BMefEPעווםםב~thLGh .B5CJh .B h .B5 hLG5 hLG6hLGhG hG 5 hG 5hG h*5h*h*5 h*5h;ah*5CJh;ah;a5CJh;ah*h*6hG hG hG 5CJ h;a5CJh* hT36hT3 h*hT3,bflrsDEZdXYgd .BgdG  DVYZWu +N!#+}hMh|h|6 h|6h| h]r=h]r= h]r=6huP h@#5h@#h .Bh .B5h .Bh .B>* h .B5 h .B6 hLG5CJhLGhLG5CJ h;a5CJhLG hLG5h;ah;a5CJh;ah .B h .B5CJ/YZ[u$3B D!d!t!!! & Fgd]r=gd- & FgduPgd]r=$a$gduPgdG +8HL  B G !!G!I!g!i!w!y!!!!!!!!!!!""7"9"M"O"".#0### huPhuPh-h;ahQ3h]r= h-5h-h-5h|huP huP64!!!!"4"F""".#/#0##gduP & FgdQ3 & Fgd]r= & FgduP 6&P1h:p|/ =!"#$% ZDd 0  # A"19(H87/BξR)5p}Z:-=jK]U<-HvDH Έv2Y@: drD_~l?ۏ~^I!hnZDd 0  # A"19(H87/BξR)5p}Z:-=jK]U<-HvDH Έv2Y@: drD_~l?ۏ~^I!hnDd  D  C Abiub> apfa%Rn> apfa%RPNG  IHDRE#7\`PLTEZ\] 7bKGDH cmPPJCmp0712HsIDATHK@ E/(.*&}<4i:&e|<=\<s!eVV*=֪ QYHܝTR ySݝ. %, ZXZäe9e:Tb)Xza+]$-i:Es5HB6qIiiWFx/ӣfoLk!#ڨ|_+(Vdޣ{==@]!*hIENDB`Dd @  C Aab).&?_1LJh n).&?_1LJhPNG  IHDR#w%`PLTE8Tⲭf54NbKGDH cmPPJCmp0712HsIDAT8Or D(4m&-%XNyAڠ[ >be 桶q)8fl8}M@=U$N=Q( S2b횿$%  !"#I&)K9+,-./012345678L;<=>?@ABCDEFGHJMOPQRSTUVWXYZ[\]^_`abcdRoot Entry FP!o#(Data ZWordDocument86ObjectPoolpH!o#P!o#_1171647182 bŠ"AW߈|3pH!o#0!o#Ole CompObjdObjInfo  Adobe Photoshop ImageAdobe Photoshop Image9q  Adobe Photoshop ImageAdobe Photoshop Image9q CONTENTS*7_1171647189 bŠ"AW߈|30!o#)!o#Ole CompObj d8BPS#E8BIM%8BIM$) adobe:docid:photoshop:af8d5548-8eaa-11d9-8ecb-addb48179c83 8BIMHH8BIM&?8BIM x8BIM8BIM 8BIM 8BIM' 8BIMH/fflff/ff2Z5-8BIMp8BIM@@8BIM8BIM5#EE#nullboundsObjcRct1Top longLeftlongBtomlong#RghtlongEslicesVlLsObjcslicesliceIDlonggroupIDlongoriginenum ESliceOrigin autoGeneratedTypeenum ESliceTypeImg boundsObjcRct1Top longLeftlongBtomlong#RghtlongEurlTEXTnullTEXTMsgeTEXTaltTagTEXTcellTextIsHTMLboolcellTextTEXT horzAlignenumESliceHorzAligndefault vertAlignenumESliceVertAligndefault bgColorTypeenumESliceBGColorTypeNone topOutsetlong leftOutsetlong bottomOutsetlong rightOutsetlong8BIM8BIM8BIM!UAdobe PhotoshopAdobe Photoshop 7.08BIM"&MM*bj(1r2iHHAdobe Photoshop 7.02005:03:06 20:47:09E#(&HH!!!W\Q ^^޼ݼۼټ׼ռۼVbW^^޼ܼڼؼּԼҼؼ T~ߧg߯] \\ܼؼռӼѼμ̼ʼObjInfo CONTENTS:71TableN-SummaryInformation(8BPS#E8BIM%8BIM$) adobe:docid:photoshop:d18b9c79-8eaa-11d9-8ecb-addb48179c83 8BIMHH8BIM&?8BIM x8BIM8BIM 8BIM 8BIM' 8BIMH/fflff/ff2Z5-8BIMp8BIM@@8BIM8BIM5#EE#nullboundsObjcRct1Top longLeftlongBtomlong#RghtlongEslicesVlLsObjcslicesliceIDlonggroupIDlongoriginenum ESliceOrigin autoGeneratedTypeenum ESliceTypeImg boundsObjcRct1Top longLeftlongBtomlong#RghtlongEurlTEXTnullTEXTMsgeTEXTaltTagTEXTcellTextIsHTMLboolcellTextTEXT horzAlignenumESliceHorzAligndefault vertAlignenumESliceVertAligndefault bgColorTypeenumESliceBGColorTypeNone topOutsetlong leftOutsetlong bottomOutsetlong rightOutsetlong8BIM8BIM8BIM!UAdobe PhotoshopAdobe Photoshop 7.08BIM"&MM*bj(1r2iHHAdobe Photoshop 7.02005:03:06 20:47:14E#(&HH!!!W\Q ^^޼ݼۼټ׼ռۼVbW^^޼ܼڼؼּԼҼؼ T~ߧg߯] \\ܼؼռӼѼμ̼ʼO- %yZl{Z WP$4CΒty~pNk|:=`G$rIENDB`DdR  C .Adown_arrowbZbI[6n.bI[PNG  IHDRԭ`PLTEkbKGDH cmPPJCmp0712HsSIDAT(S9@du@"':hv셧 !aFS8Ēu/%lB%LB' pQ0i~IENDB`Oh+'0  $0 P \ ht|Formatting Cells in ExcelJerry T. Smith Normal.dotJerry T. Smith9Microsoft Office Word@@j"@o#DocumentSummaryInformation80CompObjq՜.+,0 hp|  2 Formatting Cells in Excel Title  FMicrosoft Office Word Document MSWordDocWord.Document.89q@@@ NormalCJ_HaJmH sH tH Z@Z uP Heading 1$<@&5CJ KH OJQJ\^JaJ \@\ * Heading 2$<@& 56CJOJQJ\]^JaJV@V * Heading 3$<@&5CJOJQJ\^JaJDA@D Default Paragraph FontRiR  Table Normal4 l4a (k@(No List6U@6  .B Hyperlink >*B*ph6!z z zA [& ZTUu  A B b f l r s D E ZdXYZ[u$3BDdt4F./0$$$$$$?$$n$$$$$$$$$b0$Ճ$Ճ$$$$$$$$$$$$$$$$$d $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$& ZTUu  A B b f l r s D E ZdXYZ[u$3BDdt4F./000(0000(00 (0000(00Z0Z0Z 0Z 0Z 0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z0Z00[0[ 0[ 0[ 0[ 0[ 0[ 0[ 0[ 0[ 0[ 0 [ 0 [ 0 [0[ 0 [ 0 [ 0[ 0[ 0[ 0[ 0[ 0[ 0[ 0[ 0[ 0[ 0[ 0[ 0[ 0[000& ZTUu  A B b f l r s D E ZdXYZ[u3BDdt4F.00(0000(00(0000(00H0H0H 0H 0H 0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H0H00<0< 0< 0< 0< 0< 0< 0< 0< 0< 0< 0 < 0 < 0 < 0 < 0 < 0< 0< 0< 0< 0< 0< 0< 0< 0< 0< 0<K00 +#bY!##::8=   & :::::%VY u!#B/BGIgit_(f^8up2hhh^h`OJQJo(hHh88^8`OJQJ^Jo(hHoh^`OJQJo(hHh  ^ `OJQJo(hHh  ^ `OJQJ^Jo(hHohxx^x`OJQJo(hHhHH^H`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hH^`o(. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH._^8u                  LGG Q3T3]r= .BuPUT;aM=_-@#*|@@UnknownGz Times New Roman5Symbol3& z Arial?5 z Courier New;Wingdings"qh+5<& j22$9243QHX)?UT2Formatting Cells in ExcelJerry T. SmithJerry T. Smith