Computer, Software
Indlela ukwenza phindo Excel
spreadsheet enamandla "Microsoft Excel" ngokulula ndiyandise nayiphi na iinombolo zakho zibe. Xa kunokuba luncedo ngokwenene ngokuphathelele kulo mba? Kukho izisombululo ezininzi:
- akukho ikhalityhuleyitha isandla.
- Ubandisile ke zibe amakhulu amanani, kwaye ufuna ukubona uhlobo amanani ababandakanyekayo ntoni, yaye mhlawumbi nokuba ubambela ezinye zazo (kwi imisebenzi eqhelekileyo calculator ngaphandle kwesidingo ukuqala umgca kwakhona ukugcina ukubala).
- Uphinda-phindo - yinxalenye kuphela eyakhiwa ngayo le ifomula.
Njengoko ubona, i-phinda ukuya ku-Excel - nto kwaphela ononyawo. Ngaphandle phinda imisebenzi abakwazi ukwenza phantse akukho mntu ifomula.
Ezahlukeneyo phinda ngo "Excel"
"Excel" ikuvumela ukuba phinda omnye komnye:
- amanani ezithile (positive, negative, inani elipheleleyo, fraction).
- Amanani ezi seli.
- Zibe amanani.
- amanani boolean
Indlela ukwenza uphinda-phindo? Ifomula-phindo e-Excel luqala "ulingana no" umqondiso (=). Njengoko na apha ifomula kuboniswe enye emva kwenye inombolo (okanye zeseli equlethe kubo) enxulumene uphawu "inkwenkwezi" (*). Loo ifomula bekuya kuba ngolu hlobo lulandelayo: "= 0.22 * 16 -5 *" (inani ezithile xa iphinda) okanye «= G4 * I5» (njengoko iingxoxo xa iimbekiselo elikhankanyiweyo iseli). Olu luguqulelo yokuqala phindo.
ifomula phindo e Excel esinoshicilelwa usebenzisa i "yenza" function eyakhelwe-ngaphakathi:
umsebenzi igama | iimpikiswano | incazelo |
ukwenza | Inani / uluhlu 1; Inani / uluhlu 2; ... Inani / uluhlu 255; | Isiphumo umsebenzi - imveliso lokuphikisana. Iyonke 255 ukuze ingasetyenziswa amanani ezithile okanye kwizintlu (ubukhulu uluhlu akupheleli). |
Inzuzo yokusebenzisa lo msebenzi ngayo ukwenza phinda ukuya ku-Excel - amathuba phinda nitshabalalisane, kuphela amanani, kodwa izitropu.
Ngoku makhe siqwalasele imizekelo ezithile.
Multiplication yi "inkwenkwezi"
Zama phezu lokusebenzela incwadi "Excel" ukulandela le mizekelo:
inani 1 | inani 2 | ifomula | ngenxa | |
A | B | C | D | |
2 | 2 | 3 | = A2 * B2 | 6 |
3 | 0.7 | -6 | = A3 * B3 | -4,2 |
4 | INYANISO | INYANISO | = A4 * B4 | 1 |
5 | INYANISO | FALSE | = A5 * B5 | 0 |
6 | FALSE | FALSE | = A6 * B6 | 0 |
Nabo, uya kubona ukuba kwenza phindo e-Excel kulula. Qaphela ukuba ngenxa phindo amaxabiso logic zibe 0 (lobuxoki) okanye 1 (oyinyaniso).
Le ethile kuphela yale ndlela uphinda-phindo - ukuba uluhlu lwamanani njenge mpikiswano, akanako ukwamkela. Mhlawumbi eliphezulu, apho Kwanele nayiphi ngumsebenzisi ochazwe kwenye ekupheleni amanani yesibini ezilishumi okanye iseli, siyashukuma, eneSandi ngoonobumba ukuze "asterisk."
Indlela kuphela niyijikeleza le ethile kukusebenzisa 'ukwenza "function.
Multiplication usebenzisa 'ukwenza "umsebenzi
Cinga ukwenza phindo kwi Excel usebenzisa umsebenzi eyakhelwe-ngaphakathi.
Incwadi "Excel" ukudala ipleyiti efanayo khangela kwimizekelo zakhe. Elinomhlathi omnye ukwenza izinto ezininzi kwenye kwikholam kwenza neentsingiselo eziliqela. Zama ukusebenzisa umsebenzi "yenza" izibopho zakho, uze wenze-phinda ngo-ngesandla nge umqondiso "inkwenkwezi".
H | I | J | K | |
Range 1 | Range 2 | ngenxa | ifomula | |
12 | 2 | 6 | 9,378,270.72 | Iveliswe = (H12: H16; I12: I16) |
13 | 7 | 14.2 | 9,378,270.72 | Iveliswe = (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 |
Kwikholam ethi "Formula" kule theyibhile ibonisa ngokucacileyo ukuba iimali ekulindeleke ixabiso apha, ukuba ingasetyenziswa noluhlu. Kwakhona phezu kwetafile uyakwazi ukubona ukuba lo msebenzi "yenza 'ukuba phinda zonke ezi ezintlwini, kwaye bafumane iziphumo ngendlela efanayo ngokungathi kwi uphinda phinda enye ngesandla ixabiso ezi seli. Njengoko ubona, i-phinda ukuya ku-Excel - kuyinto snap.
Interesting neqiniso! Zama ixabiso omnye ngoku isuswe nayiphi iseli, inxalenye kuluhlu, zingabinanto iiseli uya kuba sodwa ngokupheleleyo. Uya kubona ukuba ngaxeshanye ukwenza umsebenzi ukwenza ubalo, yokukhupha nje iseli engenanto. Yaye nantsi ke ngenxa phindo "manual" waguqukela zero. Esi sesinye inzuzo eyodwa ukhetho eyakhelwe-ngaphakathi ukuba phinda "inkwenkwezi" - ayithethi ukwamkela iiseli ezingabhalwanga njengoko zero, kunjalo nje ukhupha kuzo ekubaleni.
Kukho amaxesha xa izibalo kwenziwa ukuba nobuninzi bomsebenzi sheets iincwadi, kwaye iphepha ngenxa igcinwe ifomula, equka imveliso ye amaxabiso ezinye sheets. Ukuba namnye kubo uya kuba sodwa, kukho uphinda-phindo elula le "nkwenkwezi" ukuba zonke iziphumo zakho zero.
Kule siyakwazi ukubona ukuba ulawulo izibalo ezintsonkothileyo kwi amaphepha amaninzi kubhetele ukusebenzisa umsebenzi "yenza" njengeyona nto iphambili.
itheyibhile phinda
Khangela ekugqibeleni, ukwenza itafile phindo e-Excel. Kulula.
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 |
Ngokwesithethe yetafile phindo eqhelekileyo iquka umhlathi enye iseti kwamanani emgceni - enye. Ukuze ukwazi ukuba bakope ifomula, kuyimfuneko ukusebenzisa amakhonkco exutyiweyo - ukulungisa yi umqondiso "dollar" ($) inombolo kwikholam ukusukela lines data ethe nkqo nethe tyaba ukuba data '= A2 * $ B $ 1 ".
Similar articles
Trending Now