Assess Your Knowledge on Excel Functions and Formulas
Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
This Excel Test is designed to help you assess your knowledge of basic Excel functions and formulas. We strongly encourage any students who are planning or are beginning their FMVA certification program to take this test to determine whether you will need to take the prerequisite Excel Crash Course and Excel Modeling Fundamentals Course. This is also a useful resource for employers to examine the technical Excel knowledge of the candidates during a finance interview or for applicants who want an Excel practice test.
If you pass this test with 80% or above (16 questions or more), it is likely that you have pretty solid fundamental knowledge of Excel!
Excel Test Questions
(Note: Questions on Excel shortcut keys are only applicable to PC users)
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.