Spreadsheets and Data Analysis
Assesses practical use of Excel or Google Sheets to analyze data: lookups, conditional formulas, references, cleaning, pivot tables, charts and interpretation. Suited for administrative, finance, sales and operations roles.
Sample questions
Taken from the template itself. Questions with a recorded answer key are left out, so reading this page cannot help anyone pass the test.
As the candidate sees it
Spreadsheets and Data Analysis
- 1.Short text
Write the formula that sums the South region values for the month of March.
On the Sales sheet, column B holds the region, column C holds the month name and column D holds the sale amount. Answer with the complete formula, in Excel or Google Sheets syntax.
- 2.Long text
How would you investigate the South region revenue drop and present the result?
South region revenue fell 18% in Q2 2026 compared with Q1. You received a spreadsheet with 40,000 rows: date, order number, customer, salesperson, city, product, quantity, unit price, discount and sales channel. Describe the analysis steps (data checks, breakdowns, calculations and charts), which hypotheses you would test and how you would present the conclusion to leadership.
- Shown once you copy the template
- Shown once you copy the template
- Shown once you copy the template
6 more questions in the full template.
How this template was made, and what you can check
Are these the real questions?
Yes. The questions on this page are the questions a candidate gets. They are not samples written for the site: they come from the template itself, word for word.
Why are some questions missing from this page?
Any question with a recorded answer key is left out, so that reading this page cannot help anyone pass. The count of what is missing is shown; the questions themselves appear once you copy the template.
Which language does the candidate see?
Every template exists in English and Portuguese. The candidate answers in theirs and you read in yours.
Will this template work on my plan?
Question types are checked against your plan by the database itself, so a template never promises a type your plan cannot run. Building assessments and collecting answers is free; automatic scoring starts on the Starter plan.
Can I change the questions?
Once you copy it, the template is yours: change the wording, drop a question, add your own. None of this is fixed.
How fast can I send it?
Create a free account, copy the template and share the link. The candidate opens it in the browser, with nothing to install.
Use this template on your next opening
Copy the template, change what you want, send a link. Assessly marks each answer, scores it and explains the score.
What comes back to you
Short text
Write the formula that sums the South region values for the month of March.
Answer
Score
Why this score
The question is real. The answer and the score are drawn as an example of what a review looks like.