Spreadsheet Practice

Marketing analyst Excel test: skills, sample task and prep plan

Marketing screens ask you to turn campaign exports into answers: growth between periods, conversion by channel, spend against results, and a ranked list of what worked. Expect clean-ups, lookups between tables and conditional averages.

What employers usually test

SkillFunctionsPractice
Growth and rates% changeLesson 4 Free
Results by channelSUMIFS, AVERAGEIFSLesson 8 Free
Joining tablesXLOOKUPLesson 13 Pro
Share of totalrunning totals, $Lesson 36 Pro
Ranking campaignsRANK, LARGELesson 34 Pro
Cleaning exportsTRIM, TEXTBEFORELesson 20 Pro

Take the marketing analyst timed test

Five tasks in a live grid, easiest first. Graded instantly, with a lesson for every gap.

  • 5 tasks in a live grid, easiest first. Graded the moment you submit
  • About 10 minutes. Skip anything you don't know
  • Your level and the exact lessons for your gaps, right away. No signup
  • Aced it? Keep going with a bonus round of harder, interview-style tasks

Try a sample task

From lesson 8, COUNTIFS, SUMIFS & AVERAGEIFS. Graded instantly.

Conditional average

In G7, average the revenue for the product in G3.

Your 14-day prep plan

About 30 minutes a day. Free lessons first; Pro lessons are marked.

Questions

Which skills matter most for a marketing analyst test?

Conditional totals and averages by channel, percentage change, and lookups that join an ad export to a budget table.

Will I need PivotTables or charts?

Often, yes. The free Data tools track covers both, and the formulas here help you check the pivot.

How long should I prepare?

Two weeks at about 30 minutes a day is enough for most screens.

Prep for other roles

Updated Checked by running: every exercise answer on this page was graded by our formula engine on .