Iienaiea ?aaiou (Oai?aoe/aneay /anoue).
IINO?IAIEA OAAEEOe
Ana aeaiiua oaaeeoeu caienuaathony a oae iacuaaaiua y/aeee, eioi?ua
iaoiaeyony ia ia?ana/aiee no?ie e noieaoeia oaaeeoeu. Ii oiie/aieth
niaea?aeeiia y/aeee i?aaenoaaeyaony i?ia?aiiie Excel a noaiaea?oiii
oi?iaoa, eioi?ue onoaiaaeeaaaony i?e caionea i?ia?aiiu. Iai?eia?,
aeey /enae e oaenoia caaeaaony ii?aaeaeaiiue aeae e ?acia? o?eooa.
A i?ia?aiia Excel eiathony eiioaenoiua iaith, eioi?ua aucuaathony
i?aaie eiiieie iuoe, eiaaea i?iia?ee?iaaia iaeioi?ay iaeanoue oaaeeoeu.
Yoe iaith niaea?aeao iiiai aee?aeoea ia?aaioee e oi?iaoe?iaaiey
oaaeeoe. Aee?aeoeau oi?iaoe?iaaiey iiaeii oaeaea aucaaoue ia
iaiaee oi?iaoe?iaaiey (aoi?ay no?iea ieeoia?aoe/aneiai iaith),
uaeeioa iuoueth ii niioaaonoaothuae ieeoia?aiia.
Ia?ee?iaaiea y/aae.
Ioaeaeueiua y/aeee oaaeeoeu ia?ee?othony (auaeaeythony) aaoiiaoe/anee n
iiiiuueth oeacaoaey y/aae. *oiau ia?aaanoe oeacaoaeue a caaeaiioth
y/aeeo, ioaeii uaeeiooue ii iae eaaie eiiieie iuoe eee
eniieueciaaoue eeaaeoe oi?aaeaiey eo?ni?ii. Aeey ia?ee?iaee ianeieueeeo
y/aae ioaeii uaeeiooue a ia/aea ia?ee?oaiie iaeanoe (eaaue
aa?oiee oaie) e, oaea?aeeaay eiiieo iuoe iaaeaoie, ia?aiauaoue
iaieioeyoi? a eiiaoe iaeanoe (i?aaue ieaeiee oaie). *oiau ioiaieoue
ia?ee?iaeo iaeanoe, iiaeii i?inoi uaeeiooue ii iaia?ee?iaaiiie
y/aeea. Aeey ia?ee?iaaiey ianeieueeeo y/aae n iiiiuueth
eeaaeaoo?u iaiaoiaeeii onoaiiaeoue oeacaoaeue y/aae a ia/aeueioth y/aeeo
iaeanoe, a caoai, oaea?aeeaay eeaaeoo [Shift] iaaeaoie,
?ani?ino?aieoue ia?ee?iaeo ia anth iaeanoue n iiiiuueth eeaaeo
oi?aaeaiey eo?ni?ii.
Iaeia no?iea eee noieaaoe oaaeeoeu ia?ee?othony uae/eii ii iiia?o
(aae?ano), eioi?ue ?aniieiaeai a caaieiaea no?iee eee noieaoea.
Aeey ia?ee?iaaiey ianeieueeeo no?ie eee noieaoeia ioaeii uaeeiooue ii
iiia?o ia?aie no?iee (noieaoea), a caoai, oaea?aeeaay eiiieo iuoe
iaaeaoie, ia?aianoeoue iaieioeyoi? a ioaeioth iiceoeeth.
OAAEE*IUA AU*ENEAIEss
Aiciiaeiinoue eniieueciaaiey oi?ioe e ooieoeee yaeyaony iaeiei ec
aaaeiaeoeo naienoa i?ia?aiiu ia?aaioee yeaeo?iiiuo oaaeeoe. Yoi, a
/anoiinoe, iicaieyao i?iaiaeeoue noaoenoe/aneee aiaeec /eneiauo
cia/aiee a oaaeeoea.
Oaeno oi?ioeu, eioi?ay aaiaeeony a y/aeeo oaaeeoeu, aeieaeai
ia/eiaoueny ni ciaea ?aaainoaa (=), /oiau i?ia?aiia Excel iiaea
ioee/eoue oi?ioeo io oaenoa. Iinea ciaea ?aaainoaa a y/aeeo
caienuaaaony iaoaiaoe/aneia au?aaeaiea, niaea?aeauaa a?aoiaiou,
a?eoiaoe/aneea iia?aoeee e ooieoeee.
A ea/anoaa a?aoiaioia a oi?ioea iau/ii eniieuecothony /enea e aae?ana
y/aae. Aeey iaicia/aiey a?eoiaoe/aneeo iia?aoeee iiaoo eniieueciaaoueny
neaaeothuea neiaieu: + (neiaeaiea); – (au/eoaiea); * (oiiiaeaiea); /
(aeaeaiea).
Oi?ioea iiaeao niaea?aeaoue nnueee ia y/aeee, eioi?ua
?aniieiaeaiu ia ae?oaii ?aai/ai eenoa eee aeaaea a oaaeeoea ae?oaiai
oaeea. Iaeiaaeaeu aaaaeaiiay oi?ioea iiaeao auoue a ethaia a?aiy
iiaeeoeoee?iaaia. Ano?iaiiue Iaiaaeaea? oi?ioe iiiiaaao
iieueciaaoaeth iaeoe ioeaeo eee iai?aaeeueioth nnueeo a aieueoie
oaaeeoea.
E?iia yoiai, i?ia?aiia Excel iicaieyao ?aaioaoue ni neiaeiuie
oi?ioeaie, niaea?aeaueie ianeieueei iia?aoeee. Aeey iaaeyaeiinoe
iiaeii aeeth/eoue oaenoiaue ?aaeei, oiaaea i?ia?aiia Excel aoaeao
auaiaeeoue a y/aeeo ia ?acoeueoao au/eneaiey oi?ioeu, a nianoaaiii
oi?ioeo.
Aaiae oi?ioe.
I?ia?aiia Excel eioa?i?aoe?oao aaiaeeiua aeaiiua eeai eae oaeno
(au?aaieaaaony ii eaaiio e?ath), eeai eae /eneiaia cia/aiea
(au?aaieaaaony ii i?aaiio e?ath). Aeey aaiaea oi?ioeu iaiaoiaeeii
aaanoe aeaaa?ae/aneia au?aaeaiea, eioi?iio aeieaeai i?aaeoanoaiaaoue
ciae ?aaainoaa (=).
I?aaeiieiaeei, /oi a y/aeea A1 oaaeeoeu iaoiaeeony /enei 100, a a y/aeea
A1 – /enei 20. *oiau ?acaeaeeoue ia?aia /enei ia aoi?ia e
?acoeueoao iiianoeoue a y/aeeo N1, a y/aeeo N1 neaaeoao aaanoe
niioaaonoaothuoth oi?ioeo (=A1/A1) e iaaeaoue [Enter].
Aaiae oi?ioe iiaeii nouanoaaiii oi?inoeoue, eniieuecoy iaeaiueeee
o?the. Iinea aaiaea ciaea ?aaainoaa neaaeoao i?inoi uaeeiooue
iuoueth ii ia?aie y/aeea, caoai aaanoe iia?aoeeth aeaeaiey e uaeeiooue
ii aoi?ie y/aeea.
Neiaeiua oi?ioeu.
I?eiaiaiea neiaeiuo oi?ioe i?iaeaiiino?e?oai ia i?eia?a.
B C D E
10 ?AAIOA A?AIss OeAIA NOIIA
11 Iano?ieea
eeaaeaoo?u 2 $ 17.80
$ 35.60
12 Ianeoaeeaaiea
iaoei 4 $ 3.80 $ 15.20
13 Iiaeaioiaea oi?ioey?ia 8 $ 1.56 $ 12.48
14
15
16 Noiia
$ 63.28
17 IAeN 15%
$ 9.49
?en.1.
A noieaoea N i?eaaaeaiiie oaaeeoeu oeacaii a?aiy (a /anao), cao?a/aiiia
ia auiieiaiea ?aaiou, a noieaoea D – noieiinoue iaeiiai /ana
?aaiou, a a noieaoea A – i?iiaaeooi/iay noiia, eioi?oth iaaei
caieaoeoue ca yoo ?aaioo. A y/aeea A16 ioaeii au/eneeoue iauoth
noieiinoue anao ?aaio. Aeey yoiai ooaea iaaei caienaoue neaaeothuoth
oi?ioeo: =A12+A13+A14. Iieo/aiioth noiio oiiiaeueoa ia 0,15,
/oiau o/anoue iaeia ia aeiaaaeaiioth noieiinoue, e ?acoeueoao iiianoeoa
a y/aeea A17: =A16*0,15.
Aeey au/eneaiey eiia/iie noiiu, iiaeeaaeauae iieaoa (iai?eia?,
a y/aeea A19) iaaei nia/aea neiaeeoue i?iiaaeooi/iua noiiu, a caoai
?acoeueoao oiiiaeeoue ia 0,15. Oi?ioea aeieaeia eiaoue aeae:
=(A12+A13+A14)*0,15. Eiia/ii, iiaeii auei au e i?inoi
i?inoiie?iaaoue niaea?aeeiia y/aae A16 e A17. Aeey neiaeaiey /enae
iiaeii oaeaea eniieueciaaoue ooieoeeth noiiu Noii(), oiaaea
oi?ioea aoaeao auaeyaeaoue neaaeothuei ia?acii: =Noii(E12:E14)*0,15.
?aaeaeoe?iaaiea oi?ioe.
*oiau ia/aoue ?aaeaeoe?iaaoue niaea?aeeiia y/aeee, ioaeii
nia/aea i?iia?ee?iaaoue yoo y/aeeo. Ia neaaeothuai oaaa
iaiaoiaeeii aeeth/eoue ?aaeei ?aaeaeoe?iaaiey, iaaeaa eeaaeoo [F2] eee
auiieiea aeaieiie uae/ie iuoueth. A ?aaeeia ?aaeaeoe?iaaiey a aa?oiae
/anoe ye?aia (iiae no?ieie ieeoia?aoe/aneiai iaith) aeoeaece?oaony
iaai?iay no?iea, a eioi?ie aeaeia naia oi?ioea, a ia ?acoeueoao aa
au/eneaiey.
IINO?IAIEA E IOI?IEAIEA AeEAA?AII
A?aoe/aneea aeeaa?aiiu iaeeaeytho nooea eieiiee oeeo? a oaaeeoea,
iiyoiio oaea a ?aiieo aa?neyo i?ia?aiiu Excel auea i?aaeoniio?aia
aiciiaeiinoue iino?iaiey aeeaa?aii. A iyooth aa?neth Excel aeeth/ai
iiaue Eiino?oeoi? aeeaa?aii, eioi?ue iicaieyao nicaeaaaoue aeeaa?aiiu
“i?acaioaoeeiiiiai ea/anoaa”.
E?aneaay o?aoia?iay aeeaa?aiia ia oieueei ?aaeoao aeac, ii e oeo/oaao
ea/anoai aeieoiaioa. A i?ia?aiia MS Excel 5.0 iiyaeeny iiaue oei
o?aoia?iuo aeeaa?aii – oae iacuaaaiua eieueoeaaua aeeaa?aiiu,
eioi?ua aeiiieiytho iiaa?oiinoiua e nao/aoua o?aoia?iua
aeeaa?aiiu /aoaa?oie aa?nee.
Aeeaa?aiio iiaeii ?aniieiaeeoue ?yaeii n oaaeeoeae eee
?acianoeoue aa ia ioaeaeueiii ?aai/ai eenoa.
Eiino?oeoi? aeeaa?aii yaeyaony iaeiei ec iaeaieaa iiuiuo n?aaenoa a
i?ia?aiia Excel. Iino?iaiea aeeaa?aiiu n aai iiiiuueth auiieiyaony ca
ianeieueei oaaia. Eiino?oeoi?o oeacuaaaony enoiaeiay iaeanoue
oaaeeoeu, oei aeeaa?aiiu, eniieuecoaiua iaaeiene e oeaaoa. Ia iniiaiie
iaiaee eiaaony ieeoia?aiia aeey auciaa Eiino?oeoi?a aeeaa?aii.
Iino?iaiea aeeaa?aii.
I?aaeaea /ai no?ieoue aeeaa?aiio, iaiaoiaeeii caeii/eoue ana ?aaiou
a oaaeeoea, aeeth/ay aa oi?iaoe?iaaiea. Auciaeoa Eiino?oeoi?
aeeaa?aii, uaeeioa ia iniiaiie iaiaee ii 17-e ieeoia?aiia.
Eiino?oeoi? aeeaa?aii aoaeao iaeeaeaoue eioi?iaoeee i
ianoiiaoiaeaeaiee aeeaa?aiiu, iiyoiio oeacaoaeue iuoe i?eia?aoaao oi?io
ieeoia?aiiu Eiino?oeoi?a. Au aeieaeiu naeaeaoue n iiiiuueth oeacaoaey
iuoe i?yiioaieueiee ia naiaiaeiii ianoa ?aai/aai eenoa, aaea
aoaeao ?aciauaia aeeaa?aiia. Aeey yoiai uaeeieoa eaaie eiiieie iuoe, a
caoai, ia ioioneay aa, ioaoene?oeoa ia?aciaaaoothny iinea
uae/ea ioieoe?ioth ?aiea ec aa?oiaai eaaiai oaea
i?yiioaieueiie iaeanoe a i?aaue ieaeiee oaie. Anee aeeaa?aiio ioaeii
iino?ieoue ia ioaeaeueiii eenoa, oi ioe?ieoa a iaith «Anoaaea»
iiaeiaith «Aeeaa?aiia» e auaa?eoa a iai aee?aeoeao «Ia iiaii eenoa».
Iinea yoiai Eiino?oeoi? ioe?uaaao aeeaeiaiaia ieii, a eioi?ii ca
iyoue oaaia ioaeii iino?ieoue aeeaa?aiio. Ii nia/aea ioaeii oeacaoue
iiceoeeth, aaea iaoiaeeony oaaeeoea aeaiiuo, ia iniiaa eioi?ie
no?ieony aeeaa?aiia. Aeey yoiai ia ia?aii oaaa i?iia?ee?oeoa
iuoueth naith oaaeeoeo, aeeth/ay caaieiaee no?ie e noieaoeia.
*oiau auiieieoue aeaa neaaeothueo oaaa, uaeeieoa ii eiiaiaeiie eiiiea
Aeaeaa e auaa?eoa ec i?aaeeiaeaiiuo ia?acoeia oei e aeae aeeaa?aiiu
niioaaonoaaiii. Ia /aoaa?oii oaaa Eiino?oeoi? i?aaeeaaaao
i?aaeaa?eoaeueiue i?iniio? iieo/eaoaeny aeeaa?aiiu. Ia iineaaeiai
(iyoii) oaaa inoaaony oieueei caaeaoue eiy aeeaa?aiiu, aa eaaaiaeo
(o.a. niioaaonoaea iaaeaeo noieaoeaie aeeaa?aiiu e oaaee/iuie
aeaiiuie), a oaeaea oeacaoue iaaeiene ia inyo aeeaa?aiiu.
A caeeth/aiee uaeeieoa ii eiiaiaeiie eiiiea Aioiai, e aeeaa?aiia
iiyaeony a oeacaiiie iaeanoe ?aai/aai eenoa.
Oeiu aeeaa?aii.
Oei aeeaa?aiiu iiaeii caaeaoue o?aiy ?acee/iuie niiniaaie. Ia?aue
niinia iienai a ?acaeaea 5.1. Aoi?ie niinia naycai n aoiaeii a ?aaeei
?aaeaeoe?iaaiey aeeaa?aiiu, eioi?ue aeeth/aaony aeaieiui uae/eii
eaaie eiiiee iuoe aioo?e ?aiee aeeaa?aiiu.
Oiaaea a iaith Oi?iao iiyaeony aee?aeoeaa Oei Aeeaa?aiiu. Auciaeoa yoo
aee?aeoeao e a ioe?uaoainy aeeaeiaiaii ieia auaa?eoa
iiaeoiaeyuee oei aeeaa?aiiu.
Iaeiaei i?iua anaai ainiieueciaaoueny a?aoe/aneei iaith. Uaeeieoa
i?aaie eiiieie iuoe a iaeanoe ieeoia?aoe/aneie iaiaee e a ioe?uaoainy
iaith auciaeoa aee?aeoeao Aeeaa?aiia. A aa?oiae /anoe ye?aia ni?aaa
iiyaeony iaeaiueeia a?aoe/aneia iaith. Ia?aay ieeoia?aiia yoiai
iaith ii?aaeaeyao oei aeeaa?aiiu. Iinea uae/ea ii no?aeea, eioi?ay
iaoiaeeony ?yaeii n yoie ieeoia?aiiie, ia?aae Aaie ioe?iaony nienie,
niaea?aeauee ana oeiu aeeaa?aii.
Нашли опечатку? Выделите и нажмите CTRL+Enter
