Cellwise Start free

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.

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
Every task in the Office and admin preset, by level and workbook
LevelPasted contact listSales log
BasicClean up names
Lowercase emails
Email domain
Gmail addresses
Revenue per order
Total units
Average order size
Orders from East
IntermediateFirst names
Last names
Full names
Phone digits only
Commission per order
Revenue for one region
Desk lamps in that region
Large orders
AdvancedLast 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

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.

RowABCDEFGHI
1Name (as pasted)EmailPhoneLast nameInitialsDuplicate?
2 maya CHEN[email protected](555) 014-2290Unique email addresses
3luis antonio ortiz[email protected]555-014-7731
4PRIYA nair [email protected]555 014 3384
5 sam OKAFOR[email protected](555) 014-9012
6dana marie whitfield[email protected]555-014-5547
7jordan LEE[email protected]555 014 6620
8ana maria lopez [email protected](555) 014-1185
9BEN carter[email protected]555-014-8843
10 grace kim[email protected]555 014 2671
11omar haddad[email protected](555) 014-3309
Answers to the sample task, what each returns on the visible sheet, and the hidden checks
Formula in I2Sheet they seeHidden checksResult
=ROWS(UNIQUE(LOWER(B2:B11)))UNIQUE of the lowercased emails 8 right Right on bothSolved
=SUMPRODUCT(1/COUNTIF(B2:B11,B2:B11))The classic SUMPRODUCT and COUNTIF count 8 right Right on bothSolved
=COUNTA(B2:B11)Every row 10 wrongNot needed: already wrongNot 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:

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

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)

Create a free marketing coordinator testCompare plans

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.