Computer Specialist in Spreadsheet Level 2 case studies
Computer Specialist in Spreadsheet Level 2 · Put your knowledge to work in context.
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 case studies are 5 cases and about 4,208 words.
1The Bonus Model That Breaks on Fill-Down and Won't Reconcile
You maintain Q3 Bonus 2024.xlsx for a 40-person sales unit. Column A holds names, B department, C base salary, D performance score (0–100, one decimal), and E payout rate.
832 words, about 4 min2The PivotTable That Never Sees October
Sales data FY24.xlsx holds 24,318 order rows on sheet Data in A1:G24318: OrderDate, Region, Rep, Product, Units, UnitPrice, Revenue. You build a PivotTable on a new sheet with Region in Rows, Product in Columns, and Sum of Revenue in Values.
802 words, about 4 min3The Sort That Detached 600 Email Addresses
Vendor Contacts.xlsx contains 9,412 rows: A ContactID, B LastName, C FirstName, D Company, E Email, F SignupDate. Fourteen rows are visual section headers such as '- West Region -' created by merging A:B and typing the text; they sit inside the data.
805 words, about 4 min4The Board Pack That Prints Five Pages and Locks Out Reviewers
FY25 Budget Review.xlsx sits in a shared OneDrive folder with four reviewers. Sheet Summary holds 140 rows × 9 columns (A Item, B–G monthly amounts, H Total, I Notes).
897 words, about 4 min5The KPI Chart That Shows Zero for Missing Data
Monthly KPI.xlsx has month labels in A2:A13 typed as text ('Jan-25' etc.), Revenue in B2:B13 in whole dollars (values 1.2M–3.4M), and Margin % in C2:C13 as decimals 0.18–0.32. Two cells in B (May, June) were left empty and two (September, October) contain 'n/a' typed as text.
872 words, about 4 min