Word Processing and Spreadsheets

A word processor is a foundational application software used for creating, editing, formatting, and printing text-based documents such as letters, reports, and resumes. For board exams, you must be familiar with the basic user interface elements—such as the ribbon, quick access toolbar, and status bar—as well as essential text formatting features like changing font styles, setting paragraph alignment, and using find and replace. Additionally, understanding advanced features like Mail Merge (used for generating mass personalized letters or labels by combining a main document with a data source) is a frequent requirement in practical and theory papers.

A spreadsheet, on the other hand, is designed for organizing, analyzing, and storing numerical data in a tabular grid composed of intersecting rows and columns. The basic unit of a spreadsheet is a cell, identified by its column letter and row number (e.g., A1). You should memorize how to reference cells using cell addresses and understand the difference between relative referencing (which changes when copied) and absolute referencing (which remains fixed using the $ sign, like $A$1).

Data manipulation in spreadsheets relies heavily on formulas (user-defined equations starting with an = sign) and functions (pre-defined operations like SUM, AVERAGE, MAX, MIN, and COUNT). Board questions often test your ability to evaluate basic formula outputs, trace cell errors, or explain how to convert raw spreadsheet data into visual charts and graphs. Knowing the correct syntax for these basic functions is crucial for securing high marks in both objective and subjective sections.