Njengoba e "Eksele" esikhundleni iphuzu ukhefana? Lungiselela Excel

Ukuqalisa esetshenziswa uhlelo olukhona izinto, asivamile ukucabanga yokuthi umuntu angaphila ngaphansi neminye imithetho. Empeleni, lokhu ethi uDalai Lama, futhi incazelo ka-yezinkinga nehhovisi lendawo lezingcingo ezinjalo kungabangela Excel kulungiselelwa lesifunda. essence yayo itholakala iqiniso ukuthi emazweni amaningi, ngisho usebenzisa netinombolo efanayo Arabhu, inombolo ngokuvamile ebhaliwe kancane ehlukile. Isibonelo esimangalisayo kulesi umehluko, ngokuvamile kuholela ezinkingeni, kuyisibonakaliso okuhlukana ingxenye ayingxenye ye wonke. ERussia, futhi ngempela esikhaleni elaliyiSoviet, kuba njalo ukhefana, kodwa amazwe aseNtshonalanga - iphuzu.

Meaning of imigomo Excel

Ake sibheke indlela nemiphumela engathandeki kungase kuphumele khona isimiso "okungalungile" noma, kunalokho ukusho, idilimitha ayilungile. Ezimweni eziningi, eziningi eziqukethe iphuzu, Excel uzobe esichazwa njengesono esiphambene usuku, futhi ngokufanelekile, esikhundleni "25,11" uthola "25.noyab" cell.

Lapho ukusebenza esiningi idatha ku itafula, awukwazi ngokushesha ukuthi lolu shintsho. Ikakhulukazi ngoba akuzona zonke inombolo kungenziwa zonakaliswa. Ngokwesibonelo, "25,13" izohlala ingashintshiwe. Njengoba uke uqagele ukuguqulwa sizothinta kuphela lezo izinombolo lapho, ngaphambi noma emva iphuzu kukhona izinombolo kusuka 1 kuya 12. Kuyinto leli banga lisetshenziswa ukuze libhekisele izinyanga zonyaka, futhi ngenxa yalokho, kusolakala njengoba usuku. Uma isibalo esingangaleso ziyokuwa elilodwa noma amabili namashumi, kuyoba ukuzibonakalisa eyedwa kulesi sibalo esiteji.

esikhundleni iphuzu

Kunezindlela eziningana ongakhetha kuzona ukuthi ukubeka okhefana kule "Eksele". Sibheka kuphela elula kakhulu futhi kuyasebenziseka, okungase kusetshenziswe noma iyiphi umsebenzisi, kungakhathaliseki ezingeni ikhompyutha.

• Njengoba e "Eksele" esikhundleni iphuzu ukhefana, usebenzisa kwemigomo hlelo? Ukuze wenze lokhu, hamba esigabeni "Amapharamitha" etafuleni umhleli bese uya "Okuthuthukisiwe" imenyu. Kule ngxenye, udinga ukususa ibhokisi isheke ngaphansi "Sebenzisa uhlelo separators". Ngakho kuvulwa elilandelayo amaphuzu amabili, ungakwazi ukushintsha amamaki division ku isidingo ukusebenza idatha yakho.

• Njengoba e "Eksele" esikhundleni iphuzu ukhefana, usebenzisa ukusebenza uhlelo lokusebenza sika? Ngo-Windows Control Panel uzodinga ukuthola kwesigaba "Yesifunda Izinketho Ulimi." Ngokuqondene "Ifomethi" ithebhu ewindini esivula, uzoshintshela oHlelweni menyu engaphansi "Izilungiselelo ezithuthukisiwe" bese "Izinombolo" ukushintsha ingxenye yedesimali ezidingekayo.

• Njengoba e "Eksele" esikhundleni iphuzu ukhefana usebenzisa "Thola futhi Faka" umsebenzi? Le menu MHLAWUMBE ujwayelene kubasebenzisi kakhulu, kanye nokusebenzisa kwayo akudingi amazwana ezengeziwe. Iphuzu kuphela kubalulekile ukuthi kuzodingeka ukwenze ukugqamisa isidingo endaweni pre-kuhleleke. Uma ungenalo ukwenza lo msebenzi, "Excel" zizoshintsha wonke amaphuzu etholakalayo eshidini bese ekuqedeni ukungalingani ngokwezomnotho kwenye ingxenye etafuleni, ungathola ke kwesinye.

