Exercises of Excel
Good for beginners, intermediate, to advanced.
Almost everything is still theoretical.
To improve our ability to use Ms.
Excel, we need to practice a lot.
For this reason, the author has compiled a "COLLECTION OF EXCEL QUESTIONS" as a practice tool for those of you who want to improve your ability to use various kinds of Excel formulas.We made these Excel practice questions based on articles and video tutorials on my blog:https://www.mujiyamianto.blogspot.comAs your reference source in working on practice questions.
Currently there are 212 EXCEL QUESTIONS COLLECTIONS: Everything is in the form of practice questions (entering formulas in the table columns) NO theory/multiple choice questionsThe 212 Excel practice numbers consist of:I.
Based on material/articles on the 2018 Blog:1.
Functions: IF, LEFT, MID, RIGHT, AND, OR (31 numbers)2.
Functions: HLOOKUP, VLOOKUP, INDEX, MATCH (27 numbers)3.
Function: COUNT, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS (11 numbers)4.
Function: DATE, DAY, MONTH, YEAR (11 numbers)5.
Financial or Financial Functions: RATE, NPer, Per, PMT, PV, FV, IPMT, PPMT (23 numbers)6.
Depreciation Function: SLN, SYD, DB, DDB, VDB (14 numbers)7.
PIVOT TABLES and GRAPHICS (3 numbers)II.
Based on material/articles on the 2019 Blog:1.
Financial or Financial function: CUMIPMT, CUMPRINC (4 numbers)2.
Financial or Financial Function: FVSCHEDULE (3 numbers)3.
Function: ROUND, ROUNDUP, ROUNDDOWN (2 numbers)4.
Function: PRODUCT and SUMPRODUCT (4 numbers)III.
Based on material/articles on the 2020 blog:1.
CHOOSE function (4 numbers)2.
Combine 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, SINGLE INTEREST AND COMPOUND INTEREST (16 numbers)IV.
Based on material/articles on the 2021 blog:1.
Functions: DATEDIF, DAY, DAYS, DAYS360, EDATE, and EOMONTH (4 numbers)2.
Functions: AMORLINC and AMORDEGRC (4 numbers)3.
Function: WORKDAY and NETWORKDAYS (4 numbers)4.
Functions: AVERAGE, AVERAGEIF, AVERAGEIFS, and AVERAGEA (5 numbers)5.
DISADVANTAGES OF THE VLOOKUP FORMULA (4 NUMBERS)V.
Based on material/articles on the blog in 2022 & 2023:1.
IFERROR function (2 NUMBERS)2.
MAKE A DIAGONAL LINE ON THE TABLE (4 NUMBERS)3.
SMALL & LARGE function (4 NUMBERS)4.
WEEKDAY & WEEKNUM function (3 NUMBERS)5.
CONVERT function (2 NUMBERS)6.
XLOOKUP function (10 NUMBERS) Total: 212 numbers
About Exercises of Excel
- Package name (App ID)
- muji.yamianto.exercisesexcel
- Available on
- Google Play
- Price
- $1.09
- Developer
- Muji Yamianto
Looking for the Exercises of Excel APK?
The safest way to get Exercises of Excel (muji.yamianto.exercisesexcel) on your Android device is to install it directly from Google Play — you'll always get the latest official version, automatic updates, and no risk of modified or infected APK files from third-party sites.
Social Features
Connect and share with friends and the community.
Camera Features
Advanced camera features with editing capabilities.
Fitness Tracking
Track your workouts and monitor your health metrics.
See Exercises of Excel in Action
Frequently Asked Questions
Is Exercises of Excel free?
Exercises of Excel is a paid app — it costs $1.09 on Google Play. You pay once through your Google account and can install it on your Android devices.
How do I install Exercises of Excel on Android?
Open Google Play on your Android phone or tablet, search for Exercises of Excel by Muji Yamianto or tap the Google Play button on this page, then tap Install. The app downloads and installs automatically.
What is muji.yamianto.exercisesexcel?
muji.yamianto.exercisesexcel is the App ID (package name) of Exercises of Excel on Google Play. Every Android app has a unique package name, and it is the safest way to verify you are installing the official app.
Is Exercises of Excel safe to download?
Installing Exercises of Excel from Google Play is the safest option: you get the official version published by Muji Yamianto, verified by Google Play Protect, with automatic updates. Avoid APK files from unofficial third-party sites.
Get Exercises of Excel Today
Exercises of Excel for Android — $1.09 on Google Play.
Compatible with Android phones and tablets — available on Google Play.
Ask AI about this app
Get instant answers about features, tips and more from popular AI assistants.