Ukubalwa kokuphambuka okujwayelekile kuMicrosoft Excel

Elinye lamathuluzi aphambili wokuhlaziywa kwezibalo ukubalwa kokuphambuka okujwayelekile. Le nkomba ikuvumela ukuthi ulinganise ukuphambuka okujwayelekile kwesampula noma sonke isibalo. Masifunde ukusebenzisa ifomula yokuphambuka ejwayelekile ye-Excel.

Ukunqunywa kokuphambuka okujwayelekile

Ngokushesha sizonquma ukuthi yikuphi ukuphambuka okujwayelekile nokuthi ifomula yayo ibukeka kanjani. Leli nani impande yesikwele ye-arithmetic maana wesikwele umehluko wawo wonke amanani ochungechunge nezincazelo zawo. Kunegama elifanayo lalesi sikhombisi - ukuphambuka okujwayelekile. Womabili la magama alingana ngokuphelele.

Kepha, ngokwemvelo, e-Excel, umsebenzisi akudingeki abale lokhu, ngoba uhlelo lumenzela konke. Ake sithole ukuthi ukubala kanjani ukuphambuka okujwayelekile ku-Excel.

Ukubalwa ku-Excel

Ungbala inani elicacisiwe ku-Excel usebenzisa imisebenzi ekhethekile emibili. STANDOTLON.V (ngesampula) no STANDOTLON.G (ngenani labantu). Umgomo wesenzo sabo uyefana, kepha ungabiza ngezindlela ezintathu, esizokuxoxa ngezansi.

Indlela yoku-1: Umsebenzi Wizard

1. Khetha iseli eshidini lapho kuzoboniswa khona umphumela ophelile. Chofoza inkinobho "Faka umsebenzi"etholakala kwesokunxele komugqa wokusebenza.



2. Uhlu oluvulayo, funa ukungena STANDOTLON.V noma STANDOTLON.G. Kukhona umsebenzi ohlwini STD, kepha ishiyelwe ezinhlotsheni ezedlule ze-Excel ngezinjongo zokuhambisana. Ngemuva kokuthi irekhodi likhethiwe, chofoza inkinobho "Kulungile".



3. Iwindi lokuphikisana ngomsebenzi liyavula. Ensimini ngayinye, faka inani labantu. Uma izinombolo zikumaseli eshidi, ungacacisa izixhumanisi zala maseli noma umane uchofoze kuwo. Amakheli azoboniswa ngokushesha emikhakheni ehambisanayo. Ngemuva kokuthi zonke izinombolo zabantu zifakiwe, chofoza inkinobho "Kulungile".



4. Umphumela wesibalo uzovezwa esitokisini esiqokonyiswe ekuqaleni kwenqubo yokuthola ukuphambuka okujwayelekile.

Indlela yesi-2: Ithebhu lamafomula

Ung futhi ubale inani lokuphambuka elijwayelekile ngethebhu Amafomula.

1. Khetha iseli ukukhombisa umphumela bese uya kuthebhu Amafomula.



2. Ebhokisini lamathuluzi Umtapo wesici chofoza inkinobho "Eminye imisebenzi". Ukusuka ohlwini oluvelayo, khetha "Izibalo". Kumenyu elandelayo, sikhetha phakathi kwamanani STANDOTLON.V noma STANDOTLON.G ngokuya ngokuthi isampula noma inani elijwayelekile labantu lihlanganyela yini ekubaleni.



3. Ngemuva kwalokho, iwindi lokuphikisana liyaqala. Zonke ezinye izinto ezenziwa kumele zenziwe ngendlela efanayo nakwindlela yokuqala.

Indlela 3: ngesandla faka ifomula

Kukhona futhi indlela ongadingi ukuthi ubize ngayo iwindi lokuphikisana nhlobo. Ukuze wenze lokhu, faka ifomula ngesandla.

1. Khetha iseli ukubonisa umphumela bese unquma kuwo noma kubha formula isisho ngenqubo elandelayo:

   = STANDOTLON.G (inombolo1 (cell_address1); inombolo2 (cell_address2); ...)
   noma
   = STDB.V (inombolo1 (cell_address1); inombolo2 (cell_address2); ...).

   Sekukonke, kuze kube ngama-255 ukuphikisana kungabhalwa uma kunesidingo.



2. Ngemuva kokuthi ukuqoshwa kwenziwe, chofoza inkinobho Ngena kwikhibhodi.

Isifundo: Ukusebenza namafomula ku-Excel

Njengoba ubona, indlela yokubala ukuphambuka okujwayelekile ku-Excel ilula kakhulu. Umsebenzisi udinga ukufaka izinombolo kuphela ukusuka kubantu noma isixhumanisi kumaseli aqukethe. Zonke izibalo zenziwa uhlelo uqobo. Kunzima kakhulu ukuthola ukuthi iyini inkomba ebaliwe nokuthi imiphumela yokubala ingasetjenziswa kanjani. Kepha ukuqonda lokhu sekuhlobana kakhulu emkhakheni wezibalo kunokuqeqeshwa ekusebenzeni nesoftware.