Makombiyuta, Software
Magadzirirwo chokuwanziridza muna vachivapa
Simba spreadsheet "Microsoft Excel" nyore Ndichawanza chero nhamba dzako uye neeSultan. Kana zvingava zvechokwadi anobatsira panyaya iyi? Kune zvakawanda zvingaitwa:
- Ruoko hausi karukureta.
- Muwande huru neeSultan nhamba, uye uchida kuona kuti nhamba mhando vanobatanidzwa, uye zvichida kunyange kutsiva vamwe vavo (mu mureza karukureta mashandiro pasina kudikanwa kutanga mutsara zvakare kunze kukarukureta).
- Chokuwanziridza - chete chikamu chine pamusoro nzira.
Sezvaunogona kuona, kuti chokuwanziridza kuna Excel - chinhu zvachose kwete okushamisira. Pasina chokuwanziridza akavhiyiwa haagoni kuita zvinenge hapana fomura.
Variants vachiwedzera mu "Excel"
"Excel" kunoita kuti muwande nemumwe:
- Dzinenge nhamba (akanaka, kunaka, integer, fractional).
- Nenhamba masero aya.
- Ranges nhamba.
- Boolean tsika
Maitirwo chokuwanziridza? The yemaitiro chokuwanziridza muna Excel kunotanga "akaenzana" chiratidzo (=). Sezvo chero nzira hereinafter yakaratidza mumwe pashure imwe nhamba (kana bhuku sero ine pavo) kwakabatana chiratidzo "nyeredzi" (*). nzira yemaitiro kwakadaro kwaizova sezvinotevera: "= 0.22 * 16 -5 *" (kana dzawanda chaizvo nhamba) kana «= G4 * I5» (sezvo nenharo kana yakanatsa sero arimo). Iyi shanduro chokuwanziridza wokutanga.
chokuwanziridza fomura muna Excel anogona kunyorwa kushandisa yakavakwa-mu "kuti" basa:
shanda zita | nharo | tsananguro |
kuita | Number / dungwerungwe 1; Number / dungwerungwe 2; ... Number / dungwerungwe 255; | Mubayiro mashandiro - kungoerekana nenharo. Total 255 inogona kushandiswa chaizvo nhamba kana neeSultan (ukuru kuwanda haringorevi). |
The mukana kushandisa basa iri zviri kuita chokuwanziridza kuna Excel - zvichiita kuwedzera mumwe, kwete chete nhamba, asiwo zvisungo.
We funga chaizvo mienzaniso ikozvino.
Chokuwanziridza ne "nyeredzi"
Edza pamusoro pepa rinonzi "Excel" kutevera mienzaniso iyi:
ukoshi 1 | ukoshi 2 | fomura | mugumisiro | |
A | B | C | D | |
2 | 2 | 3 | = A2 * B2 | 6 |
3 | 0,7 | -6 | = A3 * B3 | -4,2 |
4 | CHOKWADI | CHOKWADI | = A4 * B4 | 1 |
5 | CHOKWADI | VENHEMA | = A5 * B5 | 0 |
6 | VENHEMA | VENHEMA | = A6 * B6 | 0 |
Navo uchaona kuti kuita chokuwanziridza muna Excel zviri nyore. Cherechedza kuti mugumisiro wacho chokuwanziridza pfungwa tsika kuva 0 (venhema) kana 1 (true).
The chete drawback pamusoro nzira iyi chokuwanziridza - kuti siyana nhamba sezvo nharo, haagoni kugamuchira. Zvichida vaifanira, iri zvakakwana chipi User chinorondedzerwa kumwe pakupera wechipiri nhamba gumi kana muchitokisi, kutama, uye interleaved kuitira vatambi "asiterisiki."
The chete nzira kumativi drawback iri kushandisa "kuti" basa.
Chokuwanziridza achishandisa "kuti" basa
Funga sei kuita chokuwanziridza muna Excel kushandisa pakuvara ushande.
The workbook "Excel" kuumba zvakafanana mundiro uye kuongorora mienzaniso yake. Mune imwe sa kuita akawanda tsika imwe mbiru kuitawo anoreva zvakawanda. Edza kushandisa mashandiro "kuti" zvisungo zvenyu, uye kuita chokuwanziridza noruoko kuburikidza chiratidzo "nyeredzi".
H | ini | J | K | |
Range 1 | Range 2 | mugumisiro | fomura | |
12 | 2 | 6 | 9,378,270.72 | Yakabudiswa = (H12: H16; I12: I16) |
13 | 7 | 14.2 | 9,378,270.72 | Yakabudiswa = (H12: I16) |
14 | 5 | -2,7 | 9,378,270.72 | = H12 * H13 * H14 * H15 * H16 * I12 * I13 * I14 * I15 * I16 |
15 | 0.26 | 4 | ||
16 | -10 | 56 |
In mbiru "Formula" patafura ichi chinoratidza zvakajeka kuti kana kukosha neeSultan vari pedyo, zvinogona kushandiswa sezvo zvakawanda. Uyewo patafura unogona kuona kuti mashandiro "kuti" kuwanda ose neeSultan izvi, uye kuwana migumisiro saizvozvo sokunge takanga ruoko mumwe Anowanza kukosha masero aya. Sezvaunogona kuona, kuti chokuwanziridza kuna Excel - ari Snap.
Interesting chokwadi! Edza imwe ukoshi zvino kubviswa chero muchitokisi, chikamu kuwanda, masero chinhu achava chose chinhu. Uchaona kuti panguva iyoyo kuita basa kuita kuverenga, kungotaura kwokusunungura ane sero chinhu. Uye pano mugumisiro "Chinyorwa" chokuwanziridza akatendeukira razero. Izvi chimwezve akasiyana kushandisa pakuvara nezvechisarudzo kuwanda "asiterisiki" - haina kubvuma masero varara sezvo zero, izvozvo chete anosunungura kubva kukarukureta.
Pane nguva apo Masvomhu dzinoitwa nokuda muzvizhinji basa machira mabhuku, uye kunoguma jira inochengeterwa yemaitiro kuitika zvinobikwa zvinokosheswa mamwe machira. Kana mumwe wavo uchava chinhu, iri nyore chokuwanziridza ari "nyeredzi" kutendeukira kunoguma zvenyu zvose muna razero.
Kubva ichi tinogona kugumisa kuti basa rokutarisira Masvomhu zvakaoma pamusoro machira akawanda zviri nani kushandisa mashandiro "kuti" ave chokutanga.
chokuwanziridza tafura
Tarisai pakupedzisira, kuumba tafura chokuwanziridza muna Excel. Zviri nyore.
A | B | C | D | E | |
1 | 2 | 4 | 6 | 8 | |
2 | 3 | = $ A2 * B $ 1 | 12 | 18 | 24 |
3 | 5 | 10 | 20 | 30 | 40 |
4 | 7 | 14 | 28 | 42 | 56 |
5 | 9 | 18 | 36 | 54 | = $ A5 * E $ 1 |
In tsika mureza chokuwanziridza tafura rinosanganisira mbiru imwe yakatarwa nhamba mumutsetse - mumwe. Kuti kukwanisa kutevedzera nzira, zvakakodzera kushandisa vakavhengana Links - kugadzirisa by chiratidzo "dhora" ($) Mbiru nhamba kubvira kutwasuka Data mitsetse uye zvido zvevanhu kuti mashoko '= A2 * $ B $ 1 ".
Similar articles
Trending Now