Ooieoeeiiaeueiua aiciiaeiinoe i?ia?aiiu Excel 7.0
Eaeeie aea Ooieoeeiiaeueiuie aiciiaeiinoyie aeieaeai iaeaaeaoue
nia?aiaiiue i?ia?aiiiue i?iaeoeo oeia Excel? Enoi?ey ?acaeoey
i?ia?aii: ia?aaioee yeaeo?iiiuo oaaeeoe ian/eouaaao iaiiiaei aieaa
aeanyoe eao, ii iaeeoei ia?iiiue i?ia?ann a yoie iaeanoe i?ia?aiiiiai
iaania/aiey. Iiyoiio aiciiaeiinoe i?iaeoeoa, i?aoaiaeothuaai ia
caaiea naiie iiuiie e i?iecaiaeeoaeueiie i?ia?aiiu ia?aaioee
yeaeo?iiiuo oaaeeoe ec eiathueony naaiaeiy ia ?uiea, aeieaeiu auoue
auoa, ii e?aeiae ia?a, ia ii?yaeie ii n?aaiaieth n ia?auie i?ia?aiiaie
oaeiai ?iaea.
?anniio?ei iniiaiua eiiiiiaiou Aona1 7.0 (eioi?ua, iaaei
ioiaoeoue, iaei eciaieeenue ii n?aaiaieth n i?aaeuaeouae aa?neae
aeaiiie i?ia?aiiu). Iniiaie i?ia?aiiu yaeyaony, eae e ?aiueoa,
eaeueeoeyoeeiiiue (au/eneeoaeueiue) iiaeoeue, n iiiiuueth eioi?iai
i?ienoiaeeo ia?aaioea aeaiiuo (oaenoiauo eee /eneiauo) a oaaeeoeao.
Aeey nicaeaiey i?acaioaoeeiiiie a?aoeee eniieuecoaony iiaeoeue
aeeaa?aii, eioi?ue iicaieyao ia iniiaa /eneiauo cia/aiee, ia?aaioaiiuo
n iiiiuueth eaeueeoeyoeeiiiiai iiaeoey, iieo/aoue aeeaa?aiiu
?acee/iuo oeiia. Ooieoeeiiaeueiua aiciiaeiinoe iiaeoey aeeaa?aii
i?ia?aiiu Aona1 7.0 ai iiiaii i?aainoiaeyo niioaaonoaothuea
oa?aeoa?enoeee niaoeeaeueiuo i?ia?aii nicaeaiey aeaeiaie a?aoeee.
N iiiiuueth iiaeoey aacu aeaiiuo a Aonal 7.0 ?aaeeciaai aeinooi e
aiaoiei aacai aeaiiuo.
I?e eniieueciaaiee yoie oaoiieiaee iaaeaeo iauaeoaie
onoaiaaeeaaaoa aeeiaie/aneay naycue: anee iaiaoiaeeii, iai?eia?,
eciaieoue Aona1-oaaeeoeo, ano?iaiioth a ea/anoaa iauaeoa a WinWord
-aeieoiaio, aeinoaoi/ii auiieieoue aeaieiie uae/ie iuoueth ia oaaeeoea.
Iaeanoe i?eiaiaiey i?ia?aii ia?aaioee yeaeo?iiiuo
oaaeeoe.
Oe?ieia ?ani?ino?aiaiea i?ia?aii ia?aaioee yeaeo?iiiuo oaaeeoe ai
iiiaii iauyniyaony oieaa?naeueiuie aiciiaeiinoyie eo i?eiaiaiey
iineieueeo aac au/eneaiee, a oe?ieii niunea yoiai neiaa, ia iaieoenue a
naiuo ?acee/iuo noa?ao iaoae aeecie (iaeiaei ia i?aeoeea oaeia
i?aeiouanoai, ii aeaiiui ?ac?aaio/eeia , ia?aaeei i?eaiaeeo e oiio,
/oi “n?aaeiee iieueciaaoaeue” i?eiaiyao oieueei iyoue i?ioeaioia
ooieoeeiiaeueiuo aiciiaeiinoae, caeiaeaiiuo a Aona1, oioy ieaoeo ca ana
100%).
Aona1 iiaeii eniieueciaaoue eae aeey ?aoaiey i?inouo caaea/ o/aoa,
oae e aeey ninoaaeaiey ?acee/iuo aeaieia, aeaeiaie a?aoeee e aeaaea
iieiiai aaeaina Oe?iu. Iai?eia?, ia i?aaei?eyoee n iiiiuueth
Aona1 iiaeii iaeaa/aoue ?aoaiea oaeeo caaea/, eae ia?aaioea caeacia e
ieaie?iaaiea i?iecaiaenoaa, ?an/ao iaeiaia e ca?aaioiie ieaou, o/ao
eaae?ia e ecaea?aeae oi?aaeaiea nauoii e eiouanoaii e iiiaeo ae?oaeo.
Iaeiaei iaeanoue i?eiaiaiey i?ia?aiiu ia ia?aie/eaaaony oieueei
noa?ie aeaeiaie aeecie. Aeaaiaea?y iiuiui iaoaiaoe/aneei e
eiaeaia?iui ooieoeeyi n iiiiuueth Aona1 iiaeii ?aoeoue iiiaeanoai
caaea/ oaeaea a iaeanoe anoanoaaiiuo e oaoie/aneeo iaoe.
aiciiaeiinoe eniieueciaaiey yoie i?ia?aiiu, aaconeiaii, aeaeaei auoiaeyo
ca ?aiee oiiiyioouo, e Au, aei?iaie /eoaoaeue, iaiaeiie?aoii niiaeaoa
oaaaeeoueny a yoii.
E?aoeee iaci? aiciiaeiinoae
i?ia?aiiu Aonal 7.0
Iiyaeaiea eaaeaeie iiaie aa?nee i?ia?aiiu (aoaeue oi oaenoiaue
?aaeaeoi?, a?aoe/aneee ?aaeaeoi? eee yeaeo?iiiua oaaeeoeu) noaaeo
iieueciaaoaey ia?aae aeeeaiiie: ia?aoiaeeoue ee e
oniaa?oainoaiaaiiie aa?nee eee i?iaeieaeaoue iieueciaaoueny noa?ie,
iaaeaaeiie e oaea i?eau/iie? Eo/oee
a?aoiaio a iieco iiaie aa?nee – ia?a/aiue aa iiauo aiciiaeiinoae.
A ia?aie aeaaa eieae iu aeaai eo e?aoeia iienaiea.
Niaa?oainoaiaaiea i?ia?aii i?eiineo oe?iai – ?ac?aaio/eeai
iaiaeua aeioiaeu. Iiaua aa?nee iiyaeythony ia ?uiea ii/oe
aaeaaiaeii. Yoi aea/ao ca niaie ?anoe?aiea ia?a/iy caaea/,
?aoaaiuo i?eeiaeaieai, iaeiaei iiaeao cia/eoaeueii oneiaeieoue ?aaioo n
i?ia?aiiie.
N yoie oi/ee c?aiey Aona1 7.0 nei?aa yaeyaony eneeth/aieai,
iineieueeo Oe?ia Microsoft oaeaeyao i/aiue aieueoia aieiaiea aii?inai
eioa?oaena n iieueciaaoaeai. Iiiaea iiaua ooieoeee Iicrosoft Aona1
7.0 cia/eoaeueii iaeaa/atho iieueciaaoaeth auiieiaiea neiaeiuo
caaeaiee. Iicrosoft Eonal7.0 yaeyaony, ii nooe, ia?a?aaioaiiie e
iaiiiai ?anoe?aiiie aa?neae i?ia?aiiu Iicrosoft Aona1 5.0,
i?aaeiacia/aiiie aeey ?aaiou iiae i?aaeaieai iia?aoeeiiiie nenoaiu
Windows 95. I?e yoii neaaeoao ioiaoeoue oio oaeo, /oi Iicrosoft
Aona1 7.0, eae e ae?oaea i?eeiaeaiey , aoiaeyuea a ninoaa Iicrosoft
Office fia Windows 95, a iieiie ia?a eniieuecoao ana
aiciiaeiinoe iia?aoeeiiiie nenoaiu:
Ana i?eeiaeaiey, aoiaeyuea a ninoaa Iicrosoft Iffina fia
Windows 95, ?aaioatho a 32-?ac?yaeiii ?aaeeia, iiaeaea?aeeaatho
i?ei?eoaoioth iiiaicia/iinoue e aeeeiiua eiaia oaeeia (aei 255
ciaeia, aeeth/ay i?iaaeu, oi/ee e ae?oaea niaoeeaeueiua
neiaieu). E?iia oiai, iaeao i?ia?aii; aoiaeyueo a Iinaisoft
Iffina fia Windows 95, niaaaeai iiiaeie iiauie n?aaenoaaie
aeey iaiaia eioi?iaoeeae, a oaeaea iaania/eaaao aiciiaeiinoue
eieeaeoeaiie ?aaiou iaae aeieoiaioii.
Iieueciaaoaeue iiaeao nicaeaoue Shortkut (onei?eoaee) aeey
iaania/aiey auno?iai aeinooia e aeieoiaioo eee i?eeiaeaieth.
Ii n?aaiaieth n i?aaeuaeoueie aa?neyie Aonal 7.0 eiaao neaaeothuea
i?aeiouanoaa:
Templa Wizard Dfta Tracking : iicaieyao nicaeaaaoue oaaeii eaaeaeue
ec eioi?uo Au iiaeaoa eniieueciaaoue a ea/anoaa oi?iu aaiaea eioi?iaoeee
a aaco aeaiiuo.
Aiciiaeiinoue ?aaiou n aaia?aoe/aneeie ea?oaie: iicaieyao
eniieueciaaoue caaioiaee ea?o, iai?eia?, aeey iaaeyaeiiai i?aaenoaaeaiey
noaoenoe/aneeo aeaiiuo ii ?acee/iui ?aaeiiai.
Auto Filter with Oi? 10: iicaieyao auaiaeeoue nienee, ninoiyuea, ec
10 naiuo aieueoeo n/aoia, caeacia eee ethauo ae?oaeo
aeieoiaioia (/enei 10 onoaiaaeeaaaony ii oiie/aieth, e i?e
iaiaoiaeeiinoe Au iiaeaoa eciaieoue eiee/anoai yeaiaioia a nienea).
Auto Correct : iaeiia?aiaiii n aaiaeii oaenoa eni?aaeyao yaiua
ioia/aoee a aiaeeeneeo neiaao e ?anoeo?iauaaao, ca?aiaa
ii?aaeaeaiiua aaa?aaeaoo?u.
Eioaa?aoeey n Iinaisoft Annas : eniieuecoy i?ia?aiio – ianoa?
Convert to Acces Wizard , Au iiaeaoa i?aia?aciaaoue naith yeaeo?iiioth
a ianoiyuoth ?aeyoeeiiioth aaco aeaiiuo. Iiieii ooieoeee Convert to
Acces Wizard , a Iicrosoft Aona1 7.0 aeeth/aiu i?ia?aiiu – ianoa?a
Microsoft Acces Form Wizard and Report Wizard.
Auto Calculate: ioia?aaeaao a ieia Iicrosoft Aona1 7.0 noiio
yeaiaioia, n?aaeiaa cia/aiea, ieieiaeueiia eee iaeneiaeueiia
cia/aiea ec auaeaeaiiiai eioa?aaea y/aae.
Iniiaiua i?aaeea iino?iaiey oaaeeoeu
Iino?iaiea oaaeeoeu a Excel 7.0 auiieiyaony a ?aai/ai
eenoa. Au oaea ciaaoa, ?aai/ee eeno ?acaeaeai ia no?iee e noieaoeu,
i?e yoii ia?ana/aiey no?ie e noieaoeia ia?acotho y/aeee, a
eioi?uo, nianoaaiii, e niaea?aeeony eioi?iaoeey ,i?aaenoaaeaiiay a
?aai/ai eenoa . Auoa oaea oiiieiaeinue, /oi ?aai/ee eeno ninoieo
ec 256 noieaoeia e 16384 no?ie. Oaeei ia?acii, aeey aaiaea eioi?iaoeee
iiaeii eniieueciaaoue4 194 304 y/aeee.
N oaaeeoeaie eaaeaeiio ec ian ia ?ac i?eoiaeeeinue noaeeeaaoueny a
iianaaeiaaiie aeecie. Eo iiaeii ano?aoeoue ia eanniaii /aea
iaaaceia ,a aacaoao, ioaeeeothueo eo?nu aeoeee, e o.ae. Ana
oaaeeoeu eiatho iaeii iauaa naienoai – iaeii?iaeiinoue iino?iaiey.
Ia?aiauaiea aeaiiuo a ?aai/ai eenoa
Nei?inoue ?aaiou n aieueoeie neiaeiuie oaaeeoeaie . ai iiiaii
caaeneo io oiai , eae auiieiyaony ia?aiauaiea aeaiiuo ( y/aae n
aeaiiuie) aioo?e ?aai/aai eenoa. Ia?aiauaiea aeaiiuo i?iecaiaeeony
iooai eciaiaiey iiceoeee aeoeaiie y/aeee, a eioi?ie iiaeii
auiieiyoue aaiae aeaiiuo (aeoeaiay y/aeea caeeth/aia a ?aieo). I?e
ioe?uoee iiaie
?aai/ae eieae aeoeaiie yaeyaony y/aeea A1 a ia?aii eenoa ?aai/ae
eieae. Aae?an aeoeaiie y/aeee, eioi?ue ninoieo ec iineaaeiaaoaeueiinoe
caaieiaeia noieaoea e no?iee, oeacuaaaony a eaaie /anoe no?iee oi?ioe –
iiea eiaie. A aeaeueiaeoai iiiyoea oeacaoaeue y/aeee iiaeao
oiio?aaeyoueny oaeaea a cia/aiee aeoeaiay y/aeea.
A ?aai/ae eieaa anaaaea nouanoaoao oeacaoaeue y/aeee. *oiau
naeaeaoue y/aeeo aeoeaiie, neaaeoao auiieieoue uae/ie ia yoie y/aeea.
(I?inoi ia?aiauaiey oeacaoaey iuoe ia y/aeeo iaaeinoaoi/ii aeey aa
aeoeaecaoeee. ss/aeea noaiiaeony aeoeaiie oieueei iinea iaaeaoey
eaaie eiiiee iuoe.) N iiiiuueth eeaaeaoo?u ia?aiaoaoue oeacaoaeue
y/aeee , iiaeii iooai iaaeaoey eeaaeo oi?aaeaiey eo?ni?ii.
Anee y/aeea, eioi?oth iaiaoiaeeii aeoeaece?iaaoue, iaoiaeeony aia
aeaeeiie /anoe oaaeeoeu, neaaeoao ainiieueciaaoueny iieinaie
i?ie?ooee . A ioaeiii iai?aaeaiee ia?aiauaeoa aaaoiie
ai?eciioaeueiie/aa?oeeaeueiie eeiaeee i?ie?ooee a ioaeiii iai?aaeaiee
aei oao ii?, iiea niioaaonoaothuay /anoue oaaeeoeu ia aoaeao
i?aaenoaaeaia ia ye?aia, iinea yoiai aeoeaece?oeoa ioaeioth y/aeeo .
Ia?aeoe e y/aeea, eioi?ay iaoiaeeony, iai?eia?, iiae aeaeeiie /anoueth
oaaeeoeu, iiaeii oaeaea n iiiiuueth eeaaeoe [I]. I?e iaaeaoee
yoie eeaaeoe aeaeeiay /anoue oaaeeoeu niauaaony.
I?e iaaeaoee eeaaeoe [Page Up] aeaeeiay /anoue oaaeeoeu niauaaony
a iaeei ye?ai a noi?iio oiaiueoaiey iiia?ia no?ie, a i?e iaaeaoee
eeaaeoe [Page Down] – a ia?aoiii iai?aaeaiee. I?e iaaeaoee
eiiaeiaoeee eeaaeo [Alt + Page Down] aeaeeiay /anoue oaaeeoeu
niauaaony a iai?aaeaiee aic?anoaiey iiia?ia noieaoeia.
Iaiai aeaiiuie : Excel – ae?oaea i?eeiaeaiey.
N iiiiuueth nia?aiaiiuo i?ia?aiiiuo i?iaeoeoia iieueciaaoaeue
iiaeao ?aoaoue naiua ?aciiia?aciua caaea/e. Iai?eia?, i?e nicaeaiee
eieae naaiaeiy iiaeii iaieoenue aac oeiia?aoee e i?eaea/aiey
iiiaeo niaoeeaeenoia – aeinoaoi/ii iaeiiai /aeiaaea, “aii?oaeaiiiai”
ia?niiaeueiui eiiiuethoa?ii e DTP-i?ia?aiiie. Aea e nia?aiaiiua
oaenoiaua ?aaeaeoi?u oaeaea iaeaaeatho ooieoeeiiaeueiuie
aiciiaeiinoyie, iicaieytho nicaeaaaoue oeaeua eieae.
Iaeiaei noa?a i?eiaiaiey au/eneeoaeueiie oaoieee iaiau/ii
oe?iea, e e?oa caaea/, eioi?ua ?aoathony n iiiiuueth
.nia?aiaiiuo ia?niiaeueiuo eiiiuethoa?ia, iaaiciiaeii ioaaoeoue
oieueei iaeiie, aeaaea naiie niaa?oaiiie i?ia?aiiie. Eoi ciaao,
iiaeao auoue eiaaea-ieaoaeue ia ?uiea i?ia?aiiiiai iaania/aiey e
iiyaeony oaeay oieaa?naeueiay i?ia?aiia, eioi?ie “ii iea/o” aoaeao
ethaay caaea/a. Ii iiea /oi i?iaeaia iaiaia aeaiiuie ia oa?yao naiae
aeooaeueiinoe, iineieueeo aeey ?aoaiey neiaeiuo caaea/, eae i?aaeei,
i?eoiaeeony “i?eaeaeaoue” ianeieueei ?acee/iuo i?eeiaeaiee.
Neaaeoao oiiiyiooue aua ia iaeiii aniaeoa. Iaaa?iia, ie a
iaeiie io?anee aeeciaiiue oeeee i?iaeoeoa ia yaeyaony oaeei
ei?ioeei, eae a eiiiuethoa?iie. Oi, /oi a/a?a aua aini?eieiaeinue
iieueciaaoaeyie eae iiaoanoai, naaiaeiy oaea a/a?aoiee aeaiue. yoi
ioiineony eae e aiia?aoiiio iaania/aieth, oue e e i?ia?aiiiui
i?iaeoeoeeyi. Aeaiiua, eioi?ua aua a/a?a ia?aaaouaaeenue iaeiie
i?ia?aiiie, naaiaeiy iiaeii ai?acaei yooaeoeaiaa ia?aaioaoue n
iiiiuueth ae?oaie, aieaa niaa?oaiiie. Oaeei ia?acii, i?iaeaia iaiaia
aeaiiuie aicieeaao e a nayce n iiyaeaieai iiauo i?ia?aiiiuo
i?iaeoeoia e neaaeothueo aa?nee oaea nouanoaothueo .
?acee/atho aeaa ?aciiaeaeiinoe iaiaia aeaiiuie. A ia?aii
neo/aa iauaeou, nicaeaiiua n iiiiuueth i?ia?aiiu-enoi/ieea, aoaeo/e
aiaae?aiiuie a i?ia?aiio-i?eaiiee, oa?ytho naycue n “?iaeeoaeueneie”
i?ia?aiiie e ia?aaaouaathony eneeth/eoaeueii n?aaenoaaie i?ia?aiiu –
i?eaiieea
Ai aoi?ii neo/aa onoaiaaeeaaaony oae iacuaaaiay aeeiaie/aneay naycue
iaaeaeo i?ia?aiiie-enoi/ieeii e i?ia?aiiie-i?eaiieeii. Eciaiaiea
aeaiiuo a i?ia?aiia-enoi/ieea i?eaiaeeo e iaiiaeaieth aiaae?aiiuo
aeaiiuo a i?ia?aiia-i?eaiieea.
Ia aeaiiue iiiaio i?ia?aiiiue i?iaeoeo Excel 7.0 yaeyaony iaeiei ec
naiuo iiuiuo aeey PC – niaianoeiuo eiiiuethoa?ia.
Ii eiieo?aioeey ia ?uiea i?ia?aiiiuo i?iaeoeoia aeeeooao naie i?aaeea
aeaaea aeieai i?ia?aiiiiai aeciana. AEanoieay ai?ueaa ca eaaaeueiiai
iieueciaaoaey aeinoeaea a aeaayiinouo aiaeao naiaai aiiaay. Eiia/ii, a
auea?uoa ieacuaaaony i?aaeaea anaai iieueciaaoaeue – oioy au iioiio,
/oi naaiaeiy oe?iu-?ac?aaio/eee n/eoatho iaiaoiaeeiui eaaeaeue
i?ia?aiiiue i?iaeoeo niaaaeeoue ooieoeeyie, iaeaa/athueie
ia?aoiae e aieaa iiaie aa?nee i?ia?aiiu.
Нашли опечатку? Выделите и нажмите CTRL+Enter