Enye indlela endala kodwa efakazelwe kuyinto pre-esikhundleni separators kunoma iyiphi Umhleli wombhalo elula. Abasebenzi "incwajana" kusukela ejwayelekile izinhlelo Windows kungaba ngokuphelele ukubhekana ngokuphumelelayo lo msebenzi. Lo mshini wezenzo kufana zokugcina indlela echazwe itholakala esikhundleni okulula izimpawu nezinsuku umhleli lwamasipredishithi.

Umehluko kwimenyu ehhovisi Suites

Ngo suite ihhovisi kusuka ku-Microsoft nge inguqulo entsha ngamunye ilungiselelo kuyiwa semenyu izinto. Yayiphumula ne-Excel 2013. Ngaphezu ukuklama izinguquko eziye zathinta Umbala kanye nokuvela izithonjana umyalo iribhoni uye sigudluke into "Izinketho". Wathuthela phansi main olukumabhekezansi imenyu ohlangothini ingxenye yayo.

Kuzo zonke ezinye izenzo umsebenzisi Excel 2013 usebenzise iiyeleliso isigaba odlule, fanekiso ngokuphelele ukusebenza izinguqulo ngaphambili. Uma usuvule uye wawugxilisa imenyu izilungiselelo, uzothola ngokwakho esibonakalayo ajwayelekile.

Ngamafuphi, bese zonke izinguqulo Office, imibala ehlukene for Uhlelo ngalunye uqukethe nemingcele entweni eseceleni. Lezi zihlanganisa inguqulo 2013 futhi zonke okwalandela, okukhethwa kukho okuseqophelweni ngaphezulu.

izingibe

Manje, ukuqonda njengasezulwini "Eksele" kufakwa iphuzu ukhefana, ukubhekana izici yezindlela kuchazwe. Ukushintsha izilungiselelo zohlelo lokusebenza noma kumasethingi ohlelo lwe-Yiqiniso, kungasiza endabeni yesikhathi esisodwa isidingo, kodwa ngaso sonke isikhathi kule modi akusebenzi ukhululekile kakhulu.

Okuningi akukhetha kakhulu ngokombono usizo okubukeka yesikhathi esisodwa ukushintshanisa kwe-data endaweni oyifunayo ngokusebenzisa imenyu yokusesha. Kulokhu, ungenawo isengozini ukuhlanekezela idatha yabo kwamanye amathebula futhi kungaba zibukeke ukulawula inqubo ushintsho abahlukanisi wamaqhuzu.

Umbhalo format futhi ukubala

Kodwa phezu kwalokho konke kuchazwe, kunesinye isici esithakazelisayo umhleli ithebula "Excel". Umbhalo ofakiwe ngu ukukopisha, Kungenzeka akekho onendaba njengoba ulwazi digital kwezinye izimo. Cell lapho inombolo elondolozwe njengoba umbhalo, kuyoba ne unxantathu eliluhlaza ekhoneni eliphezulu esinxeleni. Ngaphandle, abaprofethi bamanga konke kubukeka ehloniphekile, izibalo kungukuthi uhlanekezelwe, kodwa amarekhodi ungahambi lapho lizama ukukhiqiza izilinganiso idatha yeseli ezinjalo.

Ngakho, etafuleni kwesokudla ezibukeka uyonika umphumela okungalungile, uma uyibambe kulesi sibalo. Lokhu inkinga isixazululekile esebenzisa avamile "Excel". Ukukhetha yeseli nge ekhoneni green eduze supernatant kungatholakala uphawu wesibabazo unxantathu ophuzi. Ukuchofoza kuzobangela imenyu encane umongo. Ngokukhetha ke ukhetho phezulu "Guqulela inombolo", wena ngaphandle ukulahleka kwedatha, ukushintsha umbono wabo.

Ngemva kokuhlinzwa kuqondile ezinjalo, zonke izibalo kuzokwenziwa ngendlela efanele. Ukuze kusheshiswe ungakhetha ezingaphezu kweyodwa cell enjalo, futhi eduze eziningana futhi ngokushesha ushintshe izilungiselelo zabo ngokusebenzisa indawo yemenyu yokuqukethwe.

Ekuphetheni

Kulesi sihloko asilethanga izindlela kuyashesha futhi ngempela ukusebenza ukulungisa izethulo yefomu idatha digital "Excel". isicelo sabo practice kuyosisiza ukuba sihlale imizwa yakho kanye nesikhathi lapho besebenza spreadsheet.