---
title: "Excel Test for Finance Jobs: Free Timed Practice Test | PracticeExcel"
description: "Practice the Excel test for finance roles with 20 timed tasks in a live grid. Margins, YTD, SUMIFS, PMT, NPV, IRR and lookups, scored instantly."
canonical_url: "https://practiceexcelonline.com/tests/excel-test-for-finance"
locale: en
meta:
"og:description": "Practice the Excel test for finance roles with 20 timed tasks in a live grid. Margins, YTD, SUMIFS, PMT, NPV, IRR and lookups, scored instantly."
"og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgVGVzdCBmb3IgRmluYW5jZSBKb2JzOiBGcmVlIFRpbWVkIFByYWN0aWNlIFRlc3Q%2Cdescription_~UHJhY3RpY2UgdGhlIEV4Y2VsIHRlc3QgZm9yIGZpbmFuY2Ugcm9sZXMgd2l0aCAyMCB0aW1lZCB0YXNrcyBpbiBhIGxpdmUgZ3JpZC4gTWFyZ2lucywgWVRELCBTVU1JRlMsIFBNVCwgTlBWLCBJUlIgYW5kIGxvb2t1cHMsIHNjb3JlZCBpbnN0YW50bHku%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIkxpbmUiLCJBbW91bnQiLCJHcm9zcyBtYXJnaW4iXX0seyJuIjoyLCJjZWxscyI6WyJSZXZlbnVlIiwiMTg0MDAwMCIsIiJdfSx7Im4iOjMsImNlbGxzIjpbIkNvc3Qgb2YgZ29vZHMgc29sZCIsIjExOTYwMDAiLCIiXX0seyJuIjo0LCJjZWxscyI6WyJPdGhlciBleHRlcm5hbCBjb3N0cyIsIjMxMjAwMCIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIlN0YWZmIGNvc3RzIiwiMjQ1MDAwIiwiIl19XSwidGFyZ2V0IjpbMSwyXX19%2Cp_Ii90ZXN0cy9leGNlbC10ZXN0LWZvci1maW5hbmNlIg%2Cs_72Jg8HiOTtvkFsXa.png"
"og:image:height": "600"
"og:image:type": image/png
"og:image:width": "1200"
"og:title": "Excel Test for Finance Jobs: Free Timed Practice Test | PracticeExcel"
"twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgVGVzdCBmb3IgRmluYW5jZSBKb2JzOiBGcmVlIFRpbWVkIFByYWN0aWNlIFRlc3Q%2Cdescription_~UHJhY3RpY2UgdGhlIEV4Y2VsIHRlc3QgZm9yIGZpbmFuY2Ugcm9sZXMgd2l0aCAyMCB0aW1lZCB0YXNrcyBpbiBhIGxpdmUgZ3JpZC4gTWFyZ2lucywgWVRELCBTVU1JRlMsIFBNVCwgTlBWLCBJUlIgYW5kIGxvb2t1cHMsIHNjb3JlZCBpbnN0YW50bHku%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIkxpbmUiLCJBbW91bnQiLCJHcm9zcyBtYXJnaW4iXX0seyJuIjoyLCJjZWxscyI6WyJSZXZlbnVlIiwiMTg0MDAwMCIsIiJdfSx7Im4iOjMsImNlbGxzIjpbIkNvc3Qgb2YgZ29vZHMgc29sZCIsIjExOTYwMDAiLCIiXX0seyJuIjo0LCJjZWxscyI6WyJPdGhlciBleHRlcm5hbCBjb3N0cyIsIjMxMjAwMCIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIlN0YWZmIGNvc3RzIiwiMjQ1MDAwIiwiIl19XSwidGFyZ2V0IjpbMSwyXX19%2Cp_Ii90ZXN0cy9leGNlbC10ZXN0LWZvci1maW5hbmNlIg%2Cs_72Jg8HiOTtvkFsXa.png"
---
> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)
# **Excel test for finance jobs**
Financial analysts, controllers and finance assistants are often given an Excel task before the interview. This practice test has 20 tasks from finance work, from gross margin, debtor days and year-to-date totals to a loan payment, NPV, IRR and lookups in a report, in a live grid with a 30-minute clock.
20 questions · 30 minutes · passing score 70%
=
30:0070 %
**Question 1 of 20**
In D2, calculate the gross margin as a decimal: revenue minus the cost of goods sold, divided by revenue (0.25 is 25%).
D2fx
| | A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | Line | Amount | | Gross margin | | |
| 2 | Revenue | 1840000 | | | | |
| 3 | Cost of goods sold | 1196000 | | | | |
| 4 | Other external costs | 312000 | | | | |
| 5 | Staff costs | 245000 | | | | |
| 6 | | | | | | |
| 7 | | | | | | |
| 8 | | | | | | |
No tips during the test. I'm back with help when the clock stops.
The free preview is the first 10 questions in 15 minutes. It isn't saved.
[**Unlock the full test from $19/month**](https://practiceexcelonline.com/pricing) [**Already premium? Sign in**](https://practiceexcelonline.com/login?next=/tests/excel-test-for-finance)
Premium gets you the full 20-question test, your score history and a certificate when you pass.
## **What finance employers test**
A finance Excel test checks that you can turn a table of figures into the numbers a manager asks for, quickly and without mistakes. Expect margins and growth rates, shares of a total, totals for one period or one region with SUMIF and SUMIFS, and pulling a figure out of a report with VLOOKUP or INDEX and MATCH.
Many finance tests add a few questions on the time value of money: the payment on a loan with PMT, the net present value of an investment with NPV and its internal rate of return with IRR. The classic mistake is putting the year 0 investment inside NPV, which discounts it a year too far.
## **How this practice test works**
You have 30 minutes for 20 questions. Each question has its own small sheet, written for this test only: an income statement, monthly actuals, a rate table or a project's cash flows. Click the answer cell, type your formula and press Enter, as in Excel.
Nothing is marked until you hand in. Every answer has to be a formula that still gives the right result when the figures change, so a typed number does not count. Afterwards you see your score, every question you missed and where to practice it.
## **How to prepare**
Take the free preview of the first 10 questions to see where you stand. If percentages trip you up, remember that a share is always the part divided by the whole, and a change is new divided by old, minus 1. Then practice conditional sums and lookups, which make up most of the test, before you take the full test against the clock.
## **What the test covers**
Each question practices one of these skills. Follow a link to practice it before you start.
1. [**1****Gross margin from the income statement**](https://practiceexcelonline.com/practice/first-formulas/multiply-two-cells)
2. [**2****Growth from last year**](https://practiceexcelonline.com/practice/first-formulas/multiply-two-cells)
3. [**3****Debtor days from the accounts**](https://practiceexcelonline.com/practice/round/round-two-decimals)
4. [**4****One region's share of the total**](https://practiceexcelonline.com/practice/sum/sum-a-column)
5. [**5****Quarter from an invoice date**](https://practiceexcelonline.com/practice/dates/month-from-date)
6. [**6****Year to date up to a chosen month**](https://practiceexcelonline.com/practice/sumif/sumif-criteria-from-a-cell)
7. [**7****One category's share of costs**](https://practiceexcelonline.com/practice/sumif/sumif-with-sum-range)
8. [**8****Convert currency with rates per 100 units**](https://practiceexcelonline.com/practice/vlookup/vlookup-exact-match)
9. [**9****Monthly payment on a loan with PMT**](https://practiceexcelonline.com/functions/pmt)
10. [**10****Over or under budget for the half year**](https://practiceexcelonline.com/practice/sum/sum-separate-ranges)
11. [**11****Full-year forecast from the months so far**](https://practiceexcelonline.com/practice/average/average-blank-cells)
12. [**12****Sales for one region in one quarter**](https://practiceexcelonline.com/practice/sumifs/sumifs-two-conditions)
13. [**13****Price per unit without #DIV/0!**](https://practiceexcelonline.com/practice/iferror/iferror-vlookup)
14. [**14****Revenue from units and prices**](https://practiceexcelonline.com/functions/sumproduct)
15. [**15****Weighted average purchase price**](https://practiceexcelonline.com/functions/sumproduct)
16. [**16****Internal rate of return for a project**](https://practiceexcelonline.com/functions/irr)
17. [**17****Average annual growth (CAGR)**](https://practiceexcelonline.com/practice/first-formulas/multiply-two-cells)
18. [**18****Net present value of an investment**](https://practiceexcelonline.com/functions/npv)
19. [**19****VLOOKUP with the column found by MATCH**](https://practiceexcelonline.com/functions/match)
20. [**20****Two-way lookup: product and month**](https://practiceexcelonline.com/practice/index-match/index-match)
## **Questions**
### What Excel skills do finance jobs need?
Percentages and growth rates, conditional sums with SUMIF and SUMIFS, lookups with VLOOKUP or INDEX and MATCH, rounding, and the financial functions PMT, NPV and IRR. This practice test covers all of them.
### Do finance Excel tests include NPV and IRR?
Often, for analyst and controller roles. Expect at least one question on the value of future cash flows, so know how NPV treats the payment in year 0.
### How long is this practice test?
30 minutes for 20 questions. The free preview has the first 10 questions in 15 minutes.
### What score should I aim for?
The passing score here is 70%, 14 of 20. Aim for 80% or more before the real test.
### Do I get a certificate?
Yes. Pass the full test with a verified email and you get a certificate with a public link for your résumé or LinkedIn.
## **Other Excel tests**
- [**Indeed Excel assessment practice test**](https://practiceexcelonline.com/tests/indeed-excel-assessment)
- [**Excel test for job interviews**](https://practiceexcelonline.com/tests/excel-test-for-job-interview)
- [**Kenexa Excel test practice**](https://practiceexcelonline.com/tests/kenexa-excel-test)
- [**SHL Excel test practice**](https://practiceexcelonline.com/tests/shl-excel-test)
- [**iMocha Excel test practice**](https://practiceexcelonline.com/tests/imocha-excel-test)
- [**TestGorilla Excel test practice**](https://practiceexcelonline.com/tests/testgorilla-excel-test)
- [**Excel test for accounting and bookkeeping**](https://practiceexcelonline.com/tests/excel-test-for-accountants)
- [**Excel test for budgeting and planning**](https://practiceexcelonline.com/tests/excel-test-for-budgeting)
- [**Excel test for admin jobs**](https://practiceexcelonline.com/tests/excel-test-for-admin-jobs)
- [**Excel test for data analysts**](https://practiceexcelonline.com/tests/excel-test-for-data-analysts)
```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-finance#webpage","description":"Practice the Excel test for finance roles with 20 timed tasks in a live grid. Margins, YTD, SUMIFS, PMT, NPV, IRR and lookups, scored instantly.","name":"Excel Test for Finance Jobs: Free Timed Practice Test","url":"https://practiceexcelonline.com/tests/excel-test-for-finance","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/tests/excel-test-for-finance#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/tests/excel-test-for-finance#/schema/question/1"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-finance#/schema/question/2"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-finance#/schema/question/3"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-finance#/schema/question/4"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-finance#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/tests/excel-test-for-finance"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-finance#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel tests for job applications","item":"https://practiceexcelonline.com/tests","position":2},{"@type":"ListItem","name":"Excel Test for Finance Jobs: Free Timed Practice Test","position":3}]},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-finance#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What Excel skills do finance jobs need?","acceptedAnswer":{"@type":"Answer","text":"Percentages and growth rates, conditional sums with SUMIF and SUMIFS, lookups with VLOOKUP or INDEX and MATCH, rounding, and the financial functions PMT, NPV and IRR. This practice test covers all of them."}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-finance#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Do finance Excel tests include NPV and IRR?","acceptedAnswer":{"@type":"Answer","text":"Often, for analyst and controller roles. Expect at least one question on the value of future cash flows, so know how NPV treats the payment in year 0."}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-finance#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How long is this practice test?","acceptedAnswer":{"@type":"Answer","text":"30 minutes for 20 questions. The free preview has the first 10 questions in 15 minutes."}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-finance#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"What score should I aim for?","acceptedAnswer":{"@type":"Answer","text":"The passing score here is 70%, 14 of 20. Aim for 80% or more before the real test."}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-finance#/schema/question/5","@type":"Question","inLanguage":"en-US","name":"Do I get a certificate?","acceptedAnswer":{"@type":"Answer","text":"Yes. Pass the full test with a verified email and you get a certificate with a public link for your résumé or LinkedIn."}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-finance#/schema/course/1","@type":"Course","description":"Financial analysts, controllers and finance assistants are often given an Excel task before the interview. This practice test has 20 tasks from finance work, from gross margin, debtor days and year-to-date totals to a loan payment, NPV, IRR and lookups in a report, in a live grid with a 30-minute clock.","educationalLevel":"Intermediate","inLanguage":"en-US","name":"Excel test for finance jobs","teaches":"FIRST-FORMULAS, ROUND, SUM, DATES-BASICS, SUMIF, VLOOKUP, PMT, AVERAGE, SUMIFS, IFERROR, SUMPRODUCT, IRR, NPV, MATCH, INDEX-MATCH","timeRequired":"PT30M","provider":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```
## Sitemap
See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.