Excel Test: 20 Questions to Assess Your Excel Skills
Sharpen your spreadsheet skills with a free Excel assessment test covering formulas, functions, and key shortcuts used in finance.
About CFI’s Excel Test
The Corporate Finance Institute (CFI) Excel Test consists of 20 free practice questions designed to help you assess your knowledge of basic Excel functions and formulas. Whether you’re preparing for a job interview, planning to start the FMVA® certification, or simply want to test your skills, this Excel assessment offers a practical and relevant benchmark.
If you’re just starting your FMVA® journey, we strongly recommend taking this test to determine whether you should begin with the Excel Crash Course or the Excel Fundamentals – Quick Start Guide.
The test includes questions on:
- Excel formulas and functions (SUM, IF, VLOOKUP, etc.)
- Shortcut keys and quick commands
- Charts, formatting, and file management
- Ranges, references, and error checking
- Best practices for financial modeling in Excel
A passing score is 80% or higher (16 correct answers), indicating strong foundational knowledge of Excel for finance.
Excel Test Questions
(Note: Questions on Excel shortcut keys are only applicable to PC users)
Finished the Quiz? Here’s Your Next Step
Take the next step by building real-world spreadsheet skills with CFI’s Excel Crash Course. Learn formulas, functions, and modeling techniques that are essential in finance.
Additional Excel Training Resources
Build your Excel skills with more CFI tools and training:
- Excel Formulas Cheat Sheet: Quickly reference essential Excel formulas used in finance.
- All Excel Resources: Browse all templates, tutorials, and guides.
What to Expect from the Excel Assessment Test
If you’re getting ready to pursue a finance certification or apply for a role that requires spreadsheet fluency, taking a structured Excel assessment test can help you:
- Identify areas for improvement before taking certification courses
- Build confidence before a job interview or an Excel exam
- Practice real-world tasks used in financial modeling, analysis, and reporting
This free Excel test is based on common functionality and exam-style questions often used to evaluate finance professionals. The format and difficulty level are comparable to the prerequisites for CFI’s FMVA® program and other advanced training.
Why Use an Excel Practice Test?
Completing an Excel practice test helps you:
- Prepare for skills-based interviews or screening assessments
- Familiarize yourself with formulas and charting functions
- Benchmark your readiness before enrolling in Excel-based finance programs
- Reduce exam anxiety by practicing common Excel exam question types
For best results, use Excel on a PC or a compatible spreadsheet program to try out the questions in a real worksheet.
Build on Your Excel Skills with CFI
CFI® is the global provider of the FMVA® certification program, designed to help finance professionals gain practical, job-ready skills in Excel, modeling, and financial analysis. If you scored below 80% or want to build deeper proficiency, we recommend starting with our foundational Excel Crash Course or the Excel Modeling Fundamentals Course.
Explore more learning paths:
Frequently Asked Questions
What is the CFI Excel Test?
It’s a free Excel practice exercise covering formulas, functions, shortcuts, and modeling concepts used in finance.
Is the Excel test free?
Yes, this is a free Excel practice test provided by CFI® to help you evaluate your skills before enrolling in advanced certifications like the FMVA®.
What is a good score on an Excel test?
Scoring 80% or above (16/20 correct) generally indicates strong proficiency and readiness for intermediate Excel tasks.
Is this test suitable for beginners?
Yes. This test is best suited for learners with some familiarity with Excel basics who want to evaluate their foundational skills.
Will this help me prepare for a job interview?
Absolutely. Employers often use similar Excel assessments during the hiring process, especially for roles in finance, analysis, and accounting.
In order to become a great financial analyst, here are some more questions and answers for you to discover:
Excel Tutorial
To master the art of Excel, check out CFI’s Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Launch CFI’s Excel Crash Course now to take your career to the next level and move up the ladder!
