Computer Specialist in Spreadsheet & Database Level 1
More study resources
Cheat sheet
Keep the key ideas within reach.
ExploreKey terms
Get comfortable with the vocabulary.
ExploreStudy plan
Give each week a clear focus.
ExploreCommon mistakes
Understand the traps and how to avoid them.
ExploreCase studies
Put your knowledge to work in context.
ExploreExam-day guide
Prepare for the day ahead.
ExploreAbout this exam
The Computer Specialist in Spreadsheet & Database Level 1 credential is an entry-level certification for candidates who need to prove they can work productively in a spreadsheet application and understand the basics of a relational database. It suits office administrators, data-entry and reporting staff, students entering business or IT programs, and career changers who want a verifiable marker of practical skill rather than a purely academic qualification. The exam is split between spreadsheet work and database work. On the spreadsheet side, expect the interface and workbook handling, data entry and formatting, worksheet management, formulas and functions with relative and absolute references, charts and tables, and what-if analysis. On the database side, expect relational concepts such as tables, keys and relationships, database objects and SQL queries, plus importing, exporting and validating data between the two tools. Preparation works best as hands-on practice: build a small multi-sheet workbook with lookups and a chart, then build a small database from the same data, write SELECT queries against it, and export a result back into a spreadsheet. Multiple-choice items test terminology and syntax; performance tasks test whether you can actually complete the operation. The certifying body publishes current details on format, scheduling, fees and scoring on its official website, so confirm those there before booking.
What you'll study
About Computer Specialist in Spreadsheet & Database Level 1 preparation
What is the exam format?
It combines multiple-choice questions with performance-based tasks completed in a spreadsheet application and a database tool. The multiple-choice portion checks terminology, function behavior and SQL syntax; the performance portion asks you to produce a working result, such as a formatted sheet, a correct formula or a query that returns the right rows.
How long is the exam and how many questions are there?
Those figures are set by the certifying body and change between delivery versions, so this page does not quote them. Check the official exam description or your booking confirmation for the current item count and time allowance, and practice with a timer so pacing is not a surprise on the day.
How hard is Level 1?
It is an entry-level exam, so the difficulty comes from breadth and precision rather than advanced techniques. Candidates usually lose marks on reference types in copied formulas, join conditions in queries, and formatting details. If you can complete routine spreadsheet and database tasks without looking up steps, you are probably ready.
Do I need prior work experience?
No formal experience is required, but familiarity helps. A few weeks of deliberate practice building workbooks and simple databases is usually enough for a motivated beginner. If you have never written a formula with absolute references or a SELECT statement with a WHERE clause, start there before attempting practice tests.
What should I study first?
Start with spreadsheet fundamentals and formulas, because functions, charts and what-if tools all depend on solid cell referencing. Then move to database concepts and SQL, and finish with data integration, where you import a file, validate it and export results. This order matches how the domains build on each other.
What are the most common failure points?
Mixing relative and absolute references so formulas break when filled; confusing COUNT, COUNTA and COUNTIF; forgetting that text values in SQL need quotes; writing a join without a matching key; and ignoring the exact formatting or output the task requests. Read each task twice and verify the result rather than assuming it worked.
Can I retake the exam if I fail?
Retake rules, waiting periods and any additional fees are set by the certifying body and are not fixed across all delivery channels. Check the official policy page or your candidate handbook before scheduling a second attempt, and use the score report to identify which domains to revisit.
How long is the certification valid?
Validity periods depend on the certifying organization and the version of the exam you pass. Consult the official website for the current recertification or renewal requirement, and keep a copy of your score report and certificate in case an employer asks you to verify the credential.
How should I prepare in the final week?
Do timed practice under exam conditions, then review every mistake by redoing the task from scratch. Build one small project end to end: a workbook with lookups and a chart, a matching database, a query, and an export back to the spreadsheet. That single exercise touches nearly every domain.