Sebenza ngamafomula ku-Excel

Enye yezinto eziphambili ze-Microsoft Excel yikhono lokusebenza ngamafomula. Lokhu kwenza lula kakhulu futhi kusheshise inqubo yokubala imiphumela evamile nokubonisa idatha edingekayo. Ake sibheke ukuthi ungawakha kanjani amafomula nokuthi ungasebenza kanjani nabo ohlelweni.

Ukwakha amafomula alula kakhulu ku-Excel

Amafomula alula kakhulu ku-Pedele akhombisa isenzo se-arithmetic phakathi kwedatha etholakala kumaseli. Ukwakha ifomula elifanayo, okokuqala kwako konke sibhala uphawu lokulingana kulelo seli, lapho kuhloselwe ukuhoxisa umphumela ophumayo kusuka esenzweni se-arithmetic. Noma ungaqokomisa iseli, kepha faka isibonakaliso sokulingana entanjeni yefomula. Lokhu kukhwabanisa kulingana futhi kuphindeka ngokuzenzakalelayo.

Bese ukhetha iseli ethile egcwele idatha, bese ubeka uphawu lwezibalo olufunayo ("+ '", "-", "**", "/", njll.). Izimpawu ezinjalo zibizwa ngokuthi amafomula. Manje khetha iseli elilandelayo bese uphinda izenzo ngokuhlukile kuze kube yilapho wonke amaseli adingekayo ahilelekile. Ngemuva kokuthi le nkulumo ifakwe ngokuphelele, cindezela u-ENTER kwikhibhodi ukubonisa izibalo.

Izibalo ze-Excel

Ake sithi sinethebula lapho inani lezimpahla likhonjisiwe, nentengo yamayunithi ayo. Sidinga ukuthola inani eliphelele lenani legama lomkhiqizo ngamunye. Lokhu kungenziwa ngokuphindaphinda inombolo ngentengo yezimpahla.

1. Sikhetha iseli lapho inani lizokhonjiswa khona, bese libeka lapho =. Okulandelayo, siqokomisa iseli ngenombolo yezimpahla - isixhumanisi esizovele sivele ngokushesha ngemuva kophawu lokulingana. Ngemuva kwezixhumanisi zeseli udinga ukufaka uphawu lwe-arithmetic. Kuthu, kuzoba yisibonakaliso sokuphindaphindeka - *. Manje chofoza kuseli, lapho idatha ibekwe khona nezindleko zeyunithi yezimpahla. Ifomula ye-arithmetic isilungile.



2. Ukubuka umphumela wayo, cindezela u-ENTER.



3. Ukuze ungangeni kule formula ngaso sonke isikhathi ukubala inani eliphelele legama lomkhiqizo ngamunye, hover the cursor ekhoneni elingezansi kwesokudla seseli ngomphumela bese udiliza yonke indawo yemigqa lapho igama le izimpahla zitholakala.



4. Ifomula ibikopishwe futhi nezindleko eziphelele zibalwa ngokuzenzakalelayo ngohlobo ngalunye lomkhiqizo, ngokuya ngedatha ngenani layo nentengo.

Ngokufanayo, ungabalwa amafomula ngezenzo eziningana nangama-arithmetic ahlukile. Eqinisweni, amafomula we-Excel ahlanganiswe ngokuya ngemigomo efanayo lapho izibonelo ezivamile ze-arithmetic zenziwa kuma-mathematics. Isebenzisa cishe i-syntax efanayo.

Qedela umsebenzi, uhlukanise inani lezimpahla etafuleni ube ngamaqembu amabili. Manje, ukuthola izindleko eziphelele, kufanele uqale ugoqe inani lawo womabili amaqembu omkhiqizo futhi umphumela uyaphindwa ngentengo. Ku-arithmetic, ukubalwa okunjalo kwenziwa kusetshenziswa amabakaki, ngaphandle kwalokho isenzo sokuqala sizokwenziwa ukuphindaphindwa, okuzoholela ekubaleni okungalungile. Sizisebenzisa futhi sixazulule umsebenzi ku-Excel.

1. Ngakho-ke, sibhala = esitokisini sokuqala sekholomu "Inani". Ngemuva kwalokho sivula ubakaki, chofoza kusethi yokuqala ekholomu "yephathi eli-1", faka +, chofoza kuseli lokuqala kukholamu "ye-Batch" yokuqala. Okulandelayo, sivala ubakaki bese sisetha *. Chofoza kuseli lokuqala kukholamu "yentengo" - ngakho-ke sithole ifomula.



2. Chofoza u-ENTER ukuthola umphumela.



3. Njengoba nje okokugcina, kusetshenziswa indlela yokuhudula kopisha le formula neminye imigqa yetafula.



4. Kumele kuqashelwe ukuthi hhayi wonke la mafomethi kufanele abekwe kumaseli angomakhelwane noma ngemingcele yetafula elilodwa. Bangaba kwelinye ithebula noma ngakolunye uhlangothi lwedokhumenti. Uhlelo lusabala kahle.

Usebenzisa i-Excel njenge-Calculator

Yize umsebenzi oyinhloko wohlelo ukubala ematafuleni, lungasetshenziswa njenge-Calculator elula. Sifaka uphawu olulinganayo bese sifaka izinombolo ezifiselekayo kanye nabasebenza kunoma yisiphi iseli seshidi noma intambo yefomula.

Ukuthola umphumela, cindezela u-ENTER.

Opharetha abayisisekelo we-Excel

Ama-opharetha wokubala aphambili asetshenziswa kuMicrosoft Excel afaka okulandelayo:

• = ("Uphawu lokulingana") - lulingana;
• + ("Plus") - Isengezo;
• - ("Minus") - Ukususa;
• * ("Inkanyezi") - ukuphindaphindwa;
• / ("Isici esithambekele") - Ukwahlukanisa;
• ^ ("Rarseflex") - ukuzivocavoca.

I-Microsoft Excel ihlinzeka ngethuluzi eliphelele lomsebenzisi ukwenza isenzo esihlukahlukene se-arithmetic. Bangenziwa bobabili lapho kulungiswa amatafula futhi ngokwehlukana ukubala umphumela wokusebenza okuthile kwe-arithmetic.