---
title: "Excel Test for Admin Jobs: Free Timed Practice Test | PracticeExcel"
description: "Practice the Excel test for admin and office jobs with 20 timed tasks. Counting, text clean-up, WORKDAY, EDATE, COUNTIFS and VLOOKUP, scored instantly."
canonical_url: "https://practiceexcelonline.com/tests/excel-test-for-admin-jobs"
locale: en
meta:
"og:description": "Practice the Excel test for admin and office jobs with 20 timed tasks. Counting, text clean-up, WORKDAY, EDATE, COUNTIFS and VLOOKUP, scored instantly."
"og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgVGVzdCBmb3IgQWRtaW4gSm9iczogRnJlZSBUaW1lZCBQcmFjdGljZSBUZXN0%2Cdescription_~UHJhY3RpY2UgdGhlIEV4Y2VsIHRlc3QgZm9yIGFkbWluIGFuZCBvZmZpY2Ugam9icyB3aXRoIDIwIHRpbWVkIHRhc2tzLiBDb3VudGluZywgdGV4dCBjbGVhbi11cCwgV09SS0RBWSwgRURBVEUsIENPVU5USUZTIGFuZCBWTE9PS1VQLCBzY29yZWQgaW5zdGFudGx5Lg%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIk5hbWUiLCJTZXNzaW9uIiwiU2lnbmVkIHVwIl19LHsibiI6MiwiY2VsbHMiOlsiU29maWUiLCJNb3JuaW5nIiwiIl19LHsibiI6MywiY2VsbHMiOlsiSm9uYXMiLCJBZnRlcm5vb24iLCIiXX0seyJuIjo0LCJjZWxscyI6WyIiLCIiLCIiXX0seyJuIjo1LCJjZWxscyI6WyJGcmVqYSIsIk1vcm5pbmciLCIiXX0seyJuIjo2LCJjZWxscyI6WyJPc2NhciIsIk1vcm5pbmciLCIiXX1dLCJ0YXJnZXQiOlsxLDJdfX0%2Cp_Ii90ZXN0cy9leGNlbC10ZXN0LWZvci1hZG1pbi1qb2JzIg%2Cs_m-WjW1EpNKfgZdKB.png"
"og:image:height": "600"
"og:image:type": image/png
"og:image:width": "1200"
"og:title": "Excel Test for Admin Jobs: Free Timed Practice Test | PracticeExcel"
"twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgVGVzdCBmb3IgQWRtaW4gSm9iczogRnJlZSBUaW1lZCBQcmFjdGljZSBUZXN0%2Cdescription_~UHJhY3RpY2UgdGhlIEV4Y2VsIHRlc3QgZm9yIGFkbWluIGFuZCBvZmZpY2Ugam9icyB3aXRoIDIwIHRpbWVkIHRhc2tzLiBDb3VudGluZywgdGV4dCBjbGVhbi11cCwgV09SS0RBWSwgRURBVEUsIENPVU5USUZTIGFuZCBWTE9PS1VQLCBzY29yZWQgaW5zdGFudGx5Lg%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIk5hbWUiLCJTZXNzaW9uIiwiU2lnbmVkIHVwIl19LHsibiI6MiwiY2VsbHMiOlsiU29maWUiLCJNb3JuaW5nIiwiIl19LHsibiI6MywiY2VsbHMiOlsiSm9uYXMiLCJBZnRlcm5vb24iLCIiXX0seyJuIjo0LCJjZWxscyI6WyIiLCIiLCIiXX0seyJuIjo1LCJjZWxscyI6WyJGcmVqYSIsIk1vcm5pbmciLCIiXX0seyJuIjo2LCJjZWxscyI6WyJPc2NhciIsIk1vcm5pbmciLCIiXX1dLCJ0YXJnZXQiOlsxLDJdfX0%2Cp_Ii90ZXN0cy9leGNlbC10ZXN0LWZvci1hZG1pbi1qb2JzIg%2Cs_m-WjW1EpNKfgZdKB.png"
---
> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)
# **Excel test for admin jobs**
Administrative assistants, office coordinators, HR assistants and secretaries keep lists of people, dates and bookings in Excel, and the Excel test for those jobs reflects that. This practice test has 20 office tasks, from tidying names and phone numbers to deadlines in working days, absence, mileage and notice periods, in a live grid with a 30-minute clock.
20 questions · 30 minutes · passing score 70%
=
30:0070 %
**Question 1 of 20**
The list has a few empty rows. In D2, use COUNTA to count how many names there are in A2:A10.
D2fx
| | A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | Name | Session | | Signed up | | |
| 2 | Sofie | Morning | | | | |
| 3 | Jonas | Afternoon | | | | |
| 4 | | | | | | |
| 5 | Freja | Morning | | | | |
| 6 | Oscar | Morning | | | | |
| 7 | | | | | | |
| 8 | Ida | Afternoon | | | | |
| 9 | Victor | Afternoon | | | | |
| 10 | Clara | Morning | | | | |
| 11 | | | | | | |
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-admin-jobs)
Premium gets you the full 20-question test, your score history and a certificate when you pass.
## **What admin employers test**
An Excel test for an admin job checks that you can keep a list in order and answer questions about it. Expect counts with COUNTA, COUNTBLANK and COUNTIFS, text clean-up with TRIM, PROPER, LEFT and FIND, names joined and split, and lookups of a department or a code with VLOOKUP.
Dates come up often: a deadline counted in working days around public holidays with WORKDAY, a 25-year anniversary with EDATE, a week number and the birthdays in a month. The trap with week numbers is WEEKNUM, which starts weeks on Sunday; ISOWEEKNUM gives the week numbers used in European calendars.
## **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 staff list, an absence log, mileage claims or an export from the HR system. 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 keeps working when the list changes, so typing the answer 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. Then practice the text functions and the date functions, which together make up most of this test. The Indeed practice test is a good warm-up if SUM, COUNT and IF are new to you.
## **What the test covers**
Each question practices one of these skills. Follow a link to practice it before you start.
1. [**1****Count the sign-ups**](https://practiceexcelonline.com/practice/count/counta-non-empty-cells)
2. [**2****Date of a 25-year work anniversary**](https://practiceexcelonline.com/practice/edate-eomonth/edate-add-months)
3. [**3****Tidy up a badly typed name**](https://practiceexcelonline.com/functions/proper)
4. [**4****Count the missing phone numbers**](https://practiceexcelonline.com/practice/count/countblank-empty-cells)
5. [**5****Three-letter initials for a staff list**](https://practiceexcelonline.com/practice/left-right-mid/left-first-characters)
6. [**6****Reply deadline in working days**](https://practiceexcelonline.com/practice/networkdays-workday/workday-delivery-date)
7. [**7****Join first and last name**](https://practiceexcelonline.com/functions/concat)
8. [**8****Sick days for one employee**](https://practiceexcelonline.com/practice/countifs/countifs-two-conditions)
9. [**9****Phone numbers in pairs of digits**](https://practiceexcelonline.com/functions/text)
10. [**10****Overtime hours over 37**](https://practiceexcelonline.com/practice/minmax/max-function)
11. [**11****Week number the European way**](https://practiceexcelonline.com/practice/networkdays-workday/weekday-day-of-week)
12. [**12****First name from a full name**](https://practiceexcelonline.com/functions/left)
13. [**13****Remove the separators from a phone number**](https://practiceexcelonline.com/functions/substitute)
14. [**14****Domain from an email address**](https://practiceexcelonline.com/functions/find)
15. [**15****Count full-time staff in one department**](https://practiceexcelonline.com/practice/countifs/countifs-two-conditions)
16. [**16****Mileage allowance for one employee**](https://practiceexcelonline.com/practice/sumif/sumif-criteria-from-a-cell)
17. [**17****Look up a department by employee ID**](https://practiceexcelonline.com/practice/vlookup/vlookup-number-id)
18. [**18****Turn "Last, First" into "First Last"**](https://practiceexcelonline.com/practice/substitute-textbefore-textafter/textafter-flip-names)
19. [**19****Birthdays in a given month**](https://practiceexcelonline.com/practice/dates/month-from-date)
20. [**20****Notice period from length of service**](https://practiceexcelonline.com/practice/vlookup/vlookup-approximate-match)
## **Questions**
### What Excel skills do admin jobs need?
Counting with COUNTA, COUNTBLANK and COUNTIFS, text clean-up with TRIM, PROPER, LEFT and FIND, joining names, date formulas such as WORKDAY and EDATE, and VLOOKUP. This practice test covers all of them.
### Is an admin Excel test hard?
It is usually easier than a finance test, but it is timed and checks details like extra spaces, the right week number and holidays in a deadline. Practicing against the clock makes the difference.
### 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.
## **Read the guide**
- [**Excel IF formulas: from one condition to many**](https://practiceexcelonline.com/learn/excel-if-function)
- [**Dates in Excel: how they work and the formulas you need**](https://practiceexcelonline.com/learn/excel-dates)
- [**How to clean data in Excel with formulas**](https://practiceexcelonline.com/learn/clean-data-in-excel)
## **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 budgeting and planning**](https://practiceexcelonline.com/tests/excel-test-for-budgeting)
- [**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-admin-jobs#webpage","description":"Practice the Excel test for admin and office jobs with 20 timed tasks. Counting, text clean-up, WORKDAY, EDATE, COUNTIFS and VLOOKUP, scored instantly.","name":"Excel Test for Admin Jobs: Free Timed Practice Test","url":"https://practiceexcelonline.com/tests/excel-test-for-admin-jobs","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/tests/excel-test-for-admin-jobs#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/tests/excel-test-for-admin-jobs#/schema/question/1"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-admin-jobs#/schema/question/2"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-admin-jobs#/schema/question/3"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-admin-jobs#/schema/question/4"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-admin-jobs#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/tests/excel-test-for-admin-jobs"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-admin-jobs#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 Admin Jobs: Free Timed Practice Test","position":3}]},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-admin-jobs#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What Excel skills do admin jobs need?","acceptedAnswer":{"@type":"Answer","text":"Counting with COUNTA, COUNTBLANK and COUNTIFS, text clean-up with TRIM, PROPER, LEFT and FIND, joining names, date formulas such as WORKDAY and EDATE, and VLOOKUP. This practice test covers all of them."}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-admin-jobs#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Is an admin Excel test hard?","acceptedAnswer":{"@type":"Answer","text":"It is usually easier than a finance test, but it is timed and checks details like extra spaces, the right week number and holidays in a deadline. Practicing against the clock makes the difference."}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-admin-jobs#/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-admin-jobs#/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-admin-jobs#/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-admin-jobs#/schema/course/1","@type":"Course","description":"Administrative assistants, office coordinators, HR assistants and secretaries keep lists of people, dates and bookings in Excel, and the Excel test for those jobs reflects that. This practice test has 20 office tasks, from tidying names and phone numbers to deadlines in working days, absence, mileage and notice periods, in a live grid with a 30-minute clock.","educationalLevel":"Intermediate","inLanguage":"en-US","name":"Excel test for admin jobs","teaches":"COUNT, DATES-MONTHS, PROPER, TEXT-EXTRACT, DATES-WORKDAYS, CONCAT, COUNTIFS, TEXT, MINMAX, LEFT, SUBSTITUTE, FIND, SUMIF, VLOOKUP, TEXT-SPLIT, DATES-BASICS","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.