Kodi mungatani kuti muzindikire gulu kapena gulu la maselo
Mndandanda ndi gulu kapena mzere wa maselo mu tsamba limene lasankhidwa kapena likufotokozedwa. Pamene maselo asankhidwa amazunguliridwa ndi ndondomeko kapena malire monga momwe amachitira pa chithunzi kumanzere.
Mndandanda ukhoza kukhalanso gulu kapena zolemba za maselo zomwe zingakhale, mwachitsanzo:
- inalowa ngati kutsutsana kwa ntchito.
- amagwiritsa ntchito kulenga grafu.
- amagwiritsa ntchito kupanga zolemba zizindikiro kuzinthu zenizeni m'buku.
Mwachindunji, ndondomekoyi kapena malire amzungulira selo imodzi yokha mu tsamba lothandizira pa nthawi, yomwe imadziwika ngati selo yogwira ntchito . Kusintha kwa tsamba, monga kukonza deta kapena kupanga, posintha, kuthandizani selo yogwira ntchito.
Pamene pali selo limodzi losankhidwa, kusintha pa tsamba - ndi zina monga kulowa kwa deta ndi kusintha - zimakhudza maselo onse osankhidwa.
Mapangidwe odalirika ndi Osagwirizana
Maselo ambiri ozungulira ndi gulu la maselo ofunika omwe ali pafupi ndi wina ndi mzake, monga ma C1 mpaka C5 omwe akuwonetsedwa pa chithunzi pamwambapa.
Mtundu wosagwirizana ndi wopangidwa ndi maselo awiri kapena awiri osiyana. Zolembazi zingathe kupatulidwa ndi mizere kapena mazenera monga momwe ziwonetsedwera mndandanda wa A1 mpaka A5 ndi C1 mpaka C5.
Mizere yonse yosagwirizana ndi yosagwirizanitsa imatha kuphatikiza mazana kapena masauzande a maselo ndikuyang'ana ma sheetsi ndi mabuku ogwira ntchito.
Kutchula Range
Mapangidwe ndi ofunika kwambiri ku Excel ndi Google Spreadsheets omwe maina angaperekedwe ku mapafupi kuti apange ntchito mosavuta ndikugwiritsanso ntchito powafotokozera muzolemba monga ma chart ndi ma formula.
Kusankha Range mu Tsamba Labwino
Pali njira zingapo zomwe mungasankhire mndandanda mu tsamba. Izi zikuphatikizapo kugwiritsa ntchito:
- mbewa.
- makina.
- Bokosi la Dzina mu Excel.
- Kuphatikiza zitatu.
Mndandanda wa maselo oyandikana nawo angapangidwe pokoka ndi mbewa kapena pogwiritsa ntchito Shift ndi makina anayi a Arrow pa makiyi.
Mapangidwe a maselo osakhala pafupi akhoza kulengedwa pogwiritsa ntchito mbewa ndi kibokosi kapena kamphindi.
Kusankha Njira Yogwiritsira Ntchito mu Fomu kapena Tchati
Pogwiritsa ntchito ma selo angapo monga magulu a ntchito kapena popanga tchati, powonjezera kuyimira pamanja pamtunduwu, mtunduwo ukhoza kusankhidwa ndikuwonetsa.
Mapangidwe amadziwika ndi mafotokozedwe a selo kapena maadiresi a maselo kumtunda wakumanzere ndi kumunsi kumanja kumeneku. Mavesi awiriwa akulekanitsidwa ndi colon (:) yomwe imamuuza Excel kuti aphatikize maselo onse pakati pa mapepala amenewa.
Mtsinje vs. Array
Nthawi zina mawu amodzi ndi omwe akuoneka kuti amagwiritsidwa ntchito mosiyana kwa Excel ndi Google Spreadsheets, popeza mawu onsewa akukhudzana ndi kugwiritsa ntchito maselo angapo mu bukhu la ntchito kapena fayilo.
Kuti zitsimikizire, kusiyana kumeneku kumaphatikizapo kuti mndandanda umatanthawuza kusankhidwa kapena kudziwika kwa maselo ambiri monga A1: A5, pamene gulu likanatanthawuzira ku zikhalidwe zomwe zili mu maselo monga {1; 2; 5; 4 ; 3}.
Zina mwa ntchito - monga SUMPRODUCT ndi INDEX zimatenga mfundo ngati zifukwa, pamene ena - monga SUMIF ndi COUNTIF amalandira mndandanda wa zifukwa zokha.
Izi sizikutanthauza kuti mafotokozedwe angapo a selo sangathe kulowa ngati zotsutsana za SUMPRODUCT ndi INDEX pamene ntchitoyi ingathe kuchotsa malingaliro ake kuchokera pamtunduwu ndikusandulika mwapadera.
Mwachitsanzo, mawonekedwe
= SUMPRODUCT (A1: A5, C1: C5)
= SUMPRODUCT ({1; 2; 5; 4; 3}, {1; 4; 8; 2; 4})
Onse amabwezera zotsatira za 69 monga zikuwonetsedwa m'maselo E1 ndi E2 mu chithunzi.
Kumbali inayi, SUMIF ndi COUNTIF samavomereza zolemba ngati zifukwa. Tsono, pamene chiganizocho chikupezeka
= COUNTIF (A1: A5, "<4") amayankha yankho la 3 (selo E3 mu chithunzi);
ndondomekoyi
= COUNTIF ({1; 2; 5; 4; 3}, "<4")
sichivomerezedwa ndi Excel chifukwa imagwiritsa ntchito mndandanda wa mkangano. Zotsatira zake, pulogalamuyi ikuwonetsa zolemba za bokosi zomwe zingakhale zovuta komanso zosintha.