home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1979-12-31 | 4.8 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 1%
| dexvert
| WANG Integrated Word Processor (document/wangIWP)
| ext
| Unsupported |
| 1%
| dexvert
| Dynamic Publisher Document (document/dynamicPublisherDocument)
| ext
| Unsupported |
| 1%
| dexvert
| Excellence! Document (document/excellenceDocument)
| ext
| Unsupported |
| 1%
| dexvert
| Norton Textra Writer (document/textraWriter)
| ext
| Unsupported |
| 1%
| dexvert
| IBM DisplayWrite Document (document/ibmDisplayWriteDocument)
| ext
| Unsupported |
| 1%
| dexvert
| Open Access Document (document/openAccessDocument)
| ext
| Unsupported |
| 100%
| file
| data
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| c3 00 2a 25 c3 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 83 |..*%.***|*******.|
|00000010| 0a c3 00 2a 25 c3 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |...*%.**|********|
|00000020| 83 0a 0a 48 65 72 65 27 | 73 20 73 6f 6d 65 20 74 |...Here'|s some t|
|00000030| 65 78 74 20 74 68 61 74 | 20 77 61 73 20 74 61 6b |ext that| was tak|
|00000040| 65 6e 20 66 72 6f 6d 20 | 61 6e 6f 74 68 65 72 20 |en from |another |
|00000050| 63 6f 6d 70 75 74 65 72 | 20 62 6f 6f 6b 2c 20 73 |computer| book, s|
|00000060| 6f 0d 64 6f 6e 27 74 20 | 77 6f 72 72 79 20 69 66 |o.don't |worry if|
|00000070| 20 79 6f 75 20 64 6f 6e | 27 74 20 75 6e 64 65 72 | you don|'t under|
|00000080| 73 74 61 6e 64 20 74 68 | 65 20 63 6f 6e 74 65 6e |stand th|e conten|
|00000090| 74 73 20 6f 66 20 74 68 | 65 20 6d 61 74 65 72 69 |ts of th|e materi|
|000000a0| 61 6c 2e 20 0d 48 6f 77 | 65 76 65 72 2c 20 79 6f |al. .How|ever, yo|
|000000b0| 75 20 77 69 6c 6c 20 6e | 65 65 64 20 74 6f 20 62 |u will n|eed to b|
|000000c0| 65 20 61 62 6c 65 20 74 | 6f 20 75 73 65 20 57 6f |e able t|o use Wo|
|000000d0| 72 64 50 65 72 66 65 63 | 74 20 63 6f 6d 6d 61 6e |rdPerfec|t comman|
|000000e0| 64 73 20 74 6f 0d 6d 6f | 76 65 20 61 72 6f 75 6e |ds to.mo|ve aroun|
|000000f0| 64 20 61 6e 64 20 6d 61 | 6b 65 20 6d 6f 64 69 66 |d and ma|ke modif|
|00000100| 69 63 61 74 69 6f 6e 73 | 20 74 6f 20 74 68 65 20 |ications| to the |
|00000110| 66 69 6c 65 2e 0a 0a c3 | 00 2a 25 c3 2a 2a 2a 2a |file....|.*%.****|
|00000120| 2a 2a 2a 2a 2a 2a 83 0a | c3 00 2a 25 c3 2a 2a 2a |******..|..*%.***|
|00000130| 2a 2a 2a 2a 2a 2a 2a 83 | 0a 0a 0a 0a 20 20 20 20 |*******.|.... |
|00000140| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000150| 20 20 20 20 20 20 20 43 | 68 61 70 74 65 72 20 31 | C|hapter 1|
|00000160| 32 0a 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |2.. | |
|00000170| 4d 4f 44 49 46 59 49 4e | 47 20 41 4e 20 45 58 49 |MODIFYIN|G AN EXI|
|00000180| 53 54 49 4e 47 20 57 4f | 52 4b 53 48 45 45 54 2c |STING WO|RKSHEET,|
|00000190| 20 50 41 52 54 20 31 0a | 0a 0a 0a 0a 57 48 41 54 | PART 1.|....WHAT|
|000001a0| 20 49 54 20 49 53 0a 0a | 0a 20 20 20 20 20 55 70 | IT IS..|. Up|
|000001b0| 20 74 6f 20 74 68 69 73 | 20 70 6f 69 6e 74 2c 20 | to this| point, |
|000001c0| 77 65 27 76 65 20 62 65 | 65 6e 20 63 6f 6e 63 65 |we've be|en conce|
|000001d0| 72 6e 65 64 20 6d 6f 72 | 65 20 77 69 74 68 20 64 |rned mor|e with d|
|000001e0| 61 74 61 20 76 61 6c 75 | 65 73 0d 61 6e 64 20 68 |ata valu|es.and h|
|000001f0| 6f 77 20 74 6f 20 64 6f | 20 64 69 66 66 65 72 65 |ow to do| differe|
|00000200| 6e 74 20 63 6f 6d 70 75 | 74 61 74 69 6f 6e 61 6c |nt compu|tational|
|00000210| 20 73 6f 72 74 73 20 6f | 66 20 74 68 69 6e 67 73 | sorts o|f things|
|00000220| 2e 20 20 49 6e 20 74 68 | 69 73 0d 63 68 61 70 74 |. In th|is.chapt|
|00000230| 65 72 20 77 65 27 6c 6c | 20 69 6e 74 72 6f 64 75 |er we'll| introdu|
|00000240| 63 65 20 79 6f 75 20 74 | 6f 20 61 20 67 72 6f 75 |ce you t|o a grou|
|00000250| 70 20 6f 66 20 63 6f 6d | 6d 61 6e 64 73 20 74 68 |p of com|mands th|
|00000260| 61 74 20 63 61 6e 0d 67 | 72 65 61 74 6c 79 20 61 |at can.g|reatly a|
|00000270| 6c 74 65 72 20 74 68 65 | 20 61 70 70 65 61 72 61 |lter the| appeara|
|00000280| 6e 63 65 20 6f 66 20 79 | 6f 75 72 20 77 6f 72 6b |nce of y|our work|
|00000290| 73 68 65 65 74 73 2e 20 | 20 48 6f 77 65 76 65 72 |sheets. | However|
|000002a0| 2c 20 74 68 65 73 65 0d | 63 6f 6d 6d 61 6e 64 73 |, these.|commands|
|000002b0| 20 77 69 6c 6c 20 68 61 | 76 65 20 61 62 73 6f 6c | will ha|ve absol|
|000002c0| 75 74 65 6c 79 20 6e 6f | 20 69 6d 70 61 63 74 20 |utely no| impact |
|000002d0| 6f 6e 20 74 68 65 20 61 | 63 74 75 61 6c 20 63 6f |on the a|ctual co|
|000002e0| 6e 74 65 6e 74 73 20 6f | 66 0d 79 6f 75 72 20 77 |ntents o|f.your w|
|000002f0| 6f 72 6b 73 68 65 65 74 | 2e 0a 0a 20 20 20 20 20 |orksheet|... |
|00000300| 4c 65 74 27 73 20 62 65 | 67 69 6e 20 62 79 20 74 |Let's be|gin by t|
|00000310| 61 6b 69 6e 67 20 61 20 | 6c 6f 6f 6b 20 61 74 20 |aking a |look at |
|00000320| 61 20 6e 65 77 20 6d 65 | 6e 75 20 69 6e 20 45 78 |a new me|nu in Ex|
|00000330| 68 69 62 69 74 20 31 32 | 2e 31 2c 0d 74 68 65 20 |hibit 12|.1,.the |
|00000340| 52 41 4e 47 45 20 46 4f | 52 4d 41 54 20 6d 65 6e |RANGE FO|RMAT men|
|00000350| 75 2e 20 20 49 6e 20 61 | 64 64 69 74 69 6f 6e 20 |u. In a|ddition |
|00000360| 74 6f 20 61 20 6e 65 77 | 20 6d 65 6e 75 2c 20 79 |to a new| menu, y|
|00000370| 6f 75 27 6c 6c 20 6e 6f | 74 69 63 65 0d 77 65 27 |ou'll no|tice.we'|
|00000380| 72 65 20 6e 6f 77 20 77 | 6f 72 6b 69 6e 67 20 77 |re now w|orking w|
|00000390| 69 74 68 20 61 20 6e 65 | 77 20 66 69 6c 65 2e 20 |ith a ne|w file. |
|000003a0| 20 57 68 61 74 20 79 6f | 75 20 73 65 65 20 69 6e | What yo|u see in|
|000003b0| 20 74 68 65 20 65 78 68 | 69 62 69 74 0d 69 73 20 | the exh|ibit.is |
|000003c0| 6c 69 6b 65 20 74 68 65 | 20 66 69 6c 65 20 79 6f |like the| file yo|
|000003d0| 75 27 6c 6c 20 75 73 65 | 20 69 6e 20 74 68 65 20 |u'll use| in the |
|000003e0| 65 78 65 72 63 69 73 65 | 73 20 62 65 67 69 6e 6e |exercise|s beginn|
|000003f0| 69 6e 67 20 77 69 74 68 | 20 74 68 69 73 0d 63 68 |ing with| this.ch|
|00000400| 61 70 74 65 72 2e 0a 0a | 20 20 20 20 20 41 6c 73 |apter...| Als|
|00000410| 6f 20 62 65 20 73 75 72 | 65 20 74 6f 20 6e 6f 74 |o be sur|e to not|
|00000420| 69 63 65 20 74 68 61 74 | 20 77 65 20 68 61 76 65 |ice that| we have|
|00000430| 20 63 68 61 6e 67 65 64 | 20 73 6f 6d 65 20 6f 66 | changed| some of|
|00000440| 20 74 68 65 0d 63 6f 6c | 75 6d 6e 20 77 69 64 74 | the.col|umn widt|
|00000450| 68 73 a9 a9 75 73 69 6e | 67 20 74 68 65 20 57 4f |hs..usin|g the WO|
|00000460| 52 4b 53 48 45 45 54 20 | 43 4f 4c 55 4d 4e 20 57 |RKSHEET |COLUMN W|
|00000470| 49 44 54 48 20 63 6f 6d | 6d 61 6e 64 2e 20 20 46 |IDTH com|mand. F|
|00000480| 6f 72 0d 65 78 61 6d 70 | 6c 65 2c 20 79 6f 75 20 |or.examp|le, you |
|00000490| 63 61 6e 20 73 65 65 20 | 62 79 20 74 68 65 20 5b |can see |by the [|
|000004a0| 57 32 30 5d 20 69 6e 64 | 69 63 61 74 6f 72 20 69 |W20] ind|icator i|
|000004b0| 6e 20 74 68 65 20 75 70 | 70 65 72 0d 6c 65 66 74 |n the up|per.left|
|000004c0| 2d 68 61 6e 64 20 63 6f | 72 6e 65 72 20 6f 66 20 |-hand co|rner of |
|000004d0| 74 68 65 20 73 63 72 65 | 65 6e 20 74 68 61 74 20 |the scre|en that |
|000004e0| 74 68 65 20 77 69 64 74 | 68 20 6f 66 20 43 6f 6c |the widt|h of Col|
|000004f0| 75 6d 6e 20 41 20 69 73 | 20 32 30 2e 20 0d 20 20 |umn A is| 20. . |
|00000500| 0a 0a 0a c3 00 2a 1c c3 | 5b 5b 20 45 58 48 49 42 |.....*..|[[ EXHIB|
|00000510| 49 54 20 31 32 2e 31 20 | 47 4f 45 53 20 48 45 52 |IT 12.1 |GOES HER|
|00000520| 45 20 5d 5d 83 0a 0a 0a | 0a 0a 20 20 20 20 20 54 |E ]]....|.. T|
|00000530| 68 65 73 65 20 46 4f 52 | 4d 41 54 20 6d 65 6e 75 |hese FOR|MAT menu|
|00000540| 20 63 6f 6d 6d 61 6e 64 | 73 20 61 72 65 20 61 6c | command|s are al|
|00000550| 6c 20 75 73 65 64 20 74 | 6f 20 64 65 74 65 72 6d |l used t|o determ|
|00000560| 69 6e 65 20 68 6f 77 20 | 74 68 65 0d 64 61 74 61 |ine how |the.data|
|00000570| 20 69 6e 20 61 20 67 69 | 76 65 6e 20 72 61 6e 67 | in a gi|ven rang|
|00000580| 65 20 6f 66 20 63 65 6c | 6c 73 20 77 69 6c 6c 20 |e of cel|ls will |
|00000590| 62 65 20 64 69 73 70 6c | 61 79 65 64 2e 20 20 49 |be displ|ayed. I|
|000005a0| 6e 20 6f 74 68 65 72 0d | 77 6f 72 64 73 2c 20 74 |n other.|words, t|
|000005b0| 68 65 79 20 64 65 74 65 | 72 6d 69 6e 65 20 68 6f |hey dete|rmine ho|
|000005c0| 77 20 79 6f 75 72 20 64 | 61 74 61 20 77 69 6c 6c |w your d|ata will|
|000005d0| 20 62 65 20 66 6f 72 6d | 61 74 74 65 64 2e 20 20 | be form|atted. |
|000005e0| 46 6f 72 0d 65 78 61 6d | 70 6c 65 2c 20 69 66 20 |For.exam|ple, if |
|000005f0| 61 20 67 69 76 65 6e 20 | 63 65 6c 6c 20 68 61 64 |a given |cell had|
|00000600| 20 62 65 65 6e 20 74 79 | 70 65 64 20 61 73 20 30 | been ty|ped as 0|
|00000610| 2e 30 35 20 69 74 20 77 | 6f 75 6c 64 20 62 65 20 |.05 it w|ould be |
|00000620| 73 68 6f 77 6e 0d 6f 6e | 20 61 20 77 6f 72 6b 73 |shown.on| a works|
|00000630| 68 65 65 74 20 61 73 20 | 2e 30 35 2e 20 20 42 75 |heet as |.05. Bu|
|00000640| 74 20 69 66 20 79 6f 75 | 20 75 73 65 64 20 74 68 |t if you| used th|
|00000650| 65 20 52 41 4e 47 45 20 | 46 4f 52 4d 41 54 20 50 |e RANGE |FORMAT P|
|00000660| 45 52 43 45 4e 54 0d 63 | 6f 6d 6d 61 6e 64 20 74 |ERCENT.c|ommand t|
|00000670| 6f 20 63 68 61 6e 67 65 | 20 74 68 61 74 20 63 65 |o change| that ce|
|00000680| 6c 6c 20 74 6f 20 61 20 | 70 65 72 63 65 6e 74 20 |ll to a |percent |
|00000690| 66 6f 72 6d 61 74 2c 20 | 74 68 65 6e 20 74 68 61 |format, |then tha|
|000006a0| 74 20 73 61 6d 65 dc 6a | 00 00 00 00 02 00 dc 0b |t same.j|........|
|000006b0| 76 61 6c 75 65 20 77 6f | 75 6c 64 20 62 65 20 64 |value wo|uld be d|
|000006c0| 69 73 70 6c 61 79 65 64 | 20 61 73 20 35 25 2e 0a |isplayed| as 5%..|
|000006d0| 0a 20 20 20 20 20 41 6e | 6f 74 68 65 72 20 65 78 |. An|other ex|
|000006e0| 61 6d 70 6c 65 20 69 73 | 20 69 6e 20 6f 72 64 65 |ample is| in orde|
|000006f0| 72 2e 20 20 54 61 6b 65 | 20 61 20 6c 6f 6f 6b 20 |r. Take| a look |
|00000700| 61 74 20 45 78 68 69 62 | 69 74 20 31 32 2e 32 0d |at Exhib|it 12.2.|
|00000710| 61 6e 64 20 63 6f 6d 70 | 61 72 65 20 69 74 20 74 |and comp|are it t|
|00000720| 6f 20 45 78 68 69 62 69 | 74 20 31 32 2e 31 2e 20 |o Exhibi|t 12.1. |
|00000730| 20 4d 6f 72 65 20 73 70 | 65 63 69 66 69 63 61 6c | More sp|ecifical|
|00000740| 6c 79 2c 20 6c 6f 6f 6b | 20 61 74 20 74 68 65 0d |ly, look| at the.|
|00000750| 63 65 6c 6c 73 20 69 6e | 20 74 68 65 20 42 38 2e |cells in| the B8.|
|00000760| 2e 45 38 20 72 61 6e 67 | 65 2e 20 20 54 68 65 73 |.E8 rang|e. Thes|
|00000770| 65 20 63 65 6c 6c 73 20 | 68 61 76 65 20 62 65 65 |e cells |have bee|
|00000780| 6e 20 66 6f 72 6d 61 74 | 74 65 64 20 77 69 74 68 |n format|ted with|
|00000790| 0d 74 68 65 20 52 41 4e | 47 45 20 46 4f 52 4d 41 |.the RAN|GE FORMA|
|000007a0| 54 20 43 55 52 52 45 4e | 43 59 20 63 6f 6d 6d 61 |T CURREN|CY comma|
|000007b0| 6e 64 20 28 73 70 65 63 | 69 66 79 69 6e 67 20 6e |nd (spec|ifying n|
|000007c0| 6f 20 64 65 63 69 6d 61 | 6c 20 70 6c 61 63 65 73 |o decima|l places|
|000007d0| 29 2e 20 0d 54 68 65 20 | 72 65 73 75 6c 74 20 69 |). .The |result i|
|000007e0| 73 20 74 68 65 20 64 6f | 6c 6c 61 72 20 73 69 67 |s the do|llar sig|
|000007f0| 6e 20 66 6f 72 6d 61 74 | 20 79 6f 75 20 73 65 65 |n format| you see|
|00000800| 20 69 6e 20 74 68 65 20 | 65 78 68 69 62 69 74 2e | in the |exhibit.|
|00000810| 20 0d 41 6c 73 6f 20 6e | 6f 74 69 63 65 20 68 6f | .Also n|otice ho|
|00000820| 77 20 65 66 66 65 63 74 | 69 76 65 6c 79 20 74 68 |w effect|ively th|
|00000830| 65 20 65 64 69 74 20 6c | 69 6e 65 20 69 6e 20 74 |e edit l|ine in t|
|00000840| 68 65 20 63 6f 6e 74 72 | 6f 6c 20 70 61 6e 65 6c |he contr|ol panel|
|00000850| 0d 64 65 73 63 72 69 62 | 65 73 20 61 20 67 69 76 |.describ|es a giv|
|00000860| 65 6e 20 63 65 6c 6c 2e | 20 20 49 6e 20 74 68 69 |en cell.| In thi|
|00000870| 73 20 63 61 73 65 2c 20 | 74 68 65 20 75 70 70 65 |s case, |the uppe|
|00000880| 72 20 6c 65 66 74 2d 68 | 61 6e 64 20 63 6f 72 6e |r left-h|and corn|
|00000890| 65 72 0d 72 65 61 64 73 | 20 22 42 38 3a 20 28 43 |er.reads| "B8: (C|
|000008a0| 30 29 20 5b 57 31 32 5d | 20 35 30 30 22 2e 20 20 |0) [W12]| 500". |
|000008b0| 54 68 69 73 20 74 65 6c | 6c 73 20 79 6f 75 20 74 |This tel|ls you t|
|000008c0| 68 61 74 20 74 68 65 20 | 63 65 6c 6c 20 69 73 0d |hat the |cell is.|
|000008d0| 66 6f 72 6d 61 74 74 65 | 64 20 61 73 20 43 75 72 |formatte|d as Cur|
|000008e0| 72 65 6e 63 79 2c 20 69 | 74 20 68 6f 6c 64 73 20 |rency, i|t holds |
|000008f0| 30 20 64 65 63 69 6d 61 | 6c 20 70 6c 61 63 65 73 |0 decima|l places|
|00000900| 2c 20 74 68 65 20 77 69 | 64 74 68 20 69 73 0d 31 |, the wi|dth is.1|
|00000910| 32 2c 20 61 6e 64 20 74 | 68 65 20 63 6f 6e 74 65 |2, and t|he conte|
|00000920| 6e 74 73 20 6f 66 20 74 | 68 65 20 63 65 6c 6c 20 |nts of t|he cell |
|00000930| 61 72 65 20 35 30 30 2e | 0a 0a 0a 0a 0a c3 00 2a |are 500.|.......*|
|00000940| 1c c3 5b 5b 20 45 58 48 | 49 42 49 54 20 31 32 2e |..[[ EXH|IBIT 12.|
|00000950| 32 20 47 4f 45 53 20 48 | 45 52 45 20 5d 5d 83 0a |2 GOES H|ERE ]]..|
|00000960| 0a 0a 0a 0a 20 20 20 20 | 20 57 68 65 6e 20 79 6f |.... | When yo|
|00000970| 75 20 75 73 65 20 74 68 | 65 20 52 41 4e 47 45 20 |u use th|e RANGE |
|00000980| 46 4f 52 4d 41 54 20 63 | 6f 6d 6d 61 6e 64 2c 20 |FORMAT c|ommand, |
|00000990| 79 6f 75 20 63 61 6e 20 | 73 65 6c 65 63 74 20 61 |you can |select a|
|000009a0| 6e 79 0d 6f 70 74 69 6f | 6e 20 66 72 6f 6d 20 74 |ny.optio|n from t|
|000009b0| 68 6f 73 65 20 6c 69 73 | 74 65 64 20 6f 6e 20 74 |hose lis|ted on t|
|000009c0| 68 65 20 6d 65 6e 75 2e | 20 20 41 6e 64 2c 20 73 |he menu.| And, s|
|000009d0| 68 6f 75 6c 64 20 79 6f | 75 20 6c 69 6b 65 20 74 |hould yo|u like t|
|000009e0| 6f 0d 65 6c 69 6d 69 6e | 61 74 65 20 61 6e 79 20 |o.elimin|ate any |
|000009f0| 66 6f 72 6d 61 74 2c 20 | 61 6c 6c 20 79 6f 75 20 |format, |all you |
|00000a00| 6e 65 65 64 20 64 6f 20 | 69 73 20 73 65 6c 65 63 |need do |is selec|
|00000a10| 74 20 74 68 65 20 63 6f | 6d 6d 61 6e 64 20 61 67 |t the co|mmand ag|
|00000a20| 61 69 6e 0d 61 6e 64 20 | 63 68 61 6e 67 65 20 74 |ain.and |change t|
|00000a30| 68 65 20 6f 70 74 69 6f | 6e 20 74 6f 20 73 6f 6d |he optio|n to som|
|00000a40| 65 74 68 69 6e 67 20 65 | 6c 73 65 2e 20 20 41 6c |ething e|lse. Al|
|00000a50| 73 6f 2c 20 79 6f 75 20 | 63 61 6e 20 75 73 65 20 |so, you |can use |
|00000a60| 74 68 65 0d 52 41 4e 47 | 45 20 46 4f 52 4d 41 54 |the.RANG|E FORMAT|
|00000a70| 20 52 45 53 45 54 20 63 | 6f 6d 6d 61 6e 64 20 74 | RESET c|ommand t|
|00000a80| 6f 20 73 65 74 20 77 68 | 61 74 65 76 65 72 20 72 |o set wh|atever r|
|00000a90| 61 6e 67 65 20 79 6f 75 | 20 73 70 65 63 69 66 79 |ange you| specify|
|00000aa0| 20 62 61 63 6b 0d 74 6f | 20 69 74 73 20 6f 72 69 | back.to| its ori|
|00000ab0| 67 69 6e 61 6c 20 73 74 | 61 74 65 2e 0a 0a 20 20 |ginal st|ate... |
|00000ac0| 20 20 20 52 41 4e 47 45 | 20 46 4f 52 4d 41 54 20 | RANGE| FORMAT |
|00000ad0| 69 73 20 69 6e 74 65 6e | 64 65 64 20 66 6f 72 20 |is inten|ded for |
|00000ae0| 63 65 6c 6c 73 20 77 69 | 74 68 20 76 61 6c 75 65 |cells wi|th value|
|00000af0| 73 20 69 6e 20 74 68 65 | 6d 2e 20 0d 54 68 65 72 |s in the|m. .Ther|
|00000b00| 65 27 73 20 61 20 73 69 | 6d 69 6c 61 72 20 63 6f |e's a si|milar co|
|00000b10| 6d 6d 61 6e 64 20 74 68 | 61 74 20 64 65 61 6c 73 |mmand th|at deals|
|00000b20| 20 77 69 74 68 20 74 68 | 65 20 66 6f 72 6d 61 74 | with th|e format|
|00000b30| 74 69 6e 67 20 6f 66 20 | 6c 61 62 65 6c 0d 63 65 |ting of |label.ce|
|00000b40| 6c 6c 73 3a 20 20 52 41 | 4e 47 45 20 4c 41 42 45 |lls: RA|NGE LABE|
|00000b50| 4c 2e 20 20 54 68 69 73 | 20 63 6f 6d 6d 61 6e 64 |L. This| command|
|00000b60| 20 69 73 20 75 73 65 64 | 20 74 6f 20 73 70 65 63 | is used| to spec|
|00000b70| 69 66 79 20 77 68 65 74 | 68 65 72 20 61 0d 6c 61 |ify whet|her a.la|
|00000b80| 62 65 6c 20 77 69 6c 6c | 20 62 65 20 6c 65 66 74 |bel will| be left|
|00000b90| 2c 20 72 69 67 68 74 2c | 20 6f 72 20 63 65 6e 74 |, right,| or cent|
|00000ba0| 65 72 20 6a 75 73 74 69 | 66 69 65 64 20 77 69 74 |er justi|fied wit|
|00000bb0| 68 69 6e 20 61 20 63 65 | 6c 6c 0d 28 72 65 6d 65 |hin a ce|ll.(reme|
|00000bc0| 6d 62 65 72 2c 20 74 68 | 65 20 64 65 66 61 75 6c |mber, th|e defaul|
|00000bd0| 74 20 69 73 20 6c 65 66 | 74 29 2e 20 20 4f 6e 63 |t is lef|t). Onc|
|00000be0| 65 20 69 6e 76 6f 6b 65 | 64 2c 20 74 68 69 73 20 |e invoke|d, this |
|00000bf0| 63 6f 6d 6d 61 6e 64 20 | 77 69 6c 6c 0d 73 69 6d |command |will.sim|
|00000c00| 70 6c 79 20 61 73 6b 20 | 79 6f 75 20 74 6f 20 73 |ply ask |you to s|
|00000c10| 70 65 63 69 66 79 20 4c | 45 46 54 2c 20 52 49 47 |pecify L|EFT, RIG|
|00000c20| 48 54 20 6f 72 20 43 45 | 4e 54 45 52 20 6a 75 73 |HT or CE|NTER jus|
|00000c30| 74 69 66 69 63 61 74 69 | 6f 6e 20 61 6e 64 0d 74 |tificati|on and.t|
|00000c40| 68 65 6e 20 61 73 6b 20 | 66 6f 72 20 61 20 72 61 |hen ask |for a ra|
|00000c50| 6e 67 65 20 6f 66 20 63 | 65 6c 6c 73 2e 20 20 4a |nge of c|ells. J|
|00000c60| 75 73 74 20 61 73 20 77 | 69 74 68 20 74 68 65 20 |ust as w|ith the |
|00000c70| 52 41 4e 47 45 20 46 4f | 52 4d 41 54 0d 63 6f 6d |RANGE FO|RMAT.com|
|00000c80| 6d 61 6e 64 73 2c 20 74 | 68 65 20 61 63 74 75 61 |mands, t|he actua|
|00000c90| 6c 20 63 6f 6e 74 65 6e | 74 73 20 6f 66 20 61 20 |l conten|ts of a |
|00000ca0| 63 65 6c 6c 20 6f 72 20 | 72 61 6e 67 65 20 6f 66 |cell or |range of|
|00000cb0| 20 63 65 6c 6c 73 20 61 | 72 65 20 6e 6f 74 0d 61 | cells a|re not.a|
|00000cc0| 6c 74 65 72 65 64 2e 20 | 20 4f 6e 6c 79 20 74 68 |ltered. | Only th|
|00000cd0| 65 20 63 65 6c 6c 28 73 | 29 20 64 69 73 70 6c 61 |e cell(s|) displa|
|00000ce0| 79 20 69 73 20 61 66 66 | 65 63 74 65 64 2e 0a 0a |y is aff|ected...|
|00000cf0| 20 20 20 20 20 45 78 68 | 69 62 69 74 20 31 32 2e | Exh|ibit 12.|
|00000d00| 33 20 73 68 6f 77 73 20 | 68 6f 77 20 74 68 65 20 |3 shows |how the |
|00000d10| 61 70 70 65 61 72 61 6e | 63 65 20 6f 66 20 63 65 |appearan|ce of ce|
|00000d20| 6c 6c 73 20 42 35 2e 2e | 45 35 20 68 61 73 0d 63 |lls B5..|E5 has.c|
|00000d30| 68 61 6e 67 65 64 20 62 | 79 20 75 73 69 6e 67 20 |hanged b|y using |
|00000d40| 74 68 65 20 52 41 4e 47 | 45 20 4c 41 42 45 4c 20 |the RANG|E LABEL |
|00000d50| 52 49 47 48 54 20 63 6f | 6d 6d 61 6e 64 2e 20 20 |RIGHT co|mmand. |
|00000d60| 4e 6f 74 65 20 74 68 61 | 74 20 74 68 65 0d 63 6f |Note tha|t the.co|
|00000d70| 6e 74 65 6e 74 73 20 6f | 66 20 42 35 20 68 61 76 |ntents o|f B5 hav|
|00000d80| 65 20 6e 6f 74 20 63 68 | 61 6e 67 65 64 3b 20 74 |e not ch|anged; t|
|00000d90| 68 65 79 20 73 74 69 6c | 6c 20 63 6f 6e 74 61 69 |hey stil|l contai|
|00000da0| 6e 20 43 4f 4d 50 41 4e | 59 20 41 2e 20 0d 48 6f |n COMPAN|Y A. .Ho|
|00000db0| 77 65 76 65 72 2c 20 74 | 68 65 20 6c 61 62 65 6c |wever, t|he label|
|00000dc0| 20 69 73 20 6e 6f 77 20 | 6a 75 73 74 69 66 69 65 | is now |justifie|
|00000dd0| 64 20 74 6f 20 74 68 65 | 20 72 69 67 68 74 20 77 |d to the| right w|
|00000de0| 69 74 68 69 6e 20 43 6f | 6c 75 6d 6e 20 42 2e 0a |ithin Co|lumn B..|
|00000df0| 0a 20 20 20 20 20 41 6c | 73 6f 20 69 6e 20 45 78 |. Al|so in Ex|
|00000e00| 68 69 62 69 74 20 31 32 | 2e 33 2c 20 6e 6f 74 69 |hibit 12|.3, noti|
|00000e10| 63 65 20 68 6f 77 20 74 | 68 65 72 65 20 69 73 20 |ce how t|here is |
|00000e20| 6e 6f 77 20 61 20 22 20 | 70 72 65 66 69 78 20 69 |now a " |prefix i|
|00000e30| 6e 0d 74 68 65 20 63 6f | 6e 74 72 6f 6c 20 70 61 |n.the co|ntrol pa|
|00000e40| 6e 65 6c 20 66 6f 72 20 | 63 65 6c 6c 20 42 35 2e |nel for |cell B5.|
|00000e50| 20 20 54 68 69 73 20 64 | 6f 75 62 6c 65 20 71 75 | This d|ouble qu|
|00000e60| 6f 74 61 74 69 6f 6e 20 | 6d 61 72 6b 20 69 73 20 |otation |mark is |
|00000e70| 6f 6e 65 0d 6f 66 20 74 | 68 65 20 73 79 6d 62 6f |one.of t|he symbo|
|00000e80| 6c 73 20 31 2d 32 2d 33 | 20 75 73 65 73 20 74 6f |ls 1-2-3| uses to|
|00000e90| 20 6b 65 65 70 20 74 72 | 61 63 6b 20 6f 66 20 68 | keep tr|ack of h|
|00000ea0| 6f 77 20 69 74 73 20 6c | 61 62 65 6c 73 20 61 72 |ow its l|abels ar|
|00000eb0| 65 0d 6a 75 73 74 69 66 | 69 65 64 2e 20 20 54 68 |e.justif|ied. Th|
|00000ec0| 65 72 65 20 61 72 65 20 | 74 68 72 65 65 20 6c 61 |ere are |three la|
|00000ed0| 62 65 6c 2d 70 72 65 66 | 69 78 20 63 68 61 72 61 |bel-pref|ix chara|
|00000ee0| 63 74 65 72 73 20 69 6e | 20 31 2d 32 2d 33 3a 0a |cters in| 1-2-3:.|
|00000ef0| 0a 0a 09 09 09 27 20 20 | 66 6f 72 20 6c 65 66 74 |.....' |for left|
|00000f00| 2d 6a 75 73 74 69 66 69 | 65 64 20 6c 61 62 65 6c |-justifi|ed label|
|00000f10| 73 0a 0a 09 09 09 22 20 | 20 66 6f 72 20 72 69 67 |s....." | for rig|
|00000f20| 68 74 2d 6a 75 73 74 69 | 66 69 65 64 20 6c 61 62 |ht-justi|fied lab|
|00000f30| 65 6c 73 0a 0a 09 09 09 | 5e 20 20 66 6f 72 20 63 |els.....|^ for c|
|00000f40| 65 6e 74 65 72 2d 6a 75 | 73 74 69 66 69 65 64 20 |enter-ju|stified |
|00000f50| 6c 61 62 65 6c 73 dc 6a | 00 00 00 00 00 00 dc 8c |labels.j|........|
|00000f60| 0a 0a 49 66 20 79 6f 75 | 20 72 65 63 61 6c 6c 2c |..If you| recall,|
|00000f70| 20 74 68 65 20 64 65 66 | 61 75 6c 74 20 66 6f 72 | the def|ault for|
|00000f80| 20 6c 61 62 65 6c 73 20 | 69 73 20 6c 65 66 74 20 | labels |is left |
|00000f90| 6a 75 73 74 69 66 69 63 | 61 74 69 6f 6e 20 73 6f |justific|ation so|
|00000fa0| 2c 0d 75 6e 6c 65 73 73 | 20 79 6f 75 20 73 70 65 |,.unless| you spe|
|00000fb0| 63 69 66 79 20 6f 74 68 | 65 72 77 69 73 65 2c 20 |cify oth|erwise, |
|00000fc0| 61 6c 6c 20 6c 61 62 65 | 6c 73 20 61 75 74 6f 6d |all labe|ls autom|
|00000fd0| 61 74 69 63 61 6c 6c 79 | 20 72 65 63 65 69 76 65 |atically| receive|
|00000fe0| 20 61 6e 0d 61 70 6f 73 | 74 72 6f 70 68 65 20 28 | an.apos|trophe (|
|00000ff0| 27 29 2e 20 20 0a 0a 20 | 20 20 20 20 49 6e 63 69 |'). .. | Inci|
|00001000| 64 65 6e 74 61 6c 6c 79 | 2c 20 79 6f 75 20 63 61 |dentally|, you ca|
|00001010| 6e 20 75 73 65 20 61 6e | 79 20 6f 66 20 74 68 65 |n use an|y of the|
|00001020| 20 6c 61 62 65 6c 2d 70 | 72 65 66 69 78 20 63 68 | label-p|refix ch|
|00001030| 61 72 61 63 74 65 72 73 | 0d 77 68 69 6c 65 20 79 |aracters|.while y|
|00001040| 6f 75 20 65 6e 74 65 72 | 20 64 61 74 61 20 69 6e |ou enter| data in|
|00001050| 20 61 6e 79 20 67 69 76 | 65 6e 20 63 65 6c 6c 2e | any giv|en cell.|
|00001060| 20 20 49 66 20 79 6f 75 | 20 65 6e 74 65 72 20 61 | If you| enter a|
|00001070| 20 6c 61 62 65 6c 20 61 | 6e 64 0d 77 61 6e 74 20 | label a|nd.want |
|00001080| 74 68 61 74 20 70 61 72 | 74 69 63 75 6c 61 72 20 |that par|ticular |
|00001090| 6f 6e 65 20 74 6f 20 62 | 65 20 63 65 6e 74 65 72 |one to b|e center|
|000010a0| 65 64 20 69 6e 20 74 68 | 65 20 63 65 6c 6c 2c 20 |ed in th|e cell, |
|000010b0| 79 6f 75 20 63 61 6e 0d | 73 69 6d 70 6c 79 20 74 |you can.|simply t|
|000010c0| 79 70 65 20 74 68 65 20 | 5e 20 28 61 20 73 68 69 |ype the |^ (a shi|
|000010d0| 66 74 20 36 29 20 62 65 | 66 6f 72 65 20 79 6f 75 |ft 6) be|fore you|
|000010e0| 20 74 79 70 65 20 69 6e | 20 74 68 65 20 6c 61 62 | type in| the lab|
|000010f0| 65 6c 2e 20 20 54 68 65 | 6e 0d 74 68 65 20 6c 61 |el. The|n.the la|
|00001100| 62 65 6c 20 77 69 6c 6c | 20 62 65 20 63 65 6e 74 |bel will| be cent|
|00001110| 65 72 65 64 2e 20 20 20 | 46 6f 72 20 65 78 61 6d |ered. |For exam|
|00001120| 70 6c 65 2c 20 69 66 20 | 79 6f 75 20 67 6f 20 74 |ple, if |you go t|
|00001130| 6f 20 61 20 62 6c 61 6e | 6b 0d 63 65 6c 6c 20 61 |o a blan|k.cell a|
|00001140| 6e 64 20 74 79 70 65 20 | 5e 48 45 4c 4c 4f 2c 20 |nd type |^HELLO, |
|00001150| 74 68 65 20 77 6f 72 64 | 20 48 45 4c 4c 4f 20 77 |the word| HELLO w|
|00001160| 69 6c 6c 20 62 65 20 63 | 65 6e 74 65 72 65 64 20 |ill be c|entered |
|00001170| 69 6e 20 74 68 65 0d 63 | 65 6c 6c 2e 0a 0a 0a 0a |in the.c|ell.....|
|00001180| 0a c3 00 2a 1c c3 5b 5b | 20 45 58 48 49 42 49 54 |...*..[[| EXHIBIT|
|00001190| 20 31 32 2e 33 20 47 4f | 45 53 20 48 45 52 45 20 | 12.3 GO|ES HERE |
|000011a0| 5d 5d 83 0a 0a 0a 0a 0a | 48 4f 57 20 49 54 20 57 |]]......|HOW IT W|
|000011b0| 4f 52 4b 53 0a 0a 0a 46 | 6f 72 20 76 61 6c 75 65 |ORKS...F|or value|
|000011c0| 73 20 2e 2e 2e 0a 0a 31 | 2e 20 20 53 65 6c 65 63 |s .....1|. Selec|
|000011d0| 74 20 74 68 65 20 52 41 | 4e 47 45 20 46 4f 52 4d |t the RA|NGE FORM|
|000011e0| 41 54 20 63 6f 6d 6d 61 | 6e 64 2e 0a 0a 32 2e 20 |AT comma|nd...2. |
|000011f0| 20 53 65 6c 65 63 74 20 | 74 68 65 20 74 79 70 65 | Select |the type|
|00001200| 20 6f 66 20 66 6f 72 6d | 61 74 20 79 6f 75 20 77 | of form|at you w|
|00001210| 61 6e 74 2e 0a 0a 33 2e | 20 20 28 49 66 20 6e 65 |ant...3.| (If ne|
|00001220| 63 65 73 73 61 72 79 29 | 2e 20 20 53 70 65 63 69 |cessary)|. Speci|
|00001230| 66 79 20 74 68 65 20 6e | 75 6d 62 65 72 20 6f 66 |fy the n|umber of|
|00001240| 20 64 65 63 69 6d 61 6c | 20 70 6c 61 63 65 73 20 | decimal| places |
|00001250| 79 6f 75 0d 77 61 6e 74 | 20 74 6f 20 69 6e 63 6c |you.want| to incl|
|00001260| 75 64 65 2e 0a 0a 34 2e | 20 20 53 70 65 63 69 66 |ude...4.| Specif|
|00001270| 79 20 77 68 61 74 20 72 | 61 6e 67 65 20 79 6f 75 |y what r|ange you|
|00001280| 20 77 61 6e 74 20 74 6f | 20 63 68 61 6e 67 65 2e | want to| change.|
|00001290| 0a 0a 35 2e 20 20 50 72 | 65 73 73 20 7b 45 4e 54 |..5. Pr|ess {ENT|
|000012a0| 45 52 7d 2e 0a 0a 0a 46 | 6f 72 20 6c 61 62 65 6c |ER}....F|or label|
|000012b0| 73 20 2e 2e 2e 0a 0a 31 | 2e 20 20 53 65 6c 65 63 |s .....1|. Selec|
|000012c0| 74 20 74 68 65 20 52 41 | 4e 47 45 20 4c 41 42 45 |t the RA|NGE LABE|
|000012d0| 4c 20 63 6f 6d 6d 61 6e | 64 2e 0a 0a 32 2e 20 20 |L comman|d...2. |
|000012e0| 53 70 65 63 69 66 79 20 | 77 68 65 74 68 65 72 20 |Specify |whether |
|000012f0| 79 6f 75 20 77 61 6e 74 | 20 74 6f 20 4c 45 46 54 |you want| to LEFT|
|00001300| 2c 20 52 49 47 48 54 2c | 20 6f 72 20 43 45 4e 54 |, RIGHT,| or CENT|
|00001310| 45 52 20 6a 75 73 74 69 | 66 79 0d 74 68 65 20 6c |ER justi|fy.the l|
|00001320| 61 62 65 6c 73 2e 0a 0a | 33 2e 20 20 45 6e 74 65 |abels...|3. Ente|
|00001330| 72 20 74 68 65 20 72 61 | 6e 67 65 20 79 6f 75 20 |r the ra|nge you |
|00001340| 77 61 6e 74 20 74 6f 20 | 6a 75 73 74 69 66 79 2e |want to |justify.|
|00001350| 0a 0a 34 2e 20 20 50 72 | 65 73 73 20 7b 45 4e 54 |..4. Pr|ess {ENT|
|00001360| 45 52 7d 2e | |ER}. | |
+--------+-------------------------+-------------------------+--------+--------+
