Common Software and Tools Explained: Types, Worked Example and Exam Traps

Learn to classify system, application, utility, and development software by function. Then follow one result-processing workflow from spreadsheet formula to PDF, ZIP, and backup.

KnowledgeGate Team

Exam prep & CS education

Updated 2 Nov 20266 min read
Common Software and Tools Explained: Types, Worked Example and Exam Traps

Operating system, browser, compiler, cloud storage, and office suite may all sound familiar. The difficulty begins when options swap a tool with its task, file format, feature, or online service. Classify each item by function, trace the result-processing workflow, calculate each result, and distinguish tools from their tasks, formats, and services. Common Software & Tools MCQs: 12 Solved ICT Questions Explained tests these distinctions question by question. System, application, utility and development software are classified by function before one workflow connects them.

Classify software by the job it performs

Software is the programs and related data that direct a computer. A tool is a program, service, or application feature for a task.

Class

Main job

Examples

System software

Manages the platform and devices

Operating system, device driver

Application software

Performs a user task

Word processor, spreadsheet, presentation package, browser, email client, DBMS

Utility software

Maintains, protects, compresses, or backs up data

Antivirus, archive, disk-check, backup utility

Development software

Helps create and diagnose programs

Editor, IDE, compiler, interpreter, linker, debugger, version-control client

Separate hardware, software, file formats, and online services. Since products bundle functions, classify the named function. An OS may include backup software, but “creates a recoverable copy” still describes a utility. A browser can display a PDF, but PDF remains a document format.

Diagram classifies system, application, utility, and development software by their jobs and examples.

Know what common user-facing tools do

A word processor formats text. A spreadsheet stores tabular values and calculates with formulae. Presentation software arranges slides. A DBMS stores and queries controlled, related records. A browser displays web resources, an email client manages messages, a media player handles audio or video, and a PDF reader displays fixed-layout documents. MS Office Applications for Knowledge of ICT: Worked Word, Excel and PowerPoint Tasks follows document, worksheet and slide construction. In the wider classification, those programs are application-software examples beside system, utility and development tools.

Extensions identify forms, not software categories: DOCX or ODT for text documents, XLSX or ODS for spreadsheets, PPTX or ODP for presentations, CSV for tabular exchange, PDF for fixed layout, and ZIP for an archive. Several programs may open one form. Office Mixed Concepts Explained: Access, Clipboard, File Formats and Exam Traps traces save, export, copy, link and embed operations. Formats such as PDF and ZIP are data forms, not software categories.

For a web page, browser is the application, HTTPS the protocol, URL the address, and search engine the discovery service.

Separate system software, utilities, and development tools

An OS schedules processes, manages memory, controls files and devices, and serves applications. A driver translates OS requests for a device. Firmware is device-stored low-level software for initialisation or control.

Antivirus scans for malware, archive utilities compress, backup utilities create recoverable copies, and disk tools inspect storage. Sync mirrors current changes, while backup preserves a copy or version. Deletions can propagate through sync.

Write total.c in an editor or IDE. A compiler produces object code total.o; a linker combines it with libraries into executable total; a loader places it in memory. A debugger pauses execution to inspect values. An IDE coordinates tools but is not a compiler. An interpreter translates or executes incrementally at run time rather than producing the same object-code and linker chain. For programming-role classification, translators are development tools; some exam taxonomies include them under system software. Read the question's taxonomy before choosing between those labels.

Worked example: process four student results

Put theory marks in spreadsheet column B, practical marks in C, and the weighted result in D. For Asha in row 2, enter =0.6*B2+0.4*C2, then fill the formula down.

Calculate each row explicitly:

  • Asha: 0.6(72) + 0.4(84) = 43.2 + 33.6 = 76.8

  • Bharat: 0.6(64) + 0.4(76) = 38.4 + 30.4 = 68.8

  • Charu: 0.6(80) + 0.4(68) = 48 + 27.2 = 75.2

  • Danish: 0.6(56) + 0.4(92) = 33.6 + 36.8 = 70.4

The class mean is (76.8 + 68.8 + 75.2 + 70.4) / 4 = 291.2 / 4 = 72.8. Descending order is Asha 76.8, Charu 75.2, Danish 70.4, then Bharat 68.8.

Save the table as Results.xlsx. Mail merge creates four personalised letters; exporting those plus one summary gives five PDFs totalling 2.8 MB. An archive utility produces Results-Pack.zip, observed at 2.1 MB. Compression varies by content, so this is not a universal ratio. Two independent backup copies occupy 2 x 2.1 MB = 4.2 MB.

Spreadsheet calculates and sorts; word processor merges; PDF exporter makes the sharing format. Archive utility packages, antivirus scans, backup utility copies. The OS manages resources; the driver serves the printer.

Correct results workflow from four stated scores through five PDFs, archive, and two 2.1 MB backups.

Decode abbreviations by role, not by rote

Attach a function to every expansion:

Term and expansion

Category and use

GUI, graphical user interface

Interface, icons and windows

CLI, command-line interface

Interface, textual commands

OS, operating system

Platform, resource management

DBMS, database management system

Data system, related-record queries

CSV, comma-separated values

Data format, row exchange

PDF, portable document format

Document format, fixed-layout sharing

IDE, integrated development environment

Development, editing, building, debugging

API, application programming interface

Integration, software communication

URL, uniform resource locator

Web address, resource location

HTTP, hypertext transfer protocol

Web protocol, resource transfer

HTTPS, HTTP protected through TLS

Secure protocol, protected transfer

SaaS, software as a service

Delivery model, remote application

Test yourself: icons and windows, GUI; textual commands, CLI; editor, build, debugger, IDE; related data and queries, DBMS; browser-delivered application, SaaS. Expansion does not prove category, so add function.

Common software and tools traps

  • Browser versus search engine: the browser renders pages; the search engine indexes and discovers them.

  • Operating system versus application: the OS manages resources; an application performs the user task. The spreadsheet, not the OS, calculates 72.8.

  • Spreadsheet versus DBMS: a spreadsheet centres on cells and formulae. A DBMS handles controlled related data, queries, and concurrent access. Four local records suit this example; a multi-user system needs a DBMS.

  • Sync versus backup: sync mirrors changes; backup provides a recoverable copy or version.

  • IDE versus compiler: the IDE bundles facilities; the compiler performs translation to object code.

  • File format versus application: PDF names the document form, not the program that created or opened it.

RAM and SSD are hardware. GUI is an interface style, not an OS. Follow the function.

How questions test software and tools

Questions test classification, task-tool matching, expansions, file forms, development order, and mismatches. Confirm coverage and format in your examination's official syllabus or notification.

Mixed check: Linux -> OS, antivirus -> utility, GCC -> compiler, browser -> web client, PDF -> document format, GUI -> interface style. A lab printer needs its driver, not the word processor or PDF.

Use four steps: underline the action; classify the item as hardware, software, service, or file form; within software choose platform, user task, maintenance, or development; eliminate mismatches. “Creates a recoverable copy of Results-Pack.zip” means maintenance, so choose backup utility.

Practise after you can state both the category and the job of every option. A remembered full form without its role is not enough.

The short version and next step

Identify the job first: system software manages the platform, applications perform tasks, utilities maintain or protect, and development tools build or diagnose programs. The mean is 72.8; five PDFs total 2.8 MB; the observed ZIP is 2.1 MB; and two backups total 4.2 MB.

Redraw Results.xlsx to Results-Pack.zip, label each category, and explain why the printer driver and PDF differ from an application. For a broader route, use the Govt Teaching Jobs category. Relevant aspirants can explore the RSSB Basic Computer Instructor course.