Basic Math in Excel yekuwedzera kubudisa, kugovera, uye kuwedzera
Pasi apa pane mazita ekubatanidzwa kune zvidzidzo zvinovhara matanho ematunhu ekuExcel.
Kana uchida kuziva kuti ungawedzera sei, kubvisa, kuwedzera, kana kugovana nhamba kuExcel, nyaya dzakanyorwa pasi apa dzichakuratidza kuti ungaita sei mazano kuita saizvozvo.
Nzira yekudzinga sei muExcel
Misoro yakafukidzwa:
- Nzira yekudzinga nhamba uchishandisa fomu ;
- Muenzaniso wekutsika-nhanho wekugadzira kuburitsa maitiro mu Excel uchishandisa nzvimbo uye cheka ;
- Sei kushandisa masero ezvinyorwa kuchaita kuti zvive nyore kuvandudza kuverenga kwako kana data yako inofanira kuchinja.
Nzira yekuparadzanisa sei muExcel
Misoro yakafukidzwa:
- Nzira yekuparadzanisa nhamba mbiri kuburikidza nesarudzo;
- Muenzaniso wekutsika-nhanho wekugadzira kupatsanurana muExcel kushandisa nhomwe uye cheka;
- Sei kushandisa sero zvinyorwa zvingaita kuti zvive nyore kuvandudza kuverenga kwako kana data yako ichifanira kuchinja;
Kuwanda Kwakawanda sei muExcel
Misoro yakafukidzwa:
- Nzira yekuwedzera nhamba mbiri uchishandisa fomu;
- Muenzaniso wekutanga-ne-nhatu wekusika fomu yekuwedzera mu Excel uchishandisa nzvimbo uye cheka;
- Sei kushandisa masero ezvinyorwa kuchaita kuti zvive nyore kuvandudza kuverenga kwako kana data yako inofanira kuchinja.
Nzira yekuwedzera sei muExcel
Misoro yakafukidzwa:
- Nzira yekuwedzera nhamba mbiri uchishandisa fomu;
- Muenzaniso wekutanga-ne-wekutanga wekugadzira fomu yekuwedzera muExcel uchishandisa pfungwa uye cheka;
- Sei kushandisa masero ezvinyorwa kuchaita kuti zvive nyore kuvandudza kuverenga kwako kana data yako inofanira kuchinja.
Kuchinja Mutemo wekushanda mu Excel Formulas
Misoro yakafukidzwa:
- Murairo wekushanda idzi mapurogiramu epasheetete anotevera paanongoronga fomu
- Nzira yekushandura urongwa hwekushanda mumashonga
Vanodzidzisa muExcel
Kunyange zvazvo zvisingashandisi kudarika pane mashematical operators zvakanyorwa pamusoro apa, Excel inoshandisa unhu hutsika
( ^ ) semuongorori wezvinyorwa.
Vanonyora dzimwe nguva vanotumidzwa sekuwedzerwa kudzokororwa kubva pane izvozvi-kana simba sezvinoitwa pane dzimwe nguva-inoratidza kangani nguva nhamba yepasi inofanira kuwedzerwa pachayo.
Semuenzaniso, mutsara 4 ^ 2 (mana emakona) - ane nhamba yepamusoro ye 4 uye inofanirwa 2, kana inonzi inokurudzirwa kune simba reviri.
Chero nzira, chirevo chimiro chiduku chekutaura kuti nhamba yepamusoro inofanira kuwedzerwa pamwe kaviri (4 x 4) kuti ipe mhinduro ye16.
Saizvozvowo, 5 ... 3 (mita shanu) inoratidza kuti nhamba ye5 inofanira kuwedzerwa pamwe chete katatu (5 x 5 x 5) kupa mhinduro ye 125.
Excel Math Mabasa
Mukuwedzera kune zvinyorwa zvemasvomhu zvakanyorwa pamusoro apa, Excel ine mabasa akawanda-akavakwa-mavara-ayo anogona kushandiswa kuita maitiro akawanda emasvomhu.
Izvi zvinosanganisira:
Basa reSUM - rinoita kuti zvive nyore kuwedzera mbiru kana mitsetse yenhamba;
Iyo PRODUCT PRODUCT - inowedzera nhamba mbiri kana kupfuura pamwe chete. Paunowedzera nhamba mbiri chete, fomu yekuwedzera iri nyore;
Iyo QUOTIENT basa - inodzokera chete inodzorera chikamu chakanaka (nhamba yose chete) yebasa rekuparadzanisa;
MOD inoshandiswa - inodzorera chete zvakasara zvebasa rekuparadzanisa.