Computer Specialist in Spreadsheet Level 2 study plan

Build a one-page reference of operator precedence (arithmetic, comparison, concatenation, reference operators) and verify each rule with a test formula

Write 15 formulas that mix relative, absolute ($A$1), and mixed (A$1, $A1) references, then predict the result before pressing Enter

Convert 10 values between percentages, decimals, and text using arithmetic and the TEXT function

Diagnose and fix 8 broken formulas covering #DIV/0!, #VALUE!, #REF!, and circular-reference errors

Apply SUM, AVERAGE, MIN, MAX, and COUNT to 10 ranges and state which one fits each business question

Write 12 conditional formulas using IF, nested IF, AND, OR, and IFERROR

Use SUMIF, COUNTIF, AVERAGEIF, and their multi-criteria SUMIFS/COUNTIFS variants on a 50-row sales table

Look up values with VLOOKUP, INDEX/MATCH, and XLOOKUP, and explain the failure mode of each when data moves or is unsorted

Sort a 100-row table by two levels, then restore original order using a helper index column

Apply AutoFilter and custom filters (text contains, date between, number top 10) to isolate 5 defined record sets

Build 6 criteria ranges for Advanced Filter, including one with OR logic across columns and one with a computed criterion

Remove duplicates and use Subtotal with outline grouping to summarize a filtered list

Enter and edit data using AutoFill, Flash Fill, and custom series across 30 rows

Apply data validation (list, whole number, date, custom formula) to 4 columns and test each rule with valid and invalid input

Use Text to Columns to split a combined field, then rejoin it with CONCAT or TEXTJOIN

Clean a messy 40-row import by trimming spaces, fixing case, and converting text-stored numbers

Apply number formats (currency, accounting, percentage, custom) to a sample sheet and predict display versus stored value

Configure conditional formatting with 4 rule types, including a formula-based rule

Build a print-ready sheet with margins, orientation, print area, print titles, headers/footers, and page breaks

Apply cell styles, borders, and merged-cell alternatives to produce a readable report layout

Create a PivotTable from a 200-row dataset and summarize values by two row fields and one column field

Add a calculated field and a % of total value display to the PivotTable

Group date data by month and quarter, then insert a slicer and a timeline

Build a PivotChart and refresh both after adding 10 new source rows

Create column, line, pie, and bar charts from the same data and justify which chart type fits each question

Add axis titles, data labels, a secondary axis, and a trendline to a combo chart

Insert and format a shape, text box, and image, and set their positioning relative to cells

Customize the ribbon Quick Access Toolbar and demonstrate 5 keyboard shortcuts for navigation and selection

Insert, rename, move, group, and hide worksheets, and protect a sheet while leaving input cells unlocked

Consolidate data from 3 worksheets and create linked formulas across sheets

Set workbook properties, check compatibility, and export to PDF and CSV

Run a timed 40-question mixed practice set and review every missed item to its source domain