Ungabalwa njani ukulandelwa kotshintsho kwi-Excel

Enye yezalathiri zezinto eziphambili zokulandelelana kwamanani kukungasebenzi. Ukufumana ukubala kakhulu. Izixhobo zeMicrosoft Excel zikuvumela ukuba uzityhafise umsebenzisi.

Ukubalwa kwendlela yokusebenza

Esi salathisi singumlinganiso wokuphambuka komgangatho kwi-arithmetic. Iziphumo ezifunyenweyo zibonakaliswa njengepesenti.

I-Excel ayikho imisebenzi eyahlukileyo yokubala esi salathisi, kodwa kukho ifomumu yokubala ukutyelelwa komgangatho kunye nothotho oluqhelekileyo lweenombolo, ezizezi ukuba zisetyenziselwa ukufumana ulungelelwaniso lwawo.

Inyathelo 1: Ukubalwa kokuphambuka komgangatho

Ukuphambuka komgangatho, okanye, njengoko kubizwa ngokwahlukileyo, ukuphambuka komgangatho yingcambu yesikwere kwisasazo. Ukubala ukuphambuka komgangatho, umsebenzi wokuzima usetyenzisiwe. Ukuqala ngenguqulelo ye-Excel ka-2010, yahlulekile, kuxhomekeka ekubeni i-set Jikelele ibalwa okanye ngesampulu, iindlela ezimbini ze-imetroone.G.

I-syntax yale misebenzi ibonakala ngokuchanekileyo:

= I-imetcclone (inombolo1; inombolo2; ...)

= I-ITMOZOL.G (inombolo1; inombolo2; ...)

= I-ITMOOTCNN.V (inombolo1; inombolo2; ...)

1. Ukwenzela ukubala ukuphambuka komgangatho, khetha nasiphi na iseli yasimahla kwiphepha, elilungele wena ukuze kubonise iziphumo zokubala. Cofa kwiqhosha "Cola umsebenzi". Inembonakalo ye-pictogram kwaye ibekwe ngasekhohlo kwe-fortoula.



2. Ukusebenza kwe-Wizard yemisebenzi kuya kwenziwa, nto leyo eqalwayo njengefestile eyahlukileyo ngoluhlu lweempikiswano. Yiya kudidi "lweenkcukacha-manani" okanye "uluhlu olupheleleyo lwe-alfabhethi". Sikhetha igama "I-IyootClonal.g" okanye "I-STOOTCLONA.", ngokuxhomekeke ekubeni indibaniselwano ngokubanzi okanye isampulu kufuneka ibalwe. Cofa kwiqhosha "Kulungile".



3. Ifestile ivula. Ingakwazi ukuya kwi-1 ukuya kwi-255 amasimi, apho kukho amanani athile kunye neereferensi kwiiseli okanye kwiiprayimari. Sibeka isikhombisi kwintsimi "yeNombolo1". Imouse yabela uluhlu lwamaxabiso ukuze kwenziwe kwiphepha. Ukuba kukho iindawo ezininzi ezinjalo kwaye azikufuphi nakwenye, ukulungelelaniswa koku kulandelayo kubonisa intsimi "yeNombolo2", njl njl. Xa yonke idatha eyimfuneko ingenisiwe, cofa iqhosha u "Kulungile"



4. Kwiseli ekhethiweyo, ukubalwa ngokupheleleyo kohlobo olukhethiweyo lokuphambuka komgangatho kuyaboniswa.

Isifundo: Ifomula ye-quadratic ye-quadral kwi-Excel

Inyathelo 2: Ukubalwa kwe-arithmetic ephakathi

Umndilili we-arithmetic ngumyinge wenani lonke lamaxabiso ochungechunge lwamanani ukuya kwinani labo. Ukubala esi salathisi, kukho umsebenzi owahlukileyo - i-CPNP. Bala ixabiso layo kumzekelo othile.

1. Khetha iseli kwiphepha ukuze uphume iziphumo. Sicofa iqhosha elithi "faka umsebenzi" sele sisisiqhelekile kuthi.



2. Kudidi lweenkcukacha-manani ze-wizard yemisebenzi, sifuna igama "sncvov". Emva kokuba ikhethiwe, cinezela iqhosha u "Kulungile".



