Exercises of Excel

This excel exercises aims to improve your ability to use various excel formulas that we often use everyday.
We made these Excel Exercises based on the material / article I wrote on the Blog:
https: //www.mujiyamianto.blogspot.com
There are currently 181 question numbers consisting of:
I.
Based on material / articles in the 2018 Blog:
1.
Functions: IF, LEFT, MID, RIGHT, AND, OR
(26 numbers)
2.
Functions: HLOOKUP, VLOOKUP, INDEX, MATCH
(27 numbers)
3.
Functions: COUNT, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS
(11 numbers)
4.
Function: DATE, DAY, MONTH, YEAR
(11 numbers)
5.
Financial Functions: RATE, NPer, Per, PMT, PV, FV, IPMT, PPMT
(23 numbers)
6.
Depreciation Function: SLN, SYD, DB, DDB, VDB
(14 numbers)
7.
PIVOT TABLE and CHART
(3 numbers)
II.
Based on material / articles in the 2019 Blog:
1.
Financial Functions: CUMIPMT, CUMPRINC
(4 numbers)
2.
Financial Function: FVSCHEDULE
(3 numbers)
3.
Function: ROUND, ROUNDUP, ROUNDDOWN
(2 numbers)
4.
Function: PRODUCT, SUMPRODUCT
(4 numbers)
III.
Based on material / articles in the 2020 Blog:
1.Function: CHOOSE
(4 numbers)
2.
COMBINED IF and VLOOKUP
(6 numbers)
3.
Function: ISPMT
(3 numbers)
4.
Function: TEXT
(3 numbers)
5.
FINANCIAL MATH
(16 numbers)
IV.
Based on material / articles in the 2021 Blog:
1.
DATEDIF, DAY, DAYS, DAYS 360, EDATE, EOMONTH
(4 numbers)
2.
Functions: AMORLINC, AMORDEGRC
(4 numbers)
3.
Functions: WORKDAY, NETWORKDAYS
(4 numbers)
4.
Functions: AVERAGE, AVERAGEIF, AVERAGEIFS, AVEREGEA
(5 numbers)
5.
VLOOKUP WEAKNESSES
(4 numbers)
All exercises are in the form of essays (entering formulas into tables), no theoretical or multiple choice questions
There is a possibility there is a mismatch in the use of grammatical structures, vocabulary.
This is because I use Google translate
NOTE:
If you have difficulty in answering the exercises above, you can visit my blog to learn the theory and see the Video tutorial (Indonesian version).

Page navigation:

• < Prev
• Next >