Kumpulan Soal-Soal Excel

Description

Currently we provide 217 numbers of Excel questions, with the following conditions:
• All are in the form of Excel Practice Questions (entering formulas into table columns).
• NO multiple choice questions or theory.

We created this COLLECTION of EXCEL QUESTIONS based on material/articles that I wrote on the Blog:

https://mujiyamianto.blogspot.com


The 217 question numbers consist of:

I. Based on material/articles on the 2018 Blog:
1. Functions: IF, LEFT, MID, RIGHT, AND, OR
(31 question numbers)
2. Functions: HLOOKUP, VLOOKUP, INDEX, MATCH
(27 question numbers)
3. Function: COUNT, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS
(11 question numbers)
4. Function: DATE, DAY, MONTH, YEAR
(11 question numbers)
5. Financial or Financial Functions: RATE, NPer, Per, PMT, PV, FV, IPMT, PPMT
(23 question numbers)
6. Depreciation Function: SLN, SYD, DB, DDB, VDB
(14 question numbers)
7. PIVOT TABLES and GRAPHICS
(3 question numbers)

II. Based on material/articles on the 2019 Blog:
1. Financial or Financial function: CUMIPMT, CUMPRINC
(4 question numbers)
2. Financial or Financial Function: FVSCHEDULE
(3 question numbers)
3. Function: ROUND, ROUNDUP, ROUNDDOWN
(2 question numbers)
4. Function: PRODUCT and SUMPRODUCT
(4 question numbers)

III. Based on material/articles on the 2020 Blog:
1. CHOOSE function
(4 question numbers)
2. Combine IF with H/VLOOKUP
(6 question numbers)
3. ISPMT function
(3 question numbers)
4. Functions - Text Functions
(4 question numbers)
5. Financial Mathematics: Fixed Interest Rates, Floating Interest Rates, Single and Compound Interest
(16 question numbers)

IV. Based on material/articles on the 2021 Blog:
1. Function: DATEIF, DAY, DAYS, DAYS260, EDATE, EOMONTH
(4 question numbers)
2. Depreciation Functions: AMORLINC and AMORDEGRC
(4 question numbers)
3. Function: WORKDAY and NETWORKDAYS
(4 question numbers)
4. Functions: AVERAGE, AVERAGEIF, AVERAGEIFS and AVERAGEA
(5 question numbers)
5. Disadvantages of VLOOKUP
(4 question numbers)


V. Based on material/articles on the blog in 2022 & 2023:
1. IFERROR function
(2 question numbers)
2. MAKE A DIAGONAL LINE ON THE TABLE
(4 question numbers)
3. SMALL & LARGE function
(4 question numbers)
4. WEEKDAY & WEEKNUM function
(3 question numbers)
5. CONVERT function
(2 question numbers)
6. XLOOKUP function
(10 question numbers)

VI. Based on material/articles on the blog in 2024:
1. VALUE function
(5 question numbers)

My hope is that this collection of Excel Questions can increase your understanding regarding the various uses of the Excel functions/formulas above.



NOTES:
If you have difficulty answering the questions above, you can visit my blog to learn theory and see the video tutorial.