Computer Specialist in Spreadsheet & Database Level 1 study guide
Computer Specialist in Spreadsheet & Database Level 1 · Work through your exam, one topic at a time.
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 Computer Specialist in Spreadsheet & Database Level 1 study guide has 8 sections and about 3,280 words.
01Spreadsheet Fundamentals and Interface
This domain tests whether you can navigate a spreadsheet application confidently and understand how the file, the sheet, and the cell relate to one another. Questions typically ask you to identify what a UI element shows, predict the result of a navigation shortcut, or explain why a workbook behaves unexpectedly.
437 words, about 2 min02Data Entry, Formatting, and Worksheet Management
This domain checks that you can enter data so it is stored with the correct type, format it without altering the underlying value, and manage worksheets and ranges so the file stays usable and printable. Text aligns left by default and numbers align right.
409 words, about 2 min03Formulas, Functions, and References
This domain tests formula construction: operator precedence, reference types, function selection, error diagnosis, and how a formula behaves when copied. Expect questions that ask what a copied formula returns or which function measures a specific thing.
387 words, about 2 min04Charts, Tables, and Data Visualization
This domain tests whether you can choose a visualisation that fits the data, build it from the right range, and use table objects so ranges grow automatically instead of being redefined by hand. Column or bar charts compare discrete categories.
415 words, about 2 min05Data Analysis and What-If Tools
This domain tests summarising and exploring data: sorting and filtering correctly, subtotalling, building pivot tables, and using the what-if tools to answer questions about inputs you do not yet know. Sort works on the whole record set; sorting only one column destroys row integrity.
415 words, about 2 min06Database Fundamentals and Relational Concepts
This domain tests the theory behind relational storage: how tables, keys, and relationships are structured, why normalisation exists, and what integrity rules protect data quality. Questions often present a small schema and ask which key or relationship applies.
415 words, about 2 min07Database Objects, Queries, and SQL
This domain tests the vocabulary of database objects and your ability to read and predict the result of SQL statements, especially filtering, joining, and aggregation. Tables store rows; views are stored queries that present a virtual table without holding the data; indexes speed lookups at the cost of write time and storage; stored procedures and triggers hold server-side logic.
384 words, about 2 min08Data Integration, Import/Export, and Validation
This domain tests moving data in and out cleanly and stopping bad data at entry. Expect questions about delimiters, encoding, type inference during import, refreshable connections, and the limits of data validation.
418 words, about 2 min