Currently, there
are many books, e-books or applications that discuss various uses of excel
formulas. Both for beginners, intermediate, to advanced levels. Almost all of
them are still theoretical.
To improve the ability to use Ms. Excel, we must practice a lot. Therefore, the author compiled "EXERCISES OF EXCEL" as a means of practice for those of you who want to improve your ability to use various excel formulas.
We created these
excel practice questions based on articles and video tutorials on my Blog:
https://mujiyamianto.blogspot.com
As a reference
source for you in working on practice questions.
Currently, there
are 217 EXERCISES OF EXCEL questions:
- All are in the form of practice questions (entering formulas in table columns)
- NO theory/multiple choice questions
The 217 excel practice numbers consist of:
I. Based on
the material/articles on the Blog in 2018:
1. Functions: IF, LEFT, MID, RIGHT, AND, OR
(31 numbers)
2. Functions: HLOOKUP, VLOOKUP, INDEX, MATCH
(27 numbers)
3. Functions: COUNT, COUNTIF, COUNTIFS, SUM, SUMIF,
SUMIFS
(11 numbers)
4. Functions: DATE, DAY, MONTH, YEAR
(11 numbers)
5. Financial Functions: RATE, NPer, Per, PMT, PV, FV,
IPMT, PPMT
(23 numbers)
6. Functions Depreciation: SLN, SYD, DB, DDB, VDB
(14 numbers)
7. PIVOT TABLE and GRAPHICS
(3 numbers)
II. Based on
materials/articles on the Blog in 2019:
1. Financial functions: CUMIPMT, CUMPRINC
(4 numbers)
2. Financial functions: FVSCHEDULE
(3 numbers)
3. Functions: ROUND, ROUNDUP, ROUNDDOWN
(2 numbers)
4. Functions: PRODUCT and SUMPRODUCT
(4 numbers)
III. Based on
the material/articles on the blog in 2020:
1. CHOOSE function
(4 numbers)
2. Combination of IF with H/VLOOKUP
(6 numbers)
3. Function: ISPMT
(3 numbers)
4. Text Functions
(4 numbers)
5. Financial Mathematics: FIXED INTEREST RATES,
FLOATING INTEREST RATES, SIMPLE INTEREST AND COMPOUND INTEREST
(16 numbers)
IV. Based on
the material/articles on the blog in 2021:
1. Functions: DATEDIF, DAY, DAYS, DAYS360, EDATE, and
EOMONTH
(4 numbers)
2. Functions: AMORLINC and AMORDEGRC
(4 numbers)
3. Functions: WORKDAY and NETWORKDAYS
(4 numbers)
4. Functions: AVERAGE, AVERAGEIF, AVERAGEIFS, and
AVERAGEA
(5 numbers)
5. DISADVANTAGES OF VLOOKUP FORMULA
(4 NUMBERS)
V. Based on
the material/articles on the blog in 2022 & 2023:
1. IFERROR function
(2 NUMBERS)
2. CREATING A DIAGONAL LINE IN A TABLE
(4 NUMBERS)
3. SMALL & LARGE functions
(4 NUMBERS)
4. WEEKDAY & WEEKNUM functions
(3 NUMBER)
5. CONVERT function
(2 NUMBERS)
6. XLOOKUP function
(10 NUMBERS)
VI. Based on
the material/articles on the blog in 2024:
6. VALUE function
(5 NUMBERS)
Total: 217 numbers
We also provide
excel practice questions for you
The questions
include all the materials/articles that I wrote on the Blog
Please download it at: Google Playstore
Here's how:
Click :
Google Playstore on your device / cellphone
Select the menu : Apps / Applications
(located on the bottom screen)
In the Search
Engine, type:
For complete information on the questions, please click the Video link below:
https://youtube.com/shorts/Bq5yz-XsJYI
The author includes several example questions in the EXERCISES OF EXCEL, for your reference:
1.
Formula: Counta, Countif, Sum
2. Formula: IF, And, Or
3.
Formula: IF, Vlookup
4. Formula Financial: PMT
5. Formula: Depreciation
