Excel Basics Quiz

CodeNest Studios

Iqukethe izikhangiso

Mayelana nalolu hlelo lokusebenza

I-Excel Basics Quiz iwuhlelo lokufunda olusekelwe ku-MCQ oluklanyelwe ukusiza abafundi, ochwepheshe, nabaqalayo ukuthi bafunde i-Microsoft Excel ngendlela elula, esebenzisanayo. Lolu hlelo lokusebenza lwe-Excel Basics luhlanganisa amakhono e-Excel ngokusebenzisa imibuzo yokukhetha eminingi engenamanothi amade, imibuzo esebenzayo kuphela nezimpendulo. Ilungele ukuqeqeshwa kwamakhono asehhovisi, izivivinyo ezincintisanayo, nokuthuthukiswa kokukhiqiza kwansuku zonke.

Kungakhathaliseki ukuthi ufunda i-Excel okokuqala ngqa noma uthuthukisa amakhono akho, Imibuzo Eyisisekelo Ye-Excel ikunikeza imibuzo ehlelekile yesihloko ehlakaniphile, imiphumela esheshayo, nezincazelo eziqondakala kalula.

Izici Eziyinhloko

Izihloko zokuqoqwa kwe-MCQ zethulwe njengemibuzo yokukhetha okuningi.

Imibuzo ehlakaniphile ngesihloko: Ukusuka ku-Excel Interface kuye kumathebula e-Pivot kanye nokwabelana.

Ozokufunda Ngaphakathi Kuhlelo Lokusebenza

1. I-Excel Interface & Navigation
- Amathebhu eRibhoni: Hlela amathuluzi nemiyalo
- Ibha yamathuluzi yokufinyelela Ngokushesha: Izinqamuleli zesenzo esivamile
– Incwadi Yokusebenzela vs Iphepha Lokusebenzela: Amafayela namakhasi achaziwe
- Ibha Yesimo: Ibonisa imodi nolwazi
- Skrola futhi Sondeza: Buka ishidi ngempumelelo
- Amathebhu Weshidi: Shintsha, qamba kabusha, futhi uphathe amashidi

2. Ukufakwa Kwedatha & Ukufometha
- Ukufaka umbhalo nezinombolo: Amakhono okufaka ayisisekelo
- Isici Sokugcwalisa Okuzenzakalelayo: Ukufakwa kwephethini esheshayo
- Amaseli Okufometha: Amafonti, imibala, nokuqondanisa
- Amafomethi Ezinombolo: Imali, amaphesenti, izinketho zedesimali
- Ukufometha Okunemibandela: Gqamisa idatha ngemithetho
- Thola & Faka esikhundleni: Shintsha okufakiwe okuningi ngokushesha

3. Amafomula kanye Nemisebenzi Eyisisekelo
- Izinkomba Zeseli: Isihlobo, ngokuphelele, sixubile
- Umsebenzi we-SUM: Isamba samanani ezinombolo zamaseli
- I-AVERAGE Umsebenzi: Incazelo yedathasethi
- COUNT & COUNTA: Bala izinombolo noma okufakiwe
- Umsebenzi we-IF: I-logic enemibandela kumafomula
- Hlanganisa Imisebenzi: I-Nest yezibalo eziyinkimbinkimbi

4. Amashadi & Ukubona ngeso lengqondo
- Faka Ishadi Lekholomu: Qhathanisa idatha ngokubukeka
- Amashadi kaphayi: Bonisa izingxenye zawo wonke
- Amashadi Omugqa: Landelela izitayela ngokuhamba kwesikhathi
- Amashadi Okufometha: Imibala, izinganekwane, namalebula edatha
- I-Sparklines: Amashadi amancane kumaseli
- Izitayela Zeshadi: Isakhiwo esisheshayo kanye nomklamo

5. Amathuluzi Okuphatha Idatha
- Hlunga Idatha: ngokulandelana kwezinhlamvu noma izinombolo
- Idatha Yesihlungi: Bonisa imigqa edingekayo kuphela
- Ukuqinisekiswa Kwedatha: Lawula amanani avunyelwe ukungena
- Susa Izimpinda: Hlanza idathasethi ngokuzenzakalelayo
– Umbhalo Kumakholomu: Hlukanisa amanani eseli ahlanganisiwe
- I-Flash Fill: Gcwalisa ngokuzenzakalela amaphethini aphindaphindayo

6. Amathebula e-Pivot nezifinyezo
- Faka Ithebula Le-Pivot: Ukuhlaziywa kwedatha okusheshayo
- Imigqa namakholomu: Hlela isakhiwo se-pivot
- Indawo Yamagugu: Izifinyezo ezinamanani kalula
- Idatha Yeqembu: Hlanganisa izinsuku noma izinombolo
- Amashadi e-Pivot: Bona ngeso lengqondo okutholwe kuthebula le-pivot
- Vuselela Idatha: Buyekeza i-pivot ngezinguquko

7. Ukusebenzisana Nokwabelana
- Landelela Izinguquko: Gada ukuhlelwa ngabasebenzisi
- Amazwana & Amanothi: Shiya impendulo kalula
- Vikela Amashidi Okusebenzela: Khiya amaseli ekuhleleni
- Yabelana Ngencwadi Yokusebenzela: Abantu abaningi bahlela ndawonye
- Gcina njenge-PDF: Thumela ukuze wabelane kalula
- Ukuhlanganiswa kwe-OneDrive: Gcina amafu futhi ufinyelele

8. Amathiphu, Izinqamuleli Nokukhiqiza
- Izinqamuleli zekhibhodi: Sheshisa imisebenzi yansuku zonke
- Ububanzi obuqanjiwe: Ireferensi elula yamafomula
- Friza Amafasitelana: Gcina izihloko zibonakala
- Ukubuka Ngokwezifiso: Gcina izilungiselelo ezithandwayo zokubonisa
- Izifanekiso: Qala ngokushesha ngemiklamo eyakhiwe ngaphambilini
- I-AutoRecover: Buyisela umsebenzi ongalondoloziwe ngokuzenzakalelayo

Kungani Khetha Imibuzo Eyisisekelo Ye-Excel?

I-MCQ Kuphela: Funda i-Excel ngokusebenzisa imibuzo yokuzijwayeza, hhayi izifundo ezinde.

Ukufunda Okuhlelekile: Ihlanganisa isikhombimsebenzisi se-Excel, ukuphathwa kwedatha, amashadi, amafomula, nokuningi.

Isivivinyo Silungile: Ilungele abafuna umsebenzi, abasebenzi basehhovisi, abafundi, nezivivinyo zokuncintisana.

Ukuthuthukiswa Kwekhono: Zuza ulwazi lwe-Excel lomhlaba wangempela isinyathelo nesinyathelo.

Ilungele:

Abaqalayo bafunda iMicrosoft Excel

Abafundi balungiselela izivivinyo zekhono lekhompyutha

Izingcweti ezithuthukisa ukusebenza kwehhovisi

Othisha nabaqeqeshi abadinga impahla yemibuzo

Dawuniloda “Imibuzo Eyisisekelo Ye-Excel” manje futhi ufunde imibuzo eminingi yokuzikhethela ye-Microsoft Excel ehlanganisa yonke into kusukela kokuyisisekelo esibonakalayo kuya kumathebula e-pivot, amashadi, namathiphu okukhiqiza.