Ungayikhipha Kanjani Inombolo Kuphakathi Kwe-Exale

Uhlelo lwe-Excel lusebenzisa ithuluzi elinjalo, njengefomula, livumela izenzo ezahlukahlukene ze-arithmetic phakathi kwedatha kumaseli. Lezenzo zifaka ukususa. Ake sihlaziye ngokuningiliziwe ukuthi yiziphi izindlela ezingakukhiqiza lokhu kubalwa ku-Efpelle.

Sebenzisa ukususa

Ukususa i-Excel kungasetshenziswa zombili ezinombolweni ezithile namakheli ama-cell lapho idatha itholakala khona. Lesi senzo senziwa ngenxa yamafomula akhethekile. Njengakwezinye izibalo ze-arithmetic kulolu hlelo, ngaphambi kwefomula yokususa, udinga ukusungula uphawu olulingana (=). Lapho-ke okuncishisiwe (ngesimo senombolo noma ikheli leseli), i-minus (-) isibonakaliso, okukhishwe kokuqala (ngesimo senombolo noma kwekheli), futhi kwezinye izimo okulandelayo okukhishwe.

Ake sihlaziye izibonelo ezithile zenziwa ngayo le nqubo ye-arithmetic.

Indlela 1: Susa izinombolo

Isibonelo esilula ukukhishwa kwezinombolo. Kulokhu, zonke izenzo zenziwa phakathi kwezinombolo ezithile njengase-Calculator Calculator, hhayi phakathi kwamaseli.

1. Khetha noma yisiphi iseli noma usethe isikhombisi entanjeni yefomula. Sibeka isibonakaliso esithi "alingana." Siphrinta umphumela we-arithmetic ngokususa, njengoba nje senza ephepheni. Isibonelo, bhala phansi ifomula elandelayo:

   = 895-45-69



2. Ukuze ukhiqize inqubo yokubala, cindezela inkinobho ethi Faka kwikhibhodi.

Ngemuva kwalezi zinyathelo zenziwa, umphumela uboniswa esitokisini esikhethiwe. Kuthu, le yinombolo 781. Uma uke wasebenzisa enye idatha yokubala, ngakho-ke, ngenxa yalokho, umphumela wakho uzohluka.

Indlela 2: Ukususa izinombolo kusuka kumaseli

Kepha, njengoba wazi, i-Excel iwukuthi, okokuqala, uhlelo lokusebenza ngamatafula. Ngakho-ke, ukusebenza namaseli kudlalwa kubaluleke kakhulu. Ikakhulu, zingasetshenziselwa ukususa.

1. Siqokomisa iseli lapho kuzokwenzeka khona indlela yokususa ifomula. Sibeka uphawu "=". Chofoza kuseli equkethe idatha. Njengoba ubona, ngemuva kwalesi senzo, ikheli laso lifakwa kwintambo yefomula futhi ingezwe ngemuva kwesibonakaliso "esilinganayo". Siphrinta inombolo oyidingayo ukuze ukhiphe.



2. Njengasesimweni esedlule, ukuthola imiphumela yokubalwa, cindezela inkinobho ethi Enter.

Indlela 3: iseli elilodwa lokuhlanza

Ungaqhuba imisebenzi yokususa futhi ngokuvamile ngaphandle kwezinombolo, ukukhohlisa amakheli eseli kuphela anedatha. Umgomo owenziwayo uyafana.

1. Khetha iseli ukukhombisa imiphumela yokubalwa bese ubeka uphawu "olulinganayo" kulo. Chofoza kuseli equkethe okuncishisiwe. Sibeka isibonakaliso "-". Chofoza kuseli equkethe okukhishwe. Uma kwenzeka ukusebenza kudinga ukwenziwa ngokukhishwa okuningi, bese kuthi futhi kubeka uphawu lwe- "Minus" futhi ufeze izenzo kulolo hlelo olufanayo.



2. Ngemuva kokuthi yonke imininingwane ifakiwe, ngokuphuma komphumela, chofoza inkinobho ethi Enter.

Isifundo: Sebenza ngamafomula ku-Excel

Indlela 4: Ukucutshungulwa kwe-Mass yangaphandle

Kaningi, lapho usebenza ngohlelo lwe-Excel, kwenzeka ukuthi kuyadingeka ukubala ukuncishiswa kwekholomu yonke yamaseli kwenye ikholomu yeseli. Vele, kungenzeka isenzo ngasinye ukubhala ifomula ehlukile ngesandla, kepha kuthatha isikhathi esiningi. Ngenhlanhla, ukusebenza kohlelo lokusebenza kuyakwazi ukushintshanisa kakhulu ukubala okunjalo, ngenxa yomsebenzi we-autofile.

Ngokwesibonelo, sibala inzuzo yebhizinisi ezindaweni ezahlukahlukene, azi imali engenayo kanye nezindleko zokukhiqiza. Ukuze uthole lokhu, kufanele kwembulwe imali.

1. Sabela iseli eliphakeme kakhulu ukubala inzuzo. Sibeka uphawu "=". Chofoza kwiseli equkethe usayizi wemali emugqeni ofanayo. Sibeka isibonakaliso "-". Sigqamisa iseli ngezindleko.



2. Ukuze ukhiphe inzuzo kulomugqa esikrinini, chofoza inkinobho ethi Enter Enter.



3. Manje sidinga ukukopisha le formula ebangeni eliphansi ukwenza izibalo ezifiselekayo lapho. Ukuze senze lokhu, sibeka isikhombisi onqenqemeni olungakwesokudla lweseli eliqukethe ifomula. Umaki wokugcwalisa uyavela. Sichofoza inkinobho yegundane kwesobunxele nakwisimo sokuhlanganisa ngokudonsa isikhombisi kuze kube sekupheleni kwetafula.



4. Njengoba ubona, ngemuva kwalezi zenzo, ifomula lalikopishelwa lonke ibanga elingezansi. Ngasikhathi sinye, ngenxa yale mpahla, njengoba ukulinganiselwa kwamakheli, leli khophi lenzeka ngokuhanjiswa, okwenza ukuthi kube nokwenzeka ukukhiqiza ukubalwa okulungile kokukhipha kanye namaseli aseduze.

Isifundo: Ungayenza kanjani i-autocomplete ku-Excel

Indlela 5: Ukukhishwa okuningi kwedatha yeseli elilodwa kusuka ebangeni

Kepha kwesinye isikhathi udinga ukwenza okuphambene nalokho, okungukuthi, ukuthi ikheli aliguquki lapho lilongisa, kepha lihlala lihlala njalo, libhekise esitokisini esithile. Ungayenza kanjani?

1. Siba esitokisini sokuqala ukukhipha umphumela wezibalo. Sibeka isibonakaliso esithi "alingana." Chofoza esitokisini lapho okunciphile khona. Faka uphawu lwe- "minus". Sifaka ngokuchofoza esitokisini esinqunyelwe, ikheli lawo okungafanele liguqulwe.



2. Futhi manje siphendukela kumehluko obaluleke kakhulu wale ndlela kusuka kwangaphambilini. Kungokulandelayo okuvumela ukuthi uguqule isixhumanisi esivela ku-ABUTE. Sibeka uphawu lwedola phambi kwezixhumanisi eziqonde mpo nasezivundlile zesitokisi salo okufanele siguquke.



3. Chofoza kukhibhodi kukhiye wokungena, okuvumela ukuthi ukhiphe ukubalwa komugqa esikrinini.



4. Ukuze wenze ukubala neminye imigqa, ngendlela efanayo nesibonelo esedlule, sibiza umaki wokugcwalisa bese sikuhudula phansi.



5. Njengoba sibona, inqubo yokususa ukukhishwa yakhiqizwa njengoba sidinga. Lokho wukuthi, lapho ukwehlisa ikheli ledatha encishisiwe kuguqukile, kepha okukhishwe kwahlala kungashintshiwe.

Isibonelo esingenhla siyicala elikhethekile kuphela. Ngendlela efanayo, kungenziwa ngokuphambene nalokho, ukuze izinsalela ezincishisiwe zihlala zihlale zinjalo, futhi okukhishwe kwakhiwe futhi kwaguqulwa.

Isifundo: Izixhumanisi eziphelele nezihlobo ze-Excel

Njengoba ubona, ekuthuthukisweni kwenqubo yokususa kuhlelo lwe-Excel Ayikho into eyinkimbinkimbi. Kwenziwa ngokuya ngemithetho efanayo neyezinye izibalo ze-arithmetic kulolu hlelo lokusebenza. Ukwazi amanye ama-nuances athokozisayo kuzovumela umsebenzisi ukuthi acubungule kahle isenzo sezibalo ze-Array yedatha enkulu, ezosindisa kakhulu isikhathi sayo.