Kodi kuchulukana mu "Eksele" maselo pakati pawo?

Masiku ano, mmodzi wa zida otchuka kwambiri kuwerengetsera zovuta ndi pulogalamu Microsoft kupambana. magwiridwe akuluakulu wosalira njira ya ntchito achikhalire amene poyamba amathera nthawi yambiri. Lero tiona mmene kuchulukana mu "Eksele" maselo pamodzi ambiri.

Chulutsa mu "Eksele"

Musanayambe muganize momwe kuchulukana mu "Eksele" manambala, tiyenera kulingalira magwiridwe yotakata pulogalamu, amene amalola kuti ntchito onse ndi ntchito bwino manambala ndi ntchito maselo muli mwa iwo okha ndi manambala ndi kachitidwe, determinants awo. Kuchulukana maselo chimodzi kapena zingapo kapena chiwerengero cha maselo zofunika pa chilinganizo bala pambuyo chizindikiro ofanana amasonyeza deta zinthu pepala kapena mtengo olembedwa.

Chulutsa ndi selo foni

Komanso, tiyenera kumvetsa mfundo, monga "Eksele" kuchulukitsa khungu kwa khungu ndi mavuto mukhoza kukumana mu ndondomekoyi. Pakuti kuchulukitsa mfundo maselo awiri mu mzere ayenera kulembetsa zotsatirazi dongosolo chilinganizo: "= A * B" ndipo "A" ndi "B" - limasonyeza kuti zinthu za pepala "kupambana", i.e. maselo ziwalo.

Pezani zotsatira, mungafunike kulenga bukuli, ndi ogwiritsa zambiri musazengereze, monga kutengera kufunika kwa chipindacho mwa kulowetsa mu lina. Komabe, njira imeneyi zidzachitika ndi kusintha limasonyeza zogwirizana akuloza factorization lapansi. Pofuna kupewa cholakwa choterocho, ayenera kukhala kaya selo mukufuna kutengera zotsatira, kulowa ulalo selo anakopera kapena "kukonza" adiresi ya zinthu zake mwa chizindikiro "$". chizindikiro dola zimabweretsa kutchulidwa kwa chizindikiro, ndipo tsatira - kutanthauza $ kugwirizana A4 nthawizonse amanena kuti ndime A, A $ 4 - mzere chachinayi, ndi $ A $ 4 - yekha A4 selo. Mu mawu ena, kukhazikitsa selo - chilengedwe cha Buku cheni izo.

Chulutsa mizati ndi mizere

Ntchito akukonzekera maadiresi aligorivimu khungu, inu mukhoza kupita mwachindunji mmene kuchulukana mu "Eksele" mzati ndi ndime kapena mzere kusambira. Kuti tisunge nthawi kulemba mfundo yaikulu, mungathe kugwiritsa ntchito chabe chuma chimasintha Buku selo pamene kusamukira latsopano adiresi Cholozera. Ndiko kuti, ngati m'pofunika kuchulukitsa phindu awiriawiri mu magawo awiri, ndi okwanira kulemba chulutsa chilinganizo mkazi woyamba wa maselo, ndipo akugwira chizindikiro "wakuda kuphatikiza", amene anaonekera mu ngodya m'munsi ufulu kutambasula chifukwa pansi pamodzi mfundo zonse ndime-multiplier.

Pofuna kukwaniritsa zotsatira zofanana kwa mizere ya, m'pofunika yekha kutulutsa chifukwa cha anatambasula pamodzi mizere ziwalo. Dziwani kuti pofuna kupewa kusuntha pa buku wotsatira wa zotsatira, m'pofunika kukonza chilinganizo mwachindunji ndime kapena mzere - ndiye athe kupewa zolakwa mawerengedwe a.

Chulutsa mzere kapena ndime kwa khungu

Mwakumvetsa mmene kuchulukana mu "Eksele" mzati ndi ndime kapena mzere kusambira, m'pofunika kukhala ntchito imodzi yapadela - chulutsa maselo mu mzere kapena yachiwiri. Ngati chulutsa aligorivimu ntchito kanthu mofanana pa nkhani ya chulutsa mizati ya, chifukwa kokha kuchulukitsa ndi mtengo wa mzere woyamba wa ndime iyi, kuyambira adiresi ya foni zimasiyana ndi mukachipinda mbadwa malo amodzi.

Popewa izi, m'pofunika kukonza mzere nambala kuchulukitsa ndi selo kapena wake kwathunthu - mu nkhani iyi, adzatha ntchito kufunika kwake kwa mizati angapo. Pankhani ya chulutsa ndi zina mzere selo loko kalata ndime zokwanira umene amakhala, kapena kuchita onse foni adiresi chizindikiro zonse.

Kodi kuchulukitsa chiwerengero onse mu mzere kapena ndime

Nthawi zina "Eksele" chofunika kuchita opareshoni ofanana okwana kuti, kokha kuchita ntchito chulutsa. Komabe, wapadera basi Ndondomeko iyi kulibe, kotero ambiri, osati kudziwa momwe "Eksele" kuchulukitsa chiwerengero cha ndime osakwatira kapena kusambira ndi mzake, kodi izo momveka kungosunga kanthu kwa mukachipinda. Ndipotu pulogalamu pali ntchito zimene zingatithandize kuthetsa vuto la mmene kuchulukana mu "Eksele" wina ndi mzake kangapo mofulumira.

Pofuna kuchulukitsa osiyanasiyana ena maselo ndi mzake, monga kusankha menyu "Ikani Limagwira" ntchito otchedwa "kupanga." Pamene mkangano wa ntchito ndi maselo ayenera kuchulukitsa ndi mzake, zingakhale ngati mizati, mizere, maselo, kapena magulu lonse. Tikumbukenso kuti pamaso pa foni kanthu mu uthunthu anakonzeratu zotsatira za chulutsa si wolingana ndi ziro - Pankhaniyi pulogalamu adzakhala kunyalanyaza chipindacho, i.e. null opotoka umodzi.

chidule

Muganize momwe kuchulukana mu "Eksele" akhoza akuyendera zikalata mwachilungamo zovuta, kuphatikizapo nkhani zachuma ndi amanenera. Kwambiri masamu ntchito angathe kuchitidwa mu Mofananamo, koma kwa ena ayenera kuganizira mfundo kukhazikitsa awo, komanso mtundu selo. Choncho, mwachitsanzo, ndi kugawa selo khungu, pakalibe makhalidwe mmodzi wa iwo, chifukwa ndi zolakwa magawano ndi ziro.