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

This COLLECTION OF EXCEL QUESTIONS we made based on the material/articles I wrote on the Blog:

https://www.mujiyamianto.blogspot.com

The 181 question numbers consist of:
I. Based on the material/articles on the 2018 Blog:
1. Function: IF, LEFT, MID, RIGHT, AND, OR
(26 question numbers)
2. Function: 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 GRAPHS
(3 question numbers)

II. Based on the material/articles on the Blog in 2019:
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. Functions: PRODUCT and SUMPRODUCT
(4 question numbers)

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

IV. Based on the material/articles on the Blog in 2021:
1. Function: DATEIF, DAY, DAYS, DAYS260, EDATE, EOMONTH
(4 question numbers)
2. Depreciation Function: 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. Weaknesses of VLOOKUP
(4 question numbers)


I hope that this collection of Excel Questions can add to your understanding regarding the various uses of the excel functions/formulas above.



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