3. Iwindow yempikiswano isunguliwe. Iimpikiswano zifana ngokupheleleyo kwinto yokuba abaqhubi beqela lendlela yokuzima. Oko kukuthi, kumgangatho wabo unokusebenza njengamaxabiso ahlukeneyo / amakhonkco. Faka isikhombisi kwintsimi "yeNombolo1". Kananjalo, njengakwimeko yangaphambili, sinika iseti yeeseli ephepheni. Emva kokulungelelaniswa kwabo badweliswe kwifestile yewindows mpikiswano, cofa kwiqhosha "Kulungile".



4. Isiphumo sokubala i-avareji ye-arithmetic ithathwe kwiseli eyayibalaselisiwe ngaphambi kokuvula i-wizard yeSebe.

Isifundo: Indlela yokubala ixabiso eliphakathi kwi-Excel

Inyathelo 3: Ukufumana uLungelelwaniso lwangokuhluka

Ngoku sinayo yonke idatha eyimfuneko ukwenzela ukubala ngokuthe ngqo ukubala umahluko.

1. Khetha iseli apho iziphumo ziya kubonakala khona. Okokuqala, kuyimfuneko ukuqwalasela ukuba ukulungelelaniswa kotshintsho yipesenti. Kule meko, ifomathi yeseli kufuneka itshintshwe ibe yinto efanelekileyo. Oku kungenziwa emva kokukhethwa kwayo, ngelixa "kwikhaya" lethebhu. Cofa kwicandelo lefomathi kwi-ribbon kwi "Inombolo" yesixhobo ". Ukusuka kuluhlu lwezinto ezinokukhethwa, khetha "ipesenti". Emva kwezi zenzo, ifomati kwinto iya kufaneleka.



2. Ukubuyela kwiseli ukubonisa isiphumo. Yenza isebenze ngokucofa kabini kweqhosha lasekhohlo iqhosha. Sibeka kuwo umqondiso "= =. Khetha into apho iziphumo zesiphumo zesiphumo sokubala ukuphambuka komgangatho. Cofa kwiqhosha "elahliweyo" (/) kwikhibhodi. Okulandelayo, sibela iseli apho i-arithmetic ye-arithmetic ithe yetha uluhlu lweendlela zamanani. Ukwenzela ukuba ubalo kunye nemveliso, cofa kwiqhosha lokungena kwikhibhodi.



3. Njengoko ubona, iziphumo zokubala ziyaboniswa.

Ngenxa yoko, sibale ulungelelwaniso lotshintsho, ebhekisa kwiiseli apho ukuphambuka komgangatho kunye nezixhobo ze-arithmetic sele zibaliwe. Kodwa ungaqhubeka kwaye ngokwahlukileyo, ngaphandle kokubala ezi nqobo.

1. Khetha iseli ngaphambili efomathiweyo phantsi kwefomathi yepesenti apho iziphumo ziya kuthathwa khona. Sikhuthaza ifomula yohlobo kuyo:

   = I-ITOOTCNNAL.V (Uluhlu_Name) / SR uya (Uluhlu_name)

   Endaweni yegama "Uluhlu" Uluhlu "Faka ulungelelwaniso lokwenyani lommandla, apho kubekwe uluhlu lweengcelele zamanani. Oku kungenziwa ngokwabiwa ngokulula kolu luhlu. Endaweni yomqhubi we-matrootlonional. In, ukuba umsebenzisi uyayiqwalasela imfuneko, umsebenzi wokuma oqhelekileyo unokusetyenziswa.



2. Emva koko, ukubala ixabiso kwaye ubonise umphumo kwiscreen sokubeka esweni, cofa kwiqhosha le-ENTER.

Kukho umahluko onemiqathango. Kukholelwa ukuba ukuba inqaku le-Coarage yokuvumela umahluko lingaphantsi kwama-33%, emva koko iseti yamanani ithandabuza. Kwimeko ejongene netyala, kulisiko ukuba kubonakale njengokuthetha.

Njengoko ubona, inkqubo ye-Excel ikuvumela ukuba ubenzele ukubalwa kwezibalo zenkcukacha-manani ezintsonkothileyo njengoko kukhangelo lwe-countral of. Ngelishwa, iSihlomelo ayikabikho umsebenzi onokubala esi salathisi kwisenzo esinye, kodwa ngoncedo lwabaqhubi be-clone, lo msebenzi lwenziwe lula kakhulu. Ngenxa yoko, e-Excel, kwanomntu ongenamanqanaba aphezulu olwazi olunxulunyaniswa neepateni zeenkcukacha-manani.