Spreadsheet & Data LiteracySort one column and ruin the sheet — 20 questions on the spreadsheet habits that keep data honest.
Spreadsheet & Data Literacy measures competent everyday data work: ranges and absolute references, IF, COUNT, COUNTIF and VLOOKUP semantics, format versus value, median versus mean under outliers, chart choice, truncated axes, CSV and duplicates. Twenty items in 22 minutes, two banded competencies.
The practical layer between raw numeracy and analytics tools
What does a SUM over a range actually add, and which function counts only the numeric entries? Three cells in a survey column hold the text N/A — what is the safest step before you average it? How does a CSV store data, and what is lost when a sheet is saved as one? Elsewhere the items turn on the classic disasters: sorting a single column and detaching it from its rows, a number formatted as a date, a mean dragged by one outlier where the median would have told the truth, a bar chart with an axis that starts at ninety, duplicates counted twice, kilograms added to grams.
The bank is original and follows international data-fluency screening conventions. Option lengths are parity-controlled, so the right answer is never the longest or the most technical-looking, and distractors are the beliefs that produce real spreadsheet errors — that formatting changes the value, that a lookup matches approximately by default, that the mean is always the fair summary. Every key has its reasoning stated in the explanation, written for the person who uses a spreadsheet rather than builds one, so the review is a short, targeted course in the habits you were missing.
The report scores Data Interpretation and Technology & Programming Logic separately, banded from Emerging to Exceptional with coaching interpretations. That split matters: some people read data well and fumble the tool, others know every function and misread the chart. The AI-written narrative says which you are. The question-by-question review explains all 20 items, and the growth plan orders the topic families — references and functions, data hygiene, summary statistics, charts — by how many marks each cost you.
What you walk away with
Data Interpretation covers whether you read the numbers and the chart correctly; Technology & Programming Logic covers whether you know what the spreadsheet is actually doing. Two banded bars show which side needs work — most people are stronger on one.
The review flags each classic error you fell for — the single-column sort, format mistaken for value, text in a numeric column, the truncated axis — with a plain explanation of what goes wrong downstream and the habit that prevents it.
Every item is explained for the person who uses the tool rather than programs it: what the function does, why the median resisted the outlier, what the CSV dropped. A miss becomes a habit corrected, not a definition memorised.
The AI-written narrative reads your misses across references and functions, data hygiene, summary statistics and charts, and the plan ranks what to fix first, then points to the data-interpretation tests as the next step once the fundamentals are Strong.
What comes back
Illustrative sample — your report is generated from your own responses.
Band edges at 40, 60 and 80. Each band carries its own coaching interpretation for that competency.
One number, one band, and a two-sentence summary of what the band means for you — then the breakdown that explains it.
Assembled from your lowest competencies, in order — not a generic checklist.
Built for
- Analysts, coordinators and operations staff who live in spreadsheets without being data specialists
- Candidates for finance-ops, HR-ops, marketing-ops and reporting roles with a data-skills screen
- Hiring managers who want to know whether a hire will corrupt the shared sheet in week one
- Professionals moving toward analytics tools who want to confirm the fundamentals underneath
One sorted column detached from its rows, and every report downstream is wrong.
Twenty items in 22 minutes, every spreadsheet habit explained for the person who uses the sheet.
Take free · full report ₹150 (incl. GST)
Frequently asked questions
Whether you can work competently with data in a spreadsheet: ranges and absolute references, what IF, COUNT, COUNTIF and lookup functions actually do, format versus value, text hiding in numeric columns, the single-column sort disaster, median versus mean under outliers, chart choice, truncated axes, CSV behaviour, duplicates and mixed units. Twenty items in 22 minutes, for analysts, coordinators and operations staff, and the managers hiring them.
No. Option lengths are parity-controlled and the most technical-looking option is often a distractor built from a belief that causes real spreadsheet errors. Each item has one keyed answer with its reasoning stated in the explanation. Answers roll into two banded competencies, Data Interpretation and Technology & Programming Logic, and an overall 0–100 score from Emerging to Exceptional. The bands describe where you stand today, not a cut-off.
Twenty-two minutes for 20 items in one sitting, on any device. The report is generated immediately: overall banded score, radar and banded bars for the two competencies with coaching interpretations, an AI-written narrative separating data sense from tool sense, strengths and development areas, a prioritised growth plan by topic family and a question-by-question review explaining all 20 items for spreadsheet users. Everything is included; nothing further to unlock.
Hiring managers use the two bands as a screen for reporting, ops and coordination roles where a shared sheet is the system of record, and the named disasters as interview prompts. Individuals fix the topic family the plan ranks first, retake to confirm, and then move on to the data-interpretation tests. Teams use it before rolling out a new reporting process to see who needs a refresher.
Yes. Spreadsheet functions, references, CSV behaviour, summary statistics and chart conventions are identical in every market and every major spreadsheet application, and no item depends on a regional tool or format. Bands describe performance rather than rank against a national group. The test is priced in INR and USD, with the live price shown on this page in your currency.
Numerical, verbal, logical, abstract, spatial, data and workplace-judgment banks — each an original item bank with every rule stated in the explanation, scored per competency and reported with a banded profile and a growth plan. Sit one, or build a battery from several.
See the aptitude catalogue →Methodology: Original AssessAll item bank on spreadsheet/data-handling literacy per international data-fluency screening conventions. Option lengths parity-controlled. Not affiliated with any third-party instrument.