15 to 30 random questions in 15 to 30 minutes, by the level you choose: mis reports, lookups, pivots, power query, reconciliation, dashboards. After you submit you get your score, your strong and weak topics, and the right answer with an explanation for every question.
The test covers 13 topics across three levels. Each attempt picks 15 to 30 questions at random, by the level you choose, so every attempt is different.
One question from each level, the way they appear in the test. A new set comes on the 1st of every month. Try it, then open the answer.
Answer: Right-click a value in Sum of Amount and choose Sort > Sort Largest to Smallest. Sorting on a value cell orders the row items by that value and keeps the order after refresh. Sorting the source does not decide the pivot's order, which follows labels by default, and Ctrl+T creates a Table, not a sort.
Answer: =IFNA(VLOOKUP(A2,Master!A:C,3,FALSE),"Check code"). IFNA replaces only #N/A, the not-found error, so a #REF! from a broken range still shows and gets noticed. IFERROR would hide every error behind Check code, and ISNA takes one argument and returns TRUE or FALSE, not a label.
Bank: 5000, 5000, 7200, 5000, 3100
Books: 5000, 7200, 5000, 3100, 2500
Key (bank, B2): =A2&"|"&COUNTIF($A$2:A2,A2) Answer: 1. Bank keys are 5000|1, 5000|2, 7200|1, 5000|3 and 3100|1; the books have 5000|1, 5000|2, 7200|1 and 3100|1 (and 2500|1). Only 5000|3 has no partner, so 1. A plain COUNTIF on amount finds every 5000 in the books and shows 0 unmatched.
Take the full MIS Executive Excel Test mock test: 15 to 30 questions and 15 to 30 minutes, by level.
A question counts as right only when you pick exactly the right option, or all the right options where it says so; a question left blank counts as wrong. Your score is the share of the test's questions you got right (15 to 30, by level). The result also scores every topic, so you know what to revise before the interview.
Yes. The MIS Executive Excel Test mock test is free. You need a free CoreHRx Jobs account to start it, so your score and the topics to work on are saved.
It depends on the level: Fresher has 15 questions in 15 minutes, Intermediate has 20 questions in 20 minutes, Experienced has 30 questions in 30 minutes. They are multiple-choice questions picked at random from a larger bank of MIS Executive Excel Test questions at your level, so every attempt is different.
The questions cover Dates, Ageing and TAT, Dynamic Arrays, Validation and Error Checks, Conditional Totals and Counts, Dashboards and Charts, Data Cleaning, KPIs and Business Metrics, Lookups in Reports, MIS Reporting Basics, Pivot Table Reports, Power Query, Macros and VBA, Reconciliation and Variance. Your result shows how you did in each topic.
Fresher: Students and freshers, up to 1 year: the Excel basics every MIS role checks. Intermediate (1-5 years): 1 to 5 years: daily and monthly reports, lookups, pivots and clean data. Experienced (5+ years): 5+ years: automation, dashboards, reconciliation and tricky report errors. Start with Fresher and move up.
Only your best MIS Executive Excel Test score, and only when it is 60% or more. It shows on the job applications you send on CoreHRx. Lower scores stay private.
Yes, up to 10 tests a day. Each attempt picks questions you have not seen recently first.