5 zokubulala iindlela zokusebenzisa iMicrosoft Excel
I-Excel yiprogram yespredishithi yekhompyutha.
I-spreadsheet yecomputer yiprogram yesofthiwe yekhompyutha esetyenziselwa ukugcina, ukuhlela nokucwangcisa idatha .
Yiyiphi i-Excel eSebenzisiweyo
Iiprogram ze-spreadsheet zeplastiki zazisusela ngokusekelwe kwiipredishithi zamaphetshana ezisetyenziselwa ukuphendula. Ngaloo ndlela, isiseko esisiseko seepredishithi zekhompyutha sifana nephepha. Idatha edibeneyo igcinwa kwiibhile - eziqokelelwe amabhokisi amancinci okanye iiseli ezihlelwe kwimigca kunye neikholomu.
Iinguqulelo zangoku ze-Excel kunye nezinye iiprogram ze-spreadsheet zinokugcina iimpapasho ezininzi zepredishithi kwifayile yekhompyutha enye.
Ifayile yekhompyutheni egcinwe idla ngokubhekiselwe kuyo njengencwadi yencwadi kunye nephepha ngalinye kwincwadi yokusebenzela i-worksheet eyahlukeneyo.
Excel Alternatives
Ezinye iiprogram zepredishithi ezikhoyo ezisetyenziswayo ziquka:
I-Google AmaSpredishithi (okanye i-Google Spreadsheets) -program ye-spreadsheet ye-e-free-based;
I-Excel Online - i-free-down-down-down, i-web-basis-based version ye-Excel;
Vula i-Office Calc - iprogram yepredishithi yokukhululeka, yokukhuphela.
Iifayili zeSpredishithi kunye neeReferensi zeeSeli
Xa ukhangela isikrini se-Excel-okanye nayiphina isikrini se-spreadsheet - ubona itafile emacatsheni okanye igridi yemigqa kunye neikholomu , njengoko kuboniswe kumfanekiso ongentla.
Kwiinguqulelo ezintsha ze-Excel, iphepha ngalinye lephepha liqulethe iigrawu ezigidi kunye namakholomu angaphezulu kwama-16,000, oku kufuna ukuba isicwangciso sokudibanisa ukuze sigcine indawo apho idatha ikhona khona.
Imiqolo engqambileyo ichongwa ngamanani (1, 2, 3) kunye neentsika ezilandeleleneyo ngeencwadi zealfabhethi (A, B, C). Kwiikholam ezingaphezu kwe-26, iikholomu zichongwa ngamagama amabini okanye ngaphezulu njengeAA, AB, AC okanye AAA, AAB, njl.
Ikhonkco le-intersection phakathi kwekholomu kunye nomqolo, njengoko kuchaziwe, ibhokisi elincinci lexandekileyo elibizwa ngokuba yiseli.
Isisele yunithi eyisiseko yokugcina idatha kwiphepha lokusebenzela, kwaye kuba iphepha ngalinye lomsebenzi liqukethe izigidi zala maseli, nganye iyachongwa ngokubhekiselele kweseli.
Isalathiso seeselumdibaniso yombhalo wekholomu kunye nenombolo yomgca efana ne-A3, B6, neAA345. Kule nkcazelo yeeseli, ileta yekholomu ihlala ibhalwe kuqala.
Iinkcukacha zeeDatha, iiFomula kunye neMisebenzi
Iindidi zeedatha esilunayo zingabamba:
- Amanani;
- Umbhalo;
- Imihla kunye namaxesha;
- Ixabiso leBoolean ;
- Iifomula .
Iifomula zisetyenziselwa ukubala - ngokuqhelekileyo zibandakanya idatha equlethwe kwezinye iiseli. Ezi zisele, nokuba kunjalo, zinokufumaneka kwii-worksheets ezahlukeneyo okanye kwiincwadi ezahlukeneyo zokusebenzela.
Ukudala ifomula kuqala ngokufaka uphawu olulinganayo kwiseli apho ufuna impendulo iboniswe khona. Iifomula zinokuquka iinkcukacha zeseli kwindawo yendawo kunye neminye imisebenzi okanye ispredishithi enye.
Imisebenzi kwi-Excel nakwezinye iipredishithi ze-elektroniki zakhiwe kwiifomula eziye zenzelwe ukwenza kube lula ukwenza uluhlu olubanzi lwezibalo - ezivela kwimisebenzi efana nokufaka umhla okanye ixesha eliyinkimbinkimbi ezinjengeenkcukacha zokufumana ulwazi oluthe ngqo kwiietafile ezinkulu zeedatha .
I-Excel ne-Data Data
Iipredishithi zisoloko zisetyenziselwa ukugcina idatha yezemali. Iifomula nemisebenzi esetyenzisiweyo kule fom yedatha ziquka:
- Ukwenziwa kwemisebenzi eyisiseko yeemathematika ezifana neenkomfa zeenkcukacha okanye imiqolo yamanani .
- Ukufumana ixabiso njengenzuzo okanye ukulahleka.
- Ukubala izicwangciso zokubuyiselwa kwemali mboleko okanye iimali zokuthenga.
- Ukufumana umyinge, ubuninzi, ubuncinci kunye namanye amanani e-statistical kwinqanaba elithile leenkcukacha.
- Ukuqhuba ntoni-Ukuba uhlalutyo lwedatha - apho iinguqu ziguqulelwa enye ngethuba ukuze ubone indlela utshintsho oluchaphazela ngayo enye idatha - njengeendleko kunye nenzuzo.
Ezinye zeeSetyenziswa
Eminye imisebenzi eqhelekileyo ukuba i-Excel ingasetyenziselwa ukuquka:
- Idatha yegrafing okanye inkcazo yokuncedisa abasebenzisi ekuchongeni imizila yedatha.
- Ukufomatha idatha ukwenza idatha ebalulekileyo ukuba ifumane kwaye iqonde.
- Idatha yokuprinta kunye neetshathi zokusetyenziswa kwiingxelo.
- Ukuhlela nokuhlunga idatha ukuze ufumane ulwazi oluthe ngqo.
- Ukudibanisa idatha yephepha lomsebenzi kunye neetshathi zokusetyenziswa kwezinye iinkqubo ezifana ne-Microsoft PowerPoint neLizwi.
- Ukungenisa idatha kwiinkcukacha zeenkcukacha zokuhlalutya.
Iipredishithi zazingumntu wokuqala we-'app killer 'zeekhompyutheni zobuqu ngenxa yokuba banakho ukuqokelela kunye nokwenza ulwazi ngolwazi. Iiprogram ze-spreadsheet zokuqala ezifana neVisiCalc kunye neLotus 1-2-3 zazikhokelela kakhulu ekukhuleni kwintengiso yeekhompyutha ezifana ne-Apple II kunye ne-IBM PC njengesixhobo soshishino.