Cellwise Hire · Office and admin preset
Excel test for marketing coordinators
Candidates get a sign-up list ready for import: names and emails tidied, domains pulled out, Gmail addresses counted, duplicates flagged and the real number of contacts counted. Then they answer questions from a sales log. Every answer is checked by what it calculates, on the sheet they see and on hidden versions of it.
Create a free marketing coordinator testSee a sample task
Free for your first 3 candidates. The Office and admin preset is preselected for you.
The test at a glance
- Workbooks
- Pasted contact list + Sales log
- Tasks
- 8 hands-on tasks at the level you pick
- Levels
- Basic, Intermediate or Advanced
- Time
- You choose; 20 to 40 minutes suits most
- Grading
- By result, on the visible sheet and 2 hidden versions
Good for: Marketing coordinators and assistants, Marketing operations and CRM coordinators, Email marketing specialists, Event and community coordinators who manage sign-up lists.
What marketing coordinators actually do in Excel
Lists come in from everywhere: a webinar sign-up form, a trade-show scanner, an old spreadsheet from sales. Before any of it goes into the email platform or the CRM, someone makes it consistent, lowercases the emails, removes the people who signed up twice and works out how many real contacts there are.
Then come the questions about results: how many units of one product sold in a region, how many orders were large, which rep had the biggest order. A coordinator who answers with formulas that follow a cell can rerun the report after every campaign.
- Cleaning sign-up and event lists before an import
- Pulling the domain out of each email, and counting personal addresses such as Gmail
- Flagging duplicate sign-ups, and counting unique contacts for the real list size
- Totals and counts by region and product from a sales log, with criteria in cells
- Counting different products and finding the biggest order
What the test checks
The Office and admin preset uses two workbooks: Pasted contact list (contacts pasted in from a sign-up form export: inconsistent capitals, extra spaces and mixed phone formats) and Sales log (october orders: one row per order, with the rep, region, product, units and unit price). Here is what that covers for marketing coordinators, with the real task names and the level each one appears at.
List hygiene
Names trimmed and capitalized, emails in lowercase, and first and last names joined back as "First Last" for a personalized greeting.
- Clean up namesBasic
- Lowercase emailsBasic
- Full namesIntermediate
Domains and personal addresses
The domain after the @, in lowercase, and a count of Gmail addresses whatever the capitals. Separating personal addresses from company ones is often the first step in working out which sign-ups are businesses.
- Email domainBasic
- Gmail addressesBasic
The real list size
Sign-ups with the same email in different capitals, flagged, and the number of different addresses on the list. Advanced level.
- Flag duplicate emailsAdvanced
- Unique contactsAdvanced
Results by region and product
A COUNTIF by region, revenue for the region typed in a cell, units of one product in that region with SUMIFS, and orders of 10 units or more.
- Orders from EastBasic
- Revenue for one regionIntermediate
- Desk lamps in that regionIntermediate
- Large ordersIntermediate
Leaders and distinct counts
The rep with the biggest single order, how many different products sold, and a running total of revenue. Advanced level.
- Rep with the biggest orderAdvanced
- Different products soldAdvanced
- Running totalAdvanced
Every task in this test, by level
| Level | Pasted contact list | Sales log |
|---|---|---|
| Basic | Clean up names Lowercase emails Email domain Gmail addresses | Revenue per order Total units Average order size Orders from East |
| Intermediate | First names Last names Full names Phone digits only | Commission per order Revenue for one region Desk lamps in that region Large orders |
| Advanced | Last word as last name Initials Flag duplicate emails Unique contacts | Running total Rep with the biggest order Rep revenue since a date Different products sold |
Each test uses one level: four tasks from each workbook.
Which level to choose
- Basic · 20 minutes suggestedMarketing assistants: tidy names and emails, the email domain, a Gmail count, and quick totals and counts from a sales log.
- Intermediate · 30 minutes suggestedMarketing coordinators who prepare imports and reports: names split and joined, phone numbers reduced to digits, and totals by region and product with criteria in cells.
- Advanced · 40 minutes suggestedMarketing ops and CRM roles that own the list: duplicate sign-ups, unique contacts, the rep with the biggest order, distinct products and running totals.
A real task from this test
This is one of the tasks in the Office and admin preset at the Advanced level, on the sheet candidates see. The answers below were run through the same grader that marks real tests: on this sheet, and on two hidden versions with different data and an extra row inserted.
Sample task · Pasted contact list · Advanced
Unique contacts (in I2). Work out how many different people are on the list by email address, counting an address that appears in different capitals only once.
| Row | A | B | C | D | E | F | G | H | I |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Name (as pasted) | Phone | Last name | Initials | Duplicate? | ||||
| 2 | maya CHEN | [email protected] | (555) 014-2290 | Unique email addresses | |||||
| 3 | luis antonio ortiz | [email protected] | 555-014-7731 | ||||||
| 4 | PRIYA nair | [email protected] | 555 014 3384 | ||||||
| 5 | sam OKAFOR | [email protected] | (555) 014-9012 | ||||||
| 6 | dana marie whitfield | [email protected] | 555-014-5547 | ||||||
| 7 | jordan LEE | [email protected] | 555 014 6620 | ||||||
| 8 | ana maria lopez | [email protected] | (555) 014-1185 | ||||||
| 9 | BEN carter | [email protected] | 555-014-8843 | ||||||
| 10 | grace kim | [email protected] | 555 014 2671 | ||||||
| 11 | omar haddad | [email protected] | (555) 014-3309 |
| Formula in I2 | Sheet they see | Hidden checks | Result |
|---|---|---|---|
=ROWS(UNIQUE(LOWER(B2:B11)))UNIQUE of the lowercased emails | 8 right | Right on both | Solved |
=SUMPRODUCT(1/COUNTIF(B2:B11,B2:B11))The classic SUMPRODUCT and COUNTIF count | 8 right | Right on both | Solved |
=COUNTA(B2:B11)Every row | 10 wrong | Not needed: already wrong | Not solved |
=COUNTA(B2:B11)It counts sign-ups, not people, so every duplicate inflates the list size you report and anything worked out from it, such as cost per contact.
Grading is by result, so =COUNTA(UNIQUE(B2:B11)) passes too: like COUNTIF, UNIQUE ignores capitals. The hidden version has a different list with different duplicates, so a typed count fails there.
Results calculated by the Cellwise formula engine. The hidden versions stay on our server, so this page shows only whether each answer passed them.
See the screen your marketing coordinator candidates work in: try a 3-minute sample test and read the report you would get. No signup.
What the report shows
When a candidate finishes, you get an overall score and every task: solved or not, the exact formula they wrote, the time spent and the number of tries, plain-English notes, and a replay of every edit with the sheet as it looked at each step. For marketing coordinators, two things are worth a look:
- Look at the duplicate flag. A COUNTIF over the whole list, locked with $, flags both copies of a duplicate; one that only looks upward flags the second copy only. The formula shows which one the candidate wrote.
- On the domain task, the formula shows whether they took the domain from the lowercased email or from the original. Taken from the original, "Gmail.com" and "gmail.com" count as two different domains in any summary.
You can also add 8 multiple-choice knowledge questions at the same level, scored separately. Candidates never see their score.
What this test does not cover
- It does not test an email platform, a CRM, ad platforms, PivotTables or charts. If campaign reporting in a PivotTable is central to the role, check it in the interview.
- Campaign metrics such as conversion rates and cost per lead are not in the test. It is the same Office and admin preset as the Excel test for data entry clerks, described for marketing work.
Pricing
Free for your first 3 candidates, no card needed. Then Starter is $79 a month or $790 a year for 25 completed candidates a month, and Agency is $199 a month or $1,990 a year for unlimited candidates. Only candidates who complete a test count.
Founding price: locked for as long as you stay subscribed (first 10 customers)
FAQ
What Excel skills does a marketing coordinator need?
Cleaning lists with TRIM, PROPER and LOWER, pulling the domain out of an email, finding duplicates with COUNTIF and counting unique contacts, SUMIF and SUMIFS for results by region, product or campaign, COUNTIF for quick counts, and lookups to join one list to another. Formulas that point at an input cell let a report be rerun after every campaign.
Which level should I choose for a marketing role?
Basic suits marketing assistants. Intermediate suits most marketing coordinators. Choose Advanced for marketing ops and CRM roles that own the contact list, because the duplicate and unique-contact tasks only appear at that level.
Does it test campaign metrics or analytics tools?
No. It tests cleaning a list and summarizing a sales log with formulas. Analytics platforms, ad reporting and conversion-rate maths are worth a separate interview question.
How long should a marketing coordinator Excel test take?
Each test has 8 tasks across two workbooks. We suggest 20 minutes for Basic, 30 for Intermediate and 40 for Advanced, plus about 8 minutes if you add the optional knowledge-check questions. You can set anything from 5 to 120 minutes.
Is it fair to give marketing candidates an Excel test?
A short test that reflects the real work is a common part of hiring. Give every candidate the same test and time, follow local hiring law, and keep tests job-related.
Related
Looking to learn Excel yourself? Start the free Cellwise course.