Computer Specialist in Spreadsheet Level 2 study guide
Computer Specialist in Spreadsheet Level 2 · Work through your exam, one topic at a time.
The Computer Specialist in Spreadsheet Level 2 credential certifies practical spreadsheet skills beyond the basics: building formulas, managing data, formatting output, creating charts, and collaborating on workbooks. It suits office professionals, students, and anyone who uses spreadsheets daily and wants a structured way to prove intermediate competence to employers. The Computer Specialist in Spreadsheet Level 2 study guide has 9 sections and about 3,351 words.
01Spreadsheet Fundamentals and Interface
The Fundamentals and Interface domain checks whether you can locate commands and read the object hierarchy of a spreadsheet application: workbook, worksheet, row, column, cell and range. Questions often describe a location or a keystroke and ask what appears on screen.
386 words, about 2 min02Workbook and Worksheet Management
Workbook and worksheet management tests the container level: creating and organizing sheets, controlling what the window shows, and saving in the right file format. Insert: use the plus button or Shift+F11; the new sheet is placed before the active sheet.
404 words, about 2 min03Data Entry and Cell Editing
This domain tests how values are entered, recognized and edited: data types, AutoFill, Flash Fill, Paste Special, Find and Replace, and validation. Text aligns left by default, while numbers and dates align right.
371 words, about 2 min04Formulas and Functions
Formulas and Functions is the highest-weight area: operator precedence, reference types, function syntax and diagnosing error values. Every formula starts with = and evaluates by precedence: negation, percent, exponent, multiply/divide, add/subtract, concatenation (&), then comparisons.
346 words, about 2 min05Formatting and Page Setup
Formatting and Page Setup covers how values are displayed and how a sheet is prepared for output: number formats, cell styles, conditional formatting, alignment and page layout. The Format Cells dialog offers General, Number, Currency, Accounting, Date, Percentage, Fraction, Scientific, Text, Special and Custom.
384 words, about 2 min06Charts and Graphics
Charts and Graphics tests choosing an appropriate chart type, binding a chart to the right data, and controlling chart elements and embedded objects. Column and bar charts compare categories; line charts show trends over evenly spaced time; XY scatter plots numeric Y against numeric X and is the correct choice for correlation or scientific data; pie and doughnut show one series as parts of a whole; area emphasizes cumulative volume; combo charts pair a column and a line on dual axes; sparklines are tiny in-cell charts.
386 words, about 2 min07Data Management, Sorting, and Filtering
Data Management, Sorting, and Filtering tests turning a range into a structured table and reshaping or reordering large data sets safely. Ctrl+T converts a range into a table with a header row, banded rows and structured references such as Table1[Sales].
368 words, about 2 min08Data Analysis and PivotTables
Data Analysis and PivotTables covers summarizing large data interactively and the what-if tools used to test outcomes. Base the pivot on an Excel table or a well-formed range with unique headers and no blank rows.
368 words, about 2 min09Printing, Sharing, and Collaboration
Printing, Sharing and Collaboration tests getting output onto paper or PDF and letting others work on the file safely. Ctrl+P opens print view: choose active sheets, entire workbook or selection; set copies, collation, orientation, paper size, margins, scaling (Fit Sheet on One Page, Fit All Columns on One Page, or custom %) and print titles.
338 words, about 2 min