Exercises of Excel

Muji Yamianto

Mayelana nalolu hlelo lokusebenza

Njengamanje, kunezincwadi eziningi, ama-e-books noma izinhlelo zokusebenza ezixoxa ngokusetshenziswa okuhlukahlukene kwamafomula e-Excel. Kuhle kwabaqalayo, okuphakathi, ukuya kokuthuthukile. Cishe yonke into isethiyori.

Ukuthuthukisa ikhono lethu lokusebenzisa uNksz. Excel, sidinga ukuzilolonga kakhulu. Ngalesi sizathu, umbhali uhlanganise "IQOQO LEMIBUZO YE-EXCEL" njengethuluzi lokuzijwayeza labo kini abafuna ukuthuthukisa ikhono lakho lokusebenzisa izinhlobo ezahlukahlukene zamafomula e-Excel.

Senze le mibuzo yokuzijwayeza ye-Excel ngokusekelwe ezihlokweni nasezifundweni zevidiyo kubhulogi yami:

https://mujiyamianto.blogspot.com

Njengomthombo wakho wesithenjwa ekusebenzeni imibuzo yokuzijwayeza.


Njengamanje kukhona 217 EXCEL QUESTIONS COLLECTIONS:
 Yonke into isesimweni semibuzo yokuzijwayeza (ufaka amafomula kumakholomu ethebula)
 AYIKHO imibuzo yethiyori/inqwaba yokukhetha

Izinombolo zokuzijwayeza ze-217 Excel zihlanganisa:
I. Ngokusekelwe ezintweni/izihloko ze-Blog yango-2018:
1. Imisebenzi: UMA, KWESOKUNXELE, PHAKATHI, KWESOKUDLA, KANYE, NOMA
(31 izinombolo)
2. Imisebenzi: HLOOKUP, VLOOKUP, INDEX, MATCH
(Izinombolo ezingama-27)
3. Umsebenzi: COUNT, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS
(11 izinombolo)
4. Umsebenzi: IDETHI, USUKU, INYANGA, UNYAKA
(11 izinombolo)
5. Imisebenzi Yezezimali noma Yezezimali: RATE, NPer, Per, PMT, PV, FV, IPMT, PPMT
(izinombolo ezingama-23)
6. Umsebenzi Wokwehla kwenani: SLN, SYD, DB, DDB, VDB
(14 izinombolo)
7. AMATHEBULA E-PIVOT kanye ne-GRAFIC
(3 izinombolo)


II. Ngokusekelwe ezintweni/izihloko ku-Blog yango-2019:
1. Umsebenzi wezezimali noma wezezimali: CUMIPMT, CUMPRINC
(4 izinombolo)
2. Umsebenzi Wezezimali noma Wezezimali: FVSCHEDULE
(3 izinombolo)
3. Umsebenzi: UMQEQESHO, UQINISEKILE, OWUMZULU
(2 izinombolo)
4. Umsebenzi: PRODUCT kanye ne-SUMPRODUCT
(4 izinombolo)


III. Ngokusekelwe ezintweni/izihloko kubhulogi lika-2020:
1. KHETHA umsebenzi
(4 izinombolo)
2. Hlanganisa IF ne-H/VLOOKUP
( 6 izinombolo)
3. Umsebenzi: I-ISPMT
(3 izinombolo)
4. Imisebenzi yombhalo
(4 izinombolo)
5. Izibalo Zezezimali: IZILINGANISO EZINGAQINISEKILE, IZILINGANISO EZINGANZAYO, INTLAZO EYODWA KANYE NENZALAZO EYINGXENYE
(16 izinombolo)


IV. Ngokusekelwe ezintweni/izihloko kubhulogi lika-2021:
1. Imisebenzi: DATEDIF, DAY, DAYS, DAYS360, EDATE, kanye ne-EOMONTH
(4 izinombolo)
2. Imisebenzi: I-AMORLINC ne-AMORDEGRC
(4 izinombolo)
3. Umsebenzi: USUKU LOMSEBENZI NEZINSUKU ZOKUSEBENZA
(4 izinombolo)
4. Imisebenzi: I-AVERAGE, AVERAGEIF, AVERAGEIFS, kanye ne-AVERAGEA
(5 izinombolo)
5. OKUNGAKUBI KWEFOMU YE-VLOOKUP
(4 IZINOMBOLO)


V. Ngokusekelwe ezintweni/izihloko kubhulogi ngo-2022 & 2023:
1. Umsebenzi we-IFERROR
(2 IZINOMBOLO)
2. YENZA UMUGQA WAMA-DIAGONAL ETAFULA
(4 IZINOMBOLO)
3. OMNCANE KANYE OMKHULU
(4 IZINOMBOLO)
4. USUKU LWEVIKI NEWEEKNUM umsebenzi
(3 IZINOMBOLO)
5. GUQULELA umsebenzi
(2 IZINOMBOLO)
6. Umsebenzi we-XLOOKUP
(10 IZINOMBOLO)


VI. Ngokusekelwe ezintweni/izihloko kubhulogi ngo-2024:
1. VALUE umsebenzi
(5 IZINOMBOLO)

Yini entsha

New questions added:
1. Xlookup function
2. Value function