--- title: "Excel Test for Budget Analysts: Free Timed Practice Test | PracticeExcel" description: "Practice the Excel test for budgeting and FP&A roles with 20 timed tasks. Variances, YTD, forecasts, SUMPRODUCT salary budgets and lookups." canonical_url: "https://practiceexcelonline.com/tests/excel-test-for-budgeting" locale: en meta: "og:description": "Practice the Excel test for budgeting and FP&A roles with 20 timed tasks. Variances, YTD, forecasts, SUMPRODUCT salary budgets and lookups." "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgVGVzdCBmb3IgQnVkZ2V0IEFuYWx5c3RzOiBGcmVlIFRpbWVkIFByYWN0aWNlIFRlc3Q%2Cdescription_~UHJhY3RpY2UgdGhlIEV4Y2VsIHRlc3QgZm9yIGJ1ZGdldGluZyBhbmQgRlAmQSByb2xlcyB3aXRoIDIwIHRpbWVkIHRhc2tzLiBWYXJpYW5jZXMsIFlURCwgZm9yZWNhc3RzLCBTVU1QUk9EVUNUIHNhbGFyeSBidWRnZXRzIGFuZCBsb29rdXBzLg%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJNb250aCIsIkJ1ZGdldCIsIkFjdHVhbCIsIkFjdHVhbCBtaW51cyBidWRnZXQiXX0seyJuIjoyLCJjZWxscyI6WyJKYW4iLCI1MDAwMCIsIjQ4MjAwIiwiIl19LHsibiI6MywiY2VsbHMiOlsiRmViIiwiNTAwMDAiLCI1MzEwMCIsIiJdfSx7Im4iOjQsImNlbGxzIjpbIk1hciIsIjU1MDAwIiwiNTQ2MDAiLCIiXX0seyJuIjo1LCJjZWxscyI6WyJBcHIiLCI1NTAwMCIsIjU4OTAwIiwiIl19LHsibiI6NiwiY2VsbHMiOlsiTWF5IiwiNjAwMDAiLCI1NzQwMCIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii90ZXN0cy9leGNlbC10ZXN0LWZvci1idWRnZXRpbmci%2Cs_Q8wWBvOTSyJuNwff.png" "og:image:height": "600" "og:image:type": image/png "og:image:width": "1200" "og:title": "Excel Test for Budget Analysts: Free Timed Practice Test | PracticeExcel" "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgVGVzdCBmb3IgQnVkZ2V0IEFuYWx5c3RzOiBGcmVlIFRpbWVkIFByYWN0aWNlIFRlc3Q%2Cdescription_~UHJhY3RpY2UgdGhlIEV4Y2VsIHRlc3QgZm9yIGJ1ZGdldGluZyBhbmQgRlAmQSByb2xlcyB3aXRoIDIwIHRpbWVkIHRhc2tzLiBWYXJpYW5jZXMsIFlURCwgZm9yZWNhc3RzLCBTVU1QUk9EVUNUIHNhbGFyeSBidWRnZXRzIGFuZCBsb29rdXBzLg%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJNb250aCIsIkJ1ZGdldCIsIkFjdHVhbCIsIkFjdHVhbCBtaW51cyBidWRnZXQiXX0seyJuIjoyLCJjZWxscyI6WyJKYW4iLCI1MDAwMCIsIjQ4MjAwIiwiIl19LHsibiI6MywiY2VsbHMiOlsiRmViIiwiNTAwMDAiLCI1MzEwMCIsIiJdfSx7Im4iOjQsImNlbGxzIjpbIk1hciIsIjU1MDAwIiwiNTQ2MDAiLCIiXX0seyJuIjo1LCJjZWxscyI6WyJBcHIiLCI1NTAwMCIsIjU4OTAwIiwiIl19LHsibiI6NiwiY2VsbHMiOlsiTWF5IiwiNjAwMDAiLCI1NzQwMCIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii90ZXN0cy9leGNlbC10ZXN0LWZvci1idWRnZXRpbmci%2Cs_Q8wWBvOTSyJuNwff.png" --- > Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt) # **Excel test for budgeting and planning** Budget analysts, FP&A analysts and anyone who follows up on a budget work in Excel every day, and many employers test it before they hire. This practice test has 20 budgeting tasks, from variances and remaining budget to an inflation uplift, a salary budget from FTEs and a full-year forecast, in a live grid with a 30-minute clock. 20 questions · 30 minutes · passing score 70% = 30:0070 % **Question 1 of 20** In E2, calculate how far the actual total for the six months is above the budget total (a negative result means under budget). E2fx | | A | B | C | D | E | F | | --- | --- | --- | --- | --- | --- | --- | | 1 | Month | Budget | Actual | | Actual minus budget | | | 2 | Jan | 50000 | 48200 | | | | | 3 | Feb | 50000 | 53100 | | | | | 4 | Mar | 55000 | 54600 | | | | | 5 | Apr | 55000 | 58900 | | | | | 6 | May | 60000 | 57400 | | | | | 7 | Jun | 60000 | 61800 | | | | | 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-budgeting) Premium gets you the full 20-question test, your score history and a certificate when you pass. ## **What budget roles test** A budgeting Excel test checks the work of the planning cycle: building next year's budget from this year's, spreading it over the months, and following up on it as the actuals come in. Expect variances in amount and in percent, totals up to a chosen month with SUMIF, salary budgets with SUMPRODUCT, and status flags with nested IF. The questions that separate candidates are the forecast ones: the actuals so far plus the budget for the rest of the year, a quarter picked out by a number in a cell, and the department furthest over budget found without a helper column. ## **How this practice test works** You have 30 minutes for 20 questions. Each question has its own small sheet, written for this test only: a budget by department, monthly budget and actuals, seasonal weights or a list of positions. 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. Most misses on budget tests come from criteria built from a cell, like "<="&E2, so practice SUMIF and SUMIFS with the condition in a cell. Then 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****Over or under budget for the half year**](https://practiceexcelonline.com/practice/sum/sum-separate-ranges) 2. [**2****Budget left after spending and commitments**](https://practiceexcelonline.com/practice/sum/sum-separate-ranges) 3. [**3****Growth from last year**](https://practiceexcelonline.com/practice/first-formulas/multiply-two-cells) 4. [**4****Next year's budget uplifted for prices and wages**](https://practiceexcelonline.com/practice/round/round-nearest-hundred) 5. [**5****Year to date up to a chosen month**](https://practiceexcelonline.com/practice/sumif/sumif-criteria-from-a-cell) 6. [**6****Spread a year budget by season**](https://practiceexcelonline.com/practice/summary-tables/summary-table-share-of-total) 7. [**7****Variance in percent for one department**](https://practiceexcelonline.com/practice/vlookup/vlookup-exact-match) 8. [**8****One category's share of costs**](https://practiceexcelonline.com/practice/sumif/sumif-with-sum-range) 9. [**9****Traffic-light status for a budget**](https://practiceexcelonline.com/practice/if/nested-if) 10. [**10****Salary budget from FTEs**](https://practiceexcelonline.com/functions/sumproduct) 11. [**11****One region's share of the total**](https://practiceexcelonline.com/practice/sum/sum-a-column) 12. [**12****Labor cost for a week**](https://practiceexcelonline.com/practice/sum/sum-a-column) 13. [**13****Count the months above average**](https://practiceexcelonline.com/practice/countif/countif-criteria-from-a-cell) 14. [**14****Expected result for the year**](https://practiceexcelonline.com/practice/sumif/sumif-criteria-from-a-cell) 15. [**15****Budget for a chosen quarter**](https://practiceexcelonline.com/practice/sumifs/sumifs-criteria-from-cells) 16. [**16****Sales for one region in one quarter**](https://practiceexcelonline.com/practice/sumifs/sumifs-two-conditions) 17. [**17****Price per unit without #DIV/0!**](https://practiceexcelonline.com/practice/iferror/iferror-vlookup) 18. [**18****Count the departments over budget**](https://practiceexcelonline.com/functions/sumproduct) 19. [**19****Two-way lookup: product and month**](https://practiceexcelonline.com/practice/index-match/index-match) 20. [**20****Department with the largest overrun**](https://practiceexcelonline.com/practice/index-match/index-match) ## **Questions**
### What Excel skills do budget analysts need? Variances in amount and percent, SUMIF and SUMIFS with conditions from cells, SUMPRODUCT, rounding, nested IF for status flags, and lookups with VLOOKUP or INDEX and MATCH. This practice test covers all of them.
### How do I forecast the full year from the actuals so far? Add the actuals up to the last closed month to the budget for the months after it. With month numbers in a column, two SUMIF formulas with "<="&month and ">"&month do it in one cell.
### 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 finance jobs**](https://practiceexcelonline.com/tests/excel-test-for-finance) - [**Excel test for accounting and bookkeeping**](https://practiceexcelonline.com/tests/excel-test-for-accountants) - [**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-budgeting#webpage","description":"Practice the Excel test for budgeting and FP&A roles with 20 timed tasks. Variances, YTD, forecasts, SUMPRODUCT salary budgets and lookups.","name":"Excel Test for Budget Analysts: Free Timed Practice Test","url":"https://practiceexcelonline.com/tests/excel-test-for-budgeting","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/tests/excel-test-for-budgeting#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/tests/excel-test-for-budgeting#/schema/question/1"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-budgeting#/schema/question/2"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-budgeting#/schema/question/3"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-budgeting#/schema/question/4"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-budgeting#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/tests/excel-test-for-budgeting"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-budgeting#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 Budget Analysts: Free Timed Practice Test","position":3}]},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-budgeting#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What Excel skills do budget analysts need?","acceptedAnswer":{"@type":"Answer","text":"Variances in amount and percent, SUMIF and SUMIFS with conditions from cells, SUMPRODUCT, rounding, nested IF for status flags, and lookups with VLOOKUP or INDEX and MATCH. This practice test covers all of them."}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-budgeting#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I forecast the full year from the actuals so far?","acceptedAnswer":{"@type":"Answer","text":"Add the actuals up to the last closed month to the budget for the months after it. With month numbers in a column, two SUMIF formulas with \"\u003C=\"&month and \">\"&month do it in one cell."}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-budgeting#/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-budgeting#/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-budgeting#/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-budgeting#/schema/course/1","@type":"Course","description":"Budget analysts, FP&A analysts and anyone who follows up on a budget work in Excel every day, and many employers test it before they hire. This practice test has 20 budgeting tasks, from variances and remaining budget to an inflation uplift, a salary budget from FTEs and a full-year forecast, in a live grid with a 30-minute clock.","educationalLevel":"Intermediate","inLanguage":"en-US","name":"Excel test for budgeting and planning","teaches":"SUM, FIRST-FORMULAS, ROUND, SUMIF, SUMMARY-TABLES, VLOOKUP, IF, SUMPRODUCT, COUNTIF, SUMIFS, IFERROR, 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.