Inani eliphansi Excel

Uma ngisebenza uhlelo "Excel" ungase nazo isidingo ukuthatha ngemiphumela zesikhashana, ngaphezu jikelele evamile.

Isihloko ezocatshangelwa ukuthengiswa ithebula kwezimpahla ngenyanga, ngokuvamile njengoba umsebenzi ifanekisela imisebenzi. Kuyobukeka ezintathu amakholomu: igama umkhiqizo, usuku kanye nenani ngezimali. Ukusebenzisa "Excel" Imiphumela zesikhashana, kungenzeka ukubala nomholo nsuku zonke umkhiqizo. Ngaphezu kwalokho, ekupheleni, ungathatha inani yokuthengisa kwezimpahla. Manje sizobheka ngokuningiliziwe indlela imiphumela ephakathi nendawo Senziwe "Excel".

Imigomo izici ukusetshenziswa

Kumele kucaciswe ngokushesha ukuthi kuhlinzekelwe etafuleni ukusebenza kufanele uhambisane. izindleko Ubude ukuthobela amaphuzu amathathu:

• Ithebula cap kumele ibekwe Umugqa wokuqala ishidi;
• iseli endaweni kumele ibe nefomethi ngokwakhona;
• ithebula kufanele uchichime idatha.

Uma zonke lezi zidingo zifeziwe, khona-ke uzakubonisisa kalula thatha imiphumela wesikhashana. Manje, ake sibheke inqubo ngokwalo.

Ukudala subtotal. Ukusebenzisa ithuluzi ekhethekile

Indlela ukudala i yi zesikhashana kuleli "Excel"? Indlela yokuqala buyobonakaliswa usebenzisa amathuluzi esezingeni igama elifanayo ohlelweni. Masiqale.

Isinyathelo 1: Ithuluzi Opening

Okokuqala udinga ukuvula ithuluzi ngokwayo, "Inani eliphansi". Itholakala kwi yamathuluzi in the "idatha" (e-Amathuluzi iqembu "isakhiwo"). Ngaphambi ukuyivula uzodinga ukhetha iseli lapho kukhona omunye amagama izimpahla, kulesi sibonelo, khetha "Amazambane".

Isinyathelo 2: Ukubeka the ukubonisa

Ngemva ngokuchofoza ithuluzi sivula iwindi lapho wasibekela kwemigomo kokukhipha ulwazi kulolu hlelo. Kulokhu, kufanele uthole ukuthi inani imali ngosuku oluthile, ngakho uhlu olwehlayo "Ngezinye ushintsho ngamunye" ukukhetha "Usuku".

Njengoba silindele lesi samba uhlu olwehlayo "Operation" kufanele isethelwe ku "sum". Kubalulekile ukuqaphela ukuthi kulesi sigaba ungakwazi ukukhetha amanye eziguquguqukayo, kuye ngokuthi izidingo zakho. Phakathi iziphakamiso:

• okungenani;
• ubuningi;
• esiphezulu;
• umkhiqizo.

It uhlala ukucacisa lokho kuphela, lapho umphumela kuzovezwa. Ukuze wenze lokhu, in the "Engeza umphumela" udinga ukufaka uphawu isheke eduze igama ikholomu, lapho umphumela kuzovezwa. Njengoba thina ukubala inani, khetha "inani ruble ngezimali.".

Futhi kule windi, kukhona eziguquguqukayo ezimbalwa: "Buyisela imiphumela zamanje," "Ukuphela ikhasi phakathi kwamaqembu" futhi "Imiphumela ye-idatha". Into ebaluleke kakhulu kungenziwa kuphawulwe kuphela iphuzu lokuqala, kanti bonke abanye into ozikhethela wena.

Isinyathelo 3: Final

Phela amasethingi, udinga uchofoze inkinobho "OK" kuphela. Manje lolu hlelo ungabona ngemiphumela zesikhashana ngosuku. Kufanele kuqashelwe ukuthi usebenzisa uphawu "lokususa" i- ifasitelana ngakwesokunxele, ungakwazi inwebe noma igoqe iqembu. Ezansi ngeke akuvumele phansi ingqikithi.

Ukudala subtotal. Ukusebenzisa ifomula ekhethekile

Ngaphezu okungenhla indlela samanje, njengoba kungenzeka kwenze ngisho ukubala e "Excel" imiphumela ephakathi nendawo? Ifomula - ezosisiza.

Labo ngokuvamile ukusebenza ngohlelo, ukwazi ukuthi ukungena amafomula kulula ukusebenzisa ithuluzi ekhethekile "Umsebenzi Iseluleki". Kuyinto kuye futhi ijika.

Isinyathelo 1: Vula Wizard Umsebenzi

Ngaphambi sivuselelane imiphumela oyifunayo, kumelwe ukhethe i-cell lapho zibekwa.

Vele ukhethe noma iyiphi iseli ngaphandle idatha bangena kuyo. Okulandelayo udinga chofoza "Faka Umsebenzi" isithonjana ukuthi itholakala eduze umugqa input. Indawo ngqo ungabona esithombeni ngezansi.

Lokhu kuvula wizadi imisebenzi screen, okuyinto "Khetha" kuyadingeka ukuze ukhethe "INGQIKITHI ENCANE" bese uchofoza "OK". Ukwenza lula ukucinga, ungasebenzisa ihlelwa ngama-alfabethi ngokukhetha eyehlayo ibhokisi elithi "Isigaba" khetha "uhlu Okugcwele ngokulandelana kwezinhlamvu zamagama".

Isinyathelo 2: Faka agumenti umsebenzi

Ngokusho imiphumela zonke lezi zenzo kuzovula iwindi lapho ufuna ukusetha zonke agumenti kunesidingo. Cabanga konke ukuze. Esikhathini "Igumbi" kuzomele ucacise inombolo ohlwini, lapho:

Esimweni sethu kubalulekile ukubala inani, ngakho udinga ukufaka inombolo "9".

Ebhokisini yokufaka "Isixhumanisi 1" Kufanele kukhethwe ibanga lamaseli ngedatha ukuthi kuzosetshenzwa umsebenzi. Ukuze wenze lokhu, ungasebenzisa izindlela ezimbili: faka konke wena, noma ucacise usebenzisa isikhombisi. Sizosebenzisa ukhetho lwesibili, ngoba kulula. Ukuze wenze lokhu, chofoza inkinobho ngakwesokudla bese ukhetha indawo oyifunayo, futhi ekupheleni, cindezela inkinobho futhi.

Nalapha ajwayelekile kithi iwindi livela lapho ungacacisa isixhumanisi yesibili (kunezinhlobo ezine). Uma wenza lokhu, awudingi, bese ucindezela inkinobho "OK" futhi imiphumela kuyoba okukhipha ethebuleni.