02-09-2014_16-40-43 / 2013 Пакеты прикладных программ
.pdf.[(ml )J,06aBJieHIDI. O)J,HOM CTpOiill B mo6oM MeCTe Ta6JUUJ,hl CJie)J,yeT:
:::} ycTaHOBHTh TeKCTOBhIM KYPCOp B mo6oM MeCTe CTpOKH, Ha)], KOTOpOM Tpe6yeTCH BCTaBHTh )J,OIIOJIHHTeJibHYJO CTpOKY;
:::} aKTHBH3HpoBaTh MeHio Ta611uu,a;
:::} BhI6paTh KOMaH)J,y BcmaBumb cmp01cu.
.[(ml )J,06aBJieHIDI. cpaJy HeCKOJihKHX CTpOK Ta6JIHIJ,hl He06XO)J,HMO:
:::} ycTaHOBHTh TeKCTOBhIM KYPCOP B mo6oM MecTe CTpOKH, HM KOTOpOM Tpe6yeTCH BCTaBHTh )J,OIIOJIHHTeJihHhie CTpoKH;
:::} Bbl)J,eJIHTh BHH3 c IIOMOIIJ,hIO KYPCOpa CTOJihKO CTpOK, CKOJihKO Tpe6yeTCH )J,06aBHTh;
:::} aKTHBH3HpoBaTh MeHio Ta611uu,a;
:::} Bhl6paTh KOMaH)J,y BcmaBumb (iJo6aBumb) cmpoKu.
.[(ml BCTaBKH (Ao6aBJieHHH) HOBOro CTOJIOIJ,a Heo6XO)J,HMO:
:::} Bhl)J,eJIHTh B Ta6JIHIJ;e CTOJI6e11;, CJieBa OT KOToporo Tpe6yeTCH )J,06aBHTh HOBhIH CTOJI6e11;;
:::} aKTHBH3HpoBaTh MeHIO Ta6.!lu1.4a;
:::} Bhl6paTh KOMaH)J,y BcmaBumb (iJo6aBUmb) cmo116u,bl.
TeXHOJIOrHH BCTaBKH HeCKOJihKHX HOBhIX CTOJI6IJ;OB aHaJIOrlflIHa TeXHOJIOrHH BCTaBKH CTpOK c TOH TOJihKO pa3HHIJ;e:H, 'ITOtty)KHO Bhl- )J,eAATh COOTBeTCTBYJOIIJ,ee 1IHCJIO CTOJI6IJ;OB CJieBa OT Toro CTOJI6IJ;a, rrepe)J, KOTOPhlM 6y)J.yT )J,06aBJieHhl HOBble.
YAaJieHHe 11mpopMa11;11H B CTpOKax H cTon611;ax 6e3 YAaJieHHH caMHX CTpOK H CTOJI6IJ;OB 113 Ta6JIHIJ;hl rrpOH3BO)J,HTCH aHaJIOrITTHO YAaJieHHIO CTpOKH TeKCTa, T. e. Heo6XO)J,HMO:
:::} Bbl)J,eJIHTh KYIJCOpOM HHcPOPMaumo B CTpOKe HJIH CTOJI6ue;
:::} HCUl<:aTh KJiaBHIIIY [Del).
YAaJieHHe CTPOK HJIH cToJI611;0B Ta6JIHUhI rrpoH3BOAHTCH B cJie)J,yromeM rropH)J,Ke:
:::} BhIAeJIHTh CTPOKY HJIH CTOJI6eu;
:::} aKTHBH3HpoBaTh MeHio Ta611uu,a;
:::} BbI6paTb KOMaHAY YiJMUmb fliteiiKu;
:::} B IIOHBHBIIIeMCH )J,HaJIOrOBOM OKHe BhI6paTh COOTBeTCTBYJOIIJ,YJO
KOMaH)J,y (YiJMUmb 6Ce cmpOKU HJIH YiJMUmb 6Ce cmo116U,bl). OtjJopM.11.euue Bneumezo BuiJa ma611uu,b1 BKJI1011aeT B ce6H cJie)J,YJO-
IIJ,He OCHOBHbie 011epau1111:
•H3MeHeHHe IIIHpHHhl CTOJI6IJ,oB;
•H3MeHeHHe BhICOThl CTpOK;
•ocl>opMJieHHe ceTKH Ta6JIHIJ,hI;
•H3MeHeHHe IIOJIO)l(eHH.sI Ta6JIHIJ,hl Ha CTpaHHIJ;e JIHCTa. Cnoco6 H3MeHeHHH IIIHpHHhl CTOJI6ua COCTOHT B CJie)J,yroIIJ,eM:
:::} ycTaHOBHTh YKa3aTeJih MhIIIIH Ha JieByro HJIH rrpaByro BepTHKaJih-
HYJO JIHHHIO CTOJI6ua (rrpH 3TOM yKa3aTeJib COOTBeTCTBeHHO H3MeHHT
HarrpaBJieHHe CTpeJIKH);
:::} Ha)l(aTb JieByIO KHOIIKY MhlIIIH H, He OTITYCKaH ee, «nepeTaIIJ,HTh» BepTHKaJihHYJO JIHHHJO COOTBeTCTBeHHO BJieBO HJIH BnpaBO Ha Tpe6yeMOe paCCTOHHHe.
30
lIIHplUJY CTOJI6U,OB MO)l(}{O J8,[(aTb c IIOMOlll,blO KOMaH,D,bl Bblcoma u mupuHa Jltteibcu HJ MeHIO Ta611uu,a.
BblCOTa 111060M: CTpOKH Ta6JIHU,bl MOlKeT 6bITb J8,[(aHa c IIOMOlll,blO KOMaH,D,bI Bbtcoma u mupuHa JltteiiKu HJ Memo Ta611uu,a O)J,HHM HJ Tpex napaMeTpoB: ABmo, MuHUMYM, TottHo.
IlapaMeTp ABmo orrpe)J,eJUieT BblCOT)'CTpOKH Ta6JIHU,bl B COOTBeTCTBHH c rrapaMeTpaMH a6Jau,a, KOTOpbie ycTaHaBJIHBalOTCH rrpH rrepBOHaqaJibHOM cpopMaTHpoBaHHH )J,OKYMeHTa. B 3TOM cnyqae BbICOTa CTpOKH Ta6JIHU,bl ycrnHaBJIHBaeTCH aBTOMaT:uqecKH B JaBHCHMOCTH OT paJMepoB BBO)J,HMOfO B Hqeti:KY TeKCTa.
IlapaMeTpbI MuHUMYM H TottHo ycTaHaBJIHBaIOTCH TOJibKO )],JUI CTpOK C03,lJ;aBaeMOH Ta6JIHU,bl. IlpH BbI6ope 3THX rrapaMeTpOB BblCOTa CTpOKH Ta6JIHU,bl 38,[(aeTCH q:ucJIOM TIHKCeJibHblX ToqeK.
Ilp:u BBOJJ;e TeKcrn B gqeliKY c ycTaHoBJieHHbIM napaMeTpoM
MYM MHHHMaJibHaH BhICOTa CTPOKH onpe.n;eJUieTcH 38,[(aHHblM qHcJioM
IlHKCeJibHblX ToqeK. 0)1;HRKO eCJIH pa3Mepbl BBOl!;HMOfO TeKCTa npeBblrnaK>T Ja,n;aHHbie pa3Meph1 gqeliKH, BblCOTa CTpOKH rn6JIHll.bl }'BeJIH~
qHBaeTCH B COOTBeTCTBHH c pa3MepaMH TeKCTa.
IlpH BBO)J,e TeKCTa B gqeliKY c ycTaHOBJJeHHhlM napaMeTPOM TottHo
BbICOTa cTpoKH He MeHHeTCH. Ecn:u pa3Mep BBO)J;HMoro TeKCTa npeBbIlllaeT 38,ll;aHHble pa3Mepbl gqeliKH, B Hett OCTaeTCH TOJibKO BMeCTHB~
rnancH ero HaqanhHaH qacTb.
Bb1c0Ta CTpOKH MOlKeT 6hITh 38,[(aHa KaK )],JUI Bceli rn611Hu,h1 cpa3y, TaK H )],JUI JI106oti: OT)J,eJibHOH CTpOKH. y CTaHOBKa BbICOTbl CTpOK Ta6JIHU,bl npOHJBO)J,HTCH B CJie)J,yIOlll,eM nopH)J,Ke:
==> Bbl)J,eJIHTb CTpOKY (HJIH Bee CTpOKH); ==> aKTHBHJHpoBaTb MeH10 Ta611uu,a;
==> BhI6paTb KOMaH,D,y Bbtcoma u mupuHa JltteiiKu;
==> B IIOHBHBIIIeMCH )J,HaJIOfOBOM OKHe ycTaHOBHTb napaMeTpbI: coma cmpoKu H CKollbKO (paJMep B IIHKCeJihHbIX ToqKax);
==> lll,eJIKHYTb MblIIlblO 110 KHOI1Ke [OK] )J,HaJIOfOBOfO OKHa.
Ha 3KpaHe B C03)J,aHHoti: rn611:uu,e cTpoKH H cT0116u,h1 (ceTKa rn6JIH- U.hI) Bhl)J,eJieHbI IIYHKTHPHOH JIHHHeti:, T. e. npH BhIBO)J,e )J,OKyMeHTa Ha npHHTep rn611Hu,a pacneqarneTcH 6e3 ceTKH. ,l1,mI pacrreqaTKH rn611Hu,b1 c ceTKOH Heo6XO)J,HMO BbIIIOJIHHTb CJie)J,YJOlll,He )J,eHCTBHH:
==> Bbl)J,eJIHTb Ta6JIHu,y;
==> aKTHBHJHpOBaTb MeHIO <PopMam;
==> Bh16paTb KOMaH,D,y 06paM11eHue u 3ano11HeHue... ;
==> B IIOHBHBIIIeMCH )J,HaJIOfOBOM OKHe aKTHBH3HpoBaTb BKJ18,[(KY 06paM!leHue H BbI6paTb He06XO)J,HMble ycTaHOBKH (paMKY HJIH ceTKY Ta6JIHU,hl, TOJilll,HHY H U,BeT JIHHHH);
==> lll,eJIKHYTb MblIIlblO no KHOrrKe [OK] )J,HaJIOfOBOfO OKHa.
IlpH lKeJiaHHH OT)J,eJibHhie CTOJI6U,bl HJIH CTpOKH Ta6JIHU,bl MO)l(}{O Bbl)J,eJIHTb paJJIHqHbIM U,BeTOM. )].JUI 3T0f0 Tpe6yeTCH:
==> Bhl)J,eJIHTb CTPOKY HJIH cT0116eu,; ==> aKTHBHJHpOBaTb MeHIO <PopMam;
31
~Bbr6paTb KOMaHJJ;y 06p(lMfleHue u 3anoAHeHue... ;
~B noHBHBllleMCSI .n;muroroBOM OKHe aKTHBH3HPOBaTb BKJia;:J;Ky 3anOJlHeHue H BbI6paTb Heo6XO)J,HMbie ycTaHOBKH (y3op, UBeT y3opa H
u;BeT <t>oHa);
~ I.IJ;eJirrnyTb MbllllbIO no KHOnKe [OK] )J,HaJIOroBoro OKHa.
O<t>opMHTb Ta61rnuy MOXHO c HCnOJib30BaHHeM ycTaHOBJieHHbIX B pe.n;aKTope THnOBbIX CTHJieH, .n;.rnr qero rpe6yeTCSI:
~ycTaHOBHTh KYPCOp B JI1060M MecTe Ta6JIHUhr;
~aKTHBH3HpoBaTb MeHIO Ta6Jlul{a;
~Bbr6paTb KOMaHJJ;y ABmo<jJopMam ma6AUl{bl... ;
~B nOHBHBIIIeMCH )J,HaJIOrOBOM OKHe BbI6paTb O)J,HH 113 npe.n;JiaraeMbIX <t>opMaTOB;
~I.IJ;eJirrnyTb MbIIIIbIO no KHOnKe [OK] )J,HaJIOroBoro OKHa.
Co3,!Ulllae TeKcTa a npeo6pa3oeaeae ero B Ta6JilllJY. 3Ta cxeMa co-
3.n;aHIDI Ta6JIHU npHMelUleTCH npH o<t>opMJieHHH )J,OKYMeHTOB, .n;.rnr
KOTOpbrx He CyI.IJ;ecTByeT ycTaHOBJieHHbIX <t>opM. B 3TOM cnyqae nocJie- )J,OBaTeJibHOCTb orrepau11H: H CIIOC06bl HX BbIIIOJIHeHIDI aHaJIO~HbI
HCIIOJib3yeMbIM B cxeMe o<t>opMJieHIDI Ta6JIHtIHbIX )J,OKYMeHTOB rrepBbIM crroco6oM ( o<t>opMJieHHe 3aroJIOBKa Ta6JIHUhl, JarroJIHeHHe Ta6JIHUbI HH$OpMau;HeH, o<t>opMJieHHe BHeIIIHero BH.n;a Ta6JIHUbI). 0TJIHq11e COCTOHT TOJibKO B IIOCJie)J,OBaTeJibHOCTH o<t>opMJieHIDI IIIaIIKH Ta6JIHUbI, KOTOpyIO paCCMOTpHM Ha npHMepe C03)J,aHIDI KaJieH,D;apHoro IIJiaHa BbIIIOJIHeHIDI pa60T (CM. Ta6JI. 2.1):
~Ha6paTb TeKcT JaroJIOBKa Ta6m1u;hr, np11qeM B npouecce Ha6opa B KOHUe TeKCTa Kax;:J;OH npe.n;noJiaraeMOH KOJIOHKH (KpOMe nocJie)J,- He:H) HaxHMaTb KJiaBHIIIY [Tab];
~Bbl,ll,eJIHTb Ha6paHHbIH TeKCT;
~aKTHBH3HpoBaTb MeHIO Ta6Auu,a;
~BKJIIOqHTb H306paxeHHe ceTKH KOMaHJJ;OH JfUHUU cemKu;
~Bhr6paTh KOMaH.n;y flpeo6pa3o6amb meKcm;
~B nOHBHBIIIeMCSI )J,HaJIOrOBOM OKHe I.IJ;eJIKHYTb MbllllblO no KHOn - Ke [OK].
ITocJie BhIIIOJIHeHIDI YKa3aHHhIX .n;e:HCTBHH Ha 3KpaHe nosi:BHTCH JaroJIOBOK Ta6JIHUbI.
Bee ;:J;aJibHe:Hrntte .n;e:HcTBIDI no cOJ.n;aHHIO rn6JIHU 6bIJIH paccMoTpeHbI paHee.
2.4. CocTaeneHMe Ta6nw·tHblX ,qoi<yMeHTOB c pac"teTaMM
B npoHJBo.n;crneHHo:H .n;esi:TeJibHOCTH JI106o:H <l>HPMhI 11cnoJibJYeTcsi: MHOXeCTBO .n;eJIOBbIX )J,OKYMeHTOB (KpOMe 6yxranTepCKHX), npH co- 3)J,aHHH KOTOpbIX Heo6XO)J,HMO BbIIIOJIHSITb pa3JIHqHbie MaTeMaT11qeCKHe BhNHCJieHHH. HanpHMep, ;:J;OKYMeHThI no yqery npttxo.n;a H pacxo.n;a npo.n;yKUHH; nporH03HpOBaHHIO npo.n;ax, H3MeHeHHH Kypca BaJIIOT, )J,HHaMHKH H3MeHeHHH pbIHKa no BH.n;aM npO;:J;YKUHH, )J,OXO)J,OB H T. n.; COCTaBJieHHIO 6aJiaHCOBbIX Ta6JIHU; yqery .n;eHe)l(HbIX qeKOB H .n;p.
32
IlpH pa3pa6oTKe TaKHX .n;oK}'MeHTOBB Word MO)l(}{O npoHJBeCTH Heo6xo.n;HMbie pacqeTbI, He npH6errui: K TaKHM .npHJIO)l(eHIDIM Windows, KaK KaJihKYIDITop HJIH Excel. IlpH 3TOM peJyJihTaThI pacqeTOB aBTOMan1qecKH BBOMTCH B COOTBeTCTBYJOII.t:He ~eHKH Ta6JIHU:bl.
Word o6Jia;:i;aeT tta6opoM MaTeMaTWiecKHx <l>YHKUHH, noJBOIDIIO- W.HX BbIIlOJIHHTb CJie.n;yromHe onepau;HH:
•CJIO)l(eHHe, BbNHTaHHe, YMHO)l(eHHe, .n;eJieHHe;
•BhiqHcJieHHe cpe.n;Hero JHaqeHHH;
•BbNHCJieHHe npou:eHTOB;
•BbI6op MHHHMaJibHbIX H MaKCHMaJibHbIX 3HaqeHHH. BbIIlOJIHeHlle MaTeMaTWieCKHX BbNHCJieHHH OCHOBbIBaeTCR Ha Me-
TO,ll;ax o6pa6oTKH HH<t>opMamm, npHMeHHeMblX B Ta6JIJiqtthlX npo.u;eccopax Lotus, Excel H ;:i;p. CymHOCTh 3THX MeTo.n;oB CBOAHTCR K TOM}', qTo Bee MaTeMaTWieCKHe ,lleHCTBHH npOH3BO,llRTCR c qHCJIOBhIMH ,llaHHbIMH, HaxOMII.t:HMHCR B ~eHKax Ta6mru;hl. Kax)laR ~e:HKa Ta6JIH.U:bl HMeeT 6YKBeHHo-qHcJioao:H CHMBOJI, HanpHMep Al, A2, Bl, B2 H
T.,ll., r,lle 6YKBa o603HaqaeT CTOJI6e.u: Ta6JIHIJ;hl, a .U:H<t>pa - CTpOKY (aKJIIOqaR CTpOKH warrKH).
IlepBhle 26 CTOJI6.U:OB Ta6mru;hl 0003HaqaJOTCR 6YKBaMH JiaTHHCKOro aJI<t>aaHTa OT A ,llO z. EcJIH CTOJI6.U:OB B Ta6JIH.U:e 60JibWe 26, TO OHH 0603Haqa10TCR AA ... AZ H T. Jl.
CTpoKH Ta6JIH.U:hI 060JHaqa10TcR qHcJiaMH, HaqH:HaR c e,llHHHIJ;hI. TaKHM o6pa3oM, Bbipa)l(eHHe Dl = A4 • C6 03HaqaeT, ~o qHcJio,
JanHCaHHOe B gqeifKe nepaoro CTOJI6u:a qeTBepTOH CTpOKH Ta6JIHU:bl (A4), YMHO)l(aeTCH Ha qHCJIO, 3aITHCaHHOe B gqeifKe TpeThero CTOJI6u:a weCTOH CTpOKH (C6), a pe3yJibTaT aBTOMaTHqecKH 3aITHCbIBaeTCH B gqeifKY qeTBepTOro CTOJI6u:a rrepBOH CTpOKH (DI).
<l>opM}'Jia.llJlH pacqern JanHCbIBaeTCH B TOH gqeifKe, r;:i;e tteo6xo.n;H-
MO YKa3aTh peJyJihTaT.
IlopH,llOK BbIIlOJIHeHH:H pacqeTOB paCCMOTpHM Ha npHMepe COCTaBJieHHH HaKJia,ll;HOH Ha Bbl,llaqy TOBapoB <l>HpMe-IIOKYfiaTemo co CKJia;:i;a <t>HpMbI-npo;:i;aau:a. <l>opMa TaKOH HaKJia,ll;HOH IlOKa3aHa B Ta6JI. 2.3 (He-
KOTOpbie peKBH3HTbl HaKJia,ll;HOH He rrpe,UCTaBJieHbl).
B rn6JI. 2.3 Ha;:i; cToJI6U:aMH YKaJaHbI 060JHaqa10mHe HX CHMBOJibI.
|
|
|
|
|
Ta6irnua 2.3 |
|
Haua,1uuu1 M _ ea OTl'JJY3KY Toaapa |
|
|||
A |
B |
c |
D |
E |
F |
N2 |
HaHMeHOBaHHe roaapa |
E.n.H3M. |
Ko11. |
l.l,etta, p. |
CTOHMOCTh, p. |
l |
3neKTpoqaifHHK «Tefal» |
IIIT. |
400 |
500 |
200000 |
2 |
3JieKTpoynor «Tefal» |
IIIT. |
700 |
450 |
315000 |
.Hroro 515000
33
IlpH JanOJIHeHHH HaKJia,z:i:HOH TJ)e6yeTC.sl aBTOManflieCKH BhlnOJIHHTb pac11eT CTOHMOCTH no KIDK,UOMY HaHMeHOBaHHIO H no.uBeCTH HTOr
no o6meif CTOHMOCTH OTnymeHHOro TOBapa.
CTOHMOCTh TOBapa nepBoro HaHMeHoBaHH.si: pacc11HThIBaeTc.si: no <l>OPMYJie F2 = 02 ·E2.
CTOHMOCTh TOBapa BToporo HaHMeHoBaHH.H F3 = 03 ·E3. Tor.ua cToHMOCTb Bcero TOBapa 6y.ueT npe,UCTaBJI.si:Tb co6oif CYMMY 3Ha'leHHH.s111eeK F2 H F3, T.e. F4=F2+F3.
Onpe.ueJIHB pac11eTHb1e <t>oPMYJibI, MO)l{}{O npHCTYCTaTh K JanoJIHeHHIO Ta6JIHUbI.
IlocJie,UOBaTeJibHOCTb pa3pa60TKH Ta6JIHUhl 6bma H3JIOXeHa pattee, no3TOMY }'KaxeMTenepb TOJibKO nocJie,llOBaTeJibHOCTb .ueifCTBHH, CB.slJaHHblX c BbIIlOJIHeHHeM pac11eTOB:
=> BBecTH 'IHCJiaB .s111e:HKH cTon6uoB Kon. H U:etta, p.);
=> Bbl,lJ;eJIHTb Bbl'IHCJI.HeM)'IOSl'leHKY(F2); => aKTHBH3HpoBaTb Memo Ta611u1-4a;
=> Bhl6paTb KOMaH,Uy <PopMy/la ...;
=> B IIO.slBHBIIIeec.si: .UHaJIOroBoe OKHO BBeCTH pac11eTH}'IO<l>OPMYJIY (= 02·E2);
=> Bhl6paTb <t>opMaT JaIIHCH 'IHCJia;
=> meJIKffYTb MbIIIlbIO no KHOnKe [OK].
PeJyJihTaT Bhl'IHCJieHH:HaBTOMaTH11ecKH 6y.ueT 3arrHcaH B .s111e:HKY F2. AHanorH'IHhie.ueifcTBH.H BhIITOJIHHTh ,UJI.H .s111eeK F3 H F4, BBe.u.si: COOTBeTCTByIOIUHe <l>OPMYJibl.
EcJIH Heo6xo.u11Mo ycTaHOBHTh ,UJI.H Bcex 11Hcen Ta6JIHUhI O.UHHaKoBhIH <t>opMaT JanHCH, TO BBO,UHTb HX cne.uyeT qepe3 KOMaH,Uy </JopMyJla, T. e. BBO,UHMOe 'IHCJIOCHa'laJiaJanHCbIBaeTC.sl B C'fPOKe </JopMy/la
,Ul-laJIOroBoro OKHa, a 3aTeM BbI6HpaeTC.sl <t>opMaT ero JanHCH. <l>opMaT 'IHCJia3TO BH,U OT06paxemrn ero npH BblBO,Ue Ha 3KpaH
H B ne11aTb. B .UHaJIOroBOM OKHe KOMaH,Ubl </JopMy/la ... MO)l{}{O BbI6paTb CJie,UyIOIUHe <t>opMaTbl 'IHCeJI:
###0 - uenoe <IHCJIO c paJ.uenettHeM Tb1c.si:11;
###0,00 - 'IHCJIO,Bbl'IHCJI.HeMoec TO'IHOCTbIO.uo BTOporo 3HaKa
nocJie JaII.si:TOH;
# ##0,00 p. - npe.ucTaBJieHHe <IHCJia B py6n.si:x.
,ll,.rr.si: CYMMHpOBaHH.sl pe3yJibTaTOB Bbl'IHCJieHHHMO)l(HO HCnOJib30-
BaTb <l>YHKUHIO SUM B cne,UyIOIUHX <t>opMax Jan11c11:
=SUM (Al: AlO) - Bhl'IHCJiettHeCYMM ,UJI.H .s111eeK c 1-if no cTon6ua A;
=SUM (Al;DlO) - BhI'IHCJiettHeCYMM M.H .si:qeeK c Al no 010;
=SUM (ABOVE) - Bb11111cnett11e CYMM M.H Bcex .s111eeK cTon6ua, HaxO,ll.slIUHXC.sl BbIIIIe TeKYIIIeH .si:qeifKH;
=SUM (LEFT) HJIH =SUM (RIGHn - Bhl'IHCJieHHeCYMM .llIDI Bcex
.si:qeeK CTpOKH, HaXO.U.HIUHXC.sl CJieBa HJIH cnpaBa OT TeKYIIIeH .si:qeifKH. Word npe.uocrnBJI.si:eT noJibJOBaTeJIIO .uocTaTO'IHhIHtta6op MaTeMa-
TH'IeCKHX<l>YHKUHH .llIDI BbIIIOJIHeHH.H IIIHpoKoro Kpyra paC'IeTHbIXJa,z:i:a'I.
34
N2 |
HaHMeHOBaHHe |
En. |
KoJI. |
UeHa, p. |
CTOHMOCTh, p. |
|
roeapa |
HJM. |
|||||
|
|
|
|
I3JieKTpoqaihrn:K lllT. 400 { = 500\#"###0"} { = D2*E2\\#"###0"}
«Tefal»
2 3JieKTpOynor |
lllT. 700 |
450 |
{ = D3*E3\\#"###0"} |
«Tefal» |
|
|
|
|
|
11roro |
|
PHc. 2.6. BH,11, HaKJia.uttoif c <l>OPMYJiaMH
nepeqeHb 3THX <l>YHKllHM MO.}l{HO ye::u,n;eTb B ,ll;HaJIOroBOM OKHe KOMaH-
)J.bl <J>opMylla...
IfTaK, HaKJia.n;Hrui: COCTaBJieHa, pacqeTbl BbIIIOJIHeHbl, HO Bbl o6Ha- P)')KIDIH,qTo HerrpaBHJibHO BBeJIH q:uCJIO OTrryw,eHHblX ynoroB. .nmi rrepepacqeTa Heo6xo.n;HMO BbillOJIHHTb CJie.ll}'IOIIlHe.n;eMCTBIDI:
~Bbl,ll;eJIHTb H'leMKYMH 3aMeHbl q:ucJia;
~y.n;armTh q:ucJio;
~aKTHBH3HpoBaTh MeHio Ta6Auu,a;
~Bb16paTb KOMaH,n;y <PopMylla ...;
~B IIOHBHBIIIeecH ,ll;HaJIOrOBOe OKHO BBeCTH HOBOe q:ucJio;
~BbI6paTb <t>opMaT 3aIIHCH q:ucJia;
~meJIKH}'TbMblIIIbIO no KHOIIKe [OK] (rrp:u 3TOM HOBOe 3HaqeH:ue
Jarr:uIIIeTcH B gqeifKY);
~aKTHBH3HpoeaTb MeHIO Ta6Auu,a;
~BhI6paTh KOMaHJJ.y BbtOeAumb ma611uu,y;
~Ha}l{aTb KJiaBHIIIY [F9] (Word rrpoH3Be)J.eT rrepecqeT eceu Ta6JIIDU>1);
~OTMeHHTb Bbl)J.eJiett:ue Ta6JIHUbl.
Ilp:u tteo6XO)J.HMOCTH rrpaBHJibHOCTb BBe)J.eHHbIX pacqeTHbIX <t>op-
MYJI MO)J(HO rrpoBepMTb, Bbl)J.eJIMB Ta6JIMuY M Ha)J(aB KOM6Mttaumo KJiaBMIII [Shift] + [F9], TOr)J.a Ta6JI. 2.3 6y)J.eT MMeTb BM)]., IlOKa3aHHbIM HapMC. 2.6.
lfa pHCyttKa BM)J.HO, qTo B gqeifKax CTOJI6ua Ko.JI. <l>OPMYJia OTCYTCTByeT. 3To 03HaqaeT, qTO q11cJia B 3TH gqenKH BBO)J.HJIMCb 06b1qHbIM crroco6oM, T. e. 6e3 rrp:uMetteHIDI KOMaHJJ.bI <PopMylla. B gqenKax c <t>opMyJiaMM YKa3aH eme M <t>opMaT BblBO)J.a q11cJia.
qT06bI BePHYTb Ta6JIHUe ee rrepBOHaqaJibHbIH BM)]., tteo6xo,n;HMO Bbl)J.eJIMTb ee M Ha)J(aTb KOM6Httaumo KJiaBHIII [Shift]+ [F9].
2.5. nocTpOeHMe ,qMarpaMM M rpa<l>MKOB Ha OCHOBe Ta6nM~
McrroJib30BattMe Word wrn co3)].att:uH )J.eJIOBbIX )J.OK}'MettTOBrro3BOm1eT rrpoBeCTM attaJIH3 CHT}'au:u:u M rrporH03HpOBatt:ue pe3yJibTaTOB )J.eHTeJibHOCTM <l>ttpMbI. PaccMOTpHM B03MO)J(HOCTM Word tta rrp11Mepe
35
|
|
|
|
Ta6nwua 2.5 |
|
|
Ta6JIHU.a ;:i;auuwx o coTpy.n;uuKax |
||||
<1>110 |
,[l;OJDKHOCTh |
OKJian;, |
,[l;am |
,[l;oMaunrnil: a11pec |
|
p. |
noc1)'IIJiemm |
||||
|
|
|
|||
HB<tHOB H.H. |
Be;:i;. HIDKeHep |
15 000 |
01.01.99 |
MocKBa, yn. E.Tio- |
|
|
|
|
|
JIHHKa, ,LI;. 39, KB. 34 |
|
Cw;:i;opoB C.C. |
MeHe.n;:lK:ep |
12 000 |
12.01.99 |
Eanaumxa, yn. |
|
|
|
|
|
JleHHHa, ;:i;.5, KB.123 |
|
TieTpoB TI.TI. |
Haq. oT.n;ena |
20000 |
20.12.98 |
MocKBa, yn. MMKOB- |
|
|
|
|
|
CKOro, ,LI;. 13, KB. 264 |
Ilocne.ri;oBaTeJibHOCTb 110HCKa u:mpopMaU,HH paCCMOTpHM Ha 11pu:- Mepe rn6n. 2.5, xpamnue:HcH Ha .ri;u:cKe c u:MeHeM basa.doc.
IlyCTb He06XOAHMO Haif:Tu: c11eu,1rnJIHCTOB <J:>u:pMbl, 11onyqa10mu:x OKJIM 6onee 12000 p. IloHCK ocymeCTBJIHeTCH B CJie)J;ylOII(eM 110PMKe:
=> Bb16paTb KOMaffAY Ea3a iJaHHblX B MeHIO BcmaB1ca, Ha 3KpaHe 110HBHTCH )J;HaJIOfOBOe OKHO Ea3a iJaHHblX (pu:c. 2.10);
=> meJIKffYTb MbllllblO 110 KHOl1Ke [IlonyqHTb .ri;aHHbie •.• ];
=> B 110HBHBIIIeMCH )J;HaJIOfOBOM OKHe (pu:c. 2.11) Bb16paTb H)')KHYlO
Ta6nu:u,y (6a3y .ri;aHHbIX) H meJIKffYTb MbllllblO 110 KHOl1Ke [OK];
=> B CJie)J;ylOII(eM 110HBHBIIIeMCH )J;HaJIOfOBOM OKHe (pu:c. 2.12) 110)];- TBep.ri;HTb, qTo 6a3a .ri;aHHhIX co3.ri;aHa B pe.ri;aKTope Word;
=> 110CJie 110)J;TBep)l()J.eHHH HCTOqHHKa .ri;aHHblX B )J;HaJIOrOBOM OKHe
2.10) meJIKffYTb MhIIIIhlO 110 KHOIIKe [ Onu,u:u:
=> B 110HBHBIIIeMCH )J;HaJIOrOBOM OKHe Onl(UU 3anpoca 3anu:caTb YCJIOBHH BbI6opKH Htt<J:>opMal(HH H3 6a3bl .ri;aHHbIX, KaK IIOKa3aHO Ha pu:c. 2.13, H meJIKffYTb MblIIlblO no KHOIIKe [OK];
=> B IIOHBHBIIIeMCH BHOBb )J;HaJIOfOBOM OKHe Ea3a iJaHHblX (CM. pu:c.
2.10) w:eJIKffYTb MbIIIlblO 110 KHOIIKe [BcTaBHTb .ri;aHHbie B AOKYMeHT] (TeKYW:HH).
6a3a aaHHbl>< |
EJ |
Pwc. 2.10. ,l],wanoroBoe OKHO Ea3a iJaHHbtx
38