Collection of Excel Exercises

Android app by Muji Yamianto. Education · Muji Yamianto

Store rating
Unknown
Store rating count
Unknown
Download price
0.99 USD
In-app purchases
Not listed in captured metadata
Version
09.09.26
Listing last refreshed
2026-09-16

View the original store listing

Store description excerpt

We currently provide 217 Excel practice exercises with the following features: 1. Practical Hands-on: All exercises are in the form of practical Excel sheets (entering formulas into table columns). 2. No Theory: There are NO multiple-choice questions or theoretical tests. This EXCEL EXERCISE COLLECTION is created based on the materials and articles I wrote on my blog: https://mujiyamianto.blogspot.com The 217 practice exercises consist of: I. Based on 2018 Blog Articles: 1. Functions: IF, LEFT, MID, RIGHT, AND, OR (31 questions) 2. Functions: HLOOKUP, VLOOKUP, INDEX, MATCH (27 questions) 3. Functions: COUNT, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS (11 questions) 4. Functions: DATE, DAY, MONTH, YEAR (11 questions) 5. Financial Functions: RATE, NPer, Per, PMT, PV, FV, IPMT, PPMT (23 questions) 6. Depreciation Functions: SLN, SYD, DB, DDB, VDB (14 questions) 7. PIVOT TABLES and CHARTS (3 questions) II. Based on 2019 Blog Articles: 1. Financial Functions: CUMIPMT, CUMPRINC (4 questions) 2. Financial Functions: FVSCHEDULE (3 questions) 3. Functions: ROUND, ROUNDUP, ROUNDDOWN (2 questions) 4. Functions: PRODUCT and SUMPRODUCT (4 questions) III. Based on 2020 Blog Articles: 1. CHOOSE Function (4 questions) 2. Combined IF with H/VLOOKUP (6 questions) 3. ISPMT Function (3 questions) 4. Text Functions (4 questions) 5. Financial Mathematics: Fixed Interest Rates, Floating Interest Rates, Simple and Compound Interest (16 questions) IV. Based on 2021 Blog Articles: 1. Functions: DATEDIF, DAY, DAYS, DAYS360, EDATE, EOMONTH (4 questions) 2. Depreciation Functions: AMORLINC and AMORDEGRC (4 questions) 3. Functions: WORKDAY and NETWORKDAYS (4 questions) 4. Functions: AVERAGE, AVERAGEIF, AVERAGEIFS, and AVERAGEA (5 questions) 5. VLOOKUP Limitations (4 questions) V. Based on 2022 & 2023 Blog Articles: 1. IFERROR Function (2 questions) 2. Creating Diagonal Lines in Tables (4 questions) 3. SMALL & LARGE Functions (4 questions) 4. WEEKDAY & WEEKNUM Functions (3 questions) 5. CONVERT Function (2 questions) 6. XLOOKUP Function (10 questions) VI. Based on 2024 Blog Articles: 1. VALUE Function (5 questions) I hope this collection of Excel practice questions can enhance your understanding of the various uses of the Excel formulas and functions mentioned above. NOTES: 1. ZOOM IN / OUT Feature: Double-tap to activate. 2. Need Help?: If you find it difficult to answer the questions, you can visit my blog to study the theory and watch the video tutorials.

Review coverage

AppRill has captured 0 reviews for this app. This is a collected sample, separate from the store rating count. Latest review capture: Not captured yet.

Recent captured chart positions

No chart positions have been captured for this app yet.

Chart position, rating count and review coverage do not establish downloads, revenue or profit. Understand the differences.