Topic Overview & Study Guide
Sukkur IBA STS BPS 05–15 and government ministerial jobs dedicate up to 20% of exam papers to Computer Knowledge. Our guide focuses on practical MS Office shortcuts, Excel formulas, and hardware basics.
Granular Topic Clusters (Spokes)
Spoke Module 1 (20 Questions)
MS Office & Shortcut Keys MCQs
High-frequency MS Word, Excel, and PowerPoint shortcuts with cheat sheet.
Start Topic Practice →Syllabus Breakdown & Weightage
MS Word & Text Formatting
30%Keyboard shortcuts, mail merge, macros, alignment, and formatting options.
MS Excel & Formulas
40%VLOOKUP, SUMIF, COUNTIF, cell referencing ($A$1), and chart types.
MS PowerPoint & Slide Transitions
15%Slide master, presentation shortcuts (F5, Shift+F5), and animation tools.
Operating Systems & Networking
15%LAN, WAN, IP addresses, binary conversion, and antivirus tools.