What is office software?
Office software (an office suite) is a group of application programs for everyday work with electronic documents.
- Word processor: text documents (letters, reports, CVs). Examples: Writer, Word, Google Docs.
- Spreadsheet: tables of numbers, calculations, charts. Examples: Calc, Excel, Google Sheets.
- Presentation: slides for a talk. Examples: Impress, PowerPoint, Google Slides.
Suites may also include a database, drawing tool and email. Some are installed on the computer; others run in a web browser and save to the cloud, so several people can edit together.
Document elements and formatting
A document is built from elements:
- Headings and paragraphs of text
- Lists (bulleted or numbered)
- Tables (rows and columns)
- Images, shapes and charts
- Header and footer (repeat on every page, e.g. page numbers)
- Footnotes, hyperlinks, table of contents
Character formatting: font, size, bold, italic, underline, colour. Paragraph formatting: alignment (left, centre, right, justify), indent, line spacing. Page formatting: margins, orientation (portrait/landscape), paper size. Use styles (Heading 1, Heading 2) so the look is consistent and a table of contents can be made automatically.
File formats
Editable: .odt / .docx (text), .ods / .xlsx (sheets), .odp / .pptx (slides). For sharing and printing: .pdf keeps the layout but is hard to edit. Plain text (.txt) has no formatting.
Spreadsheets: cells, ranges and data
A spreadsheet is a grid of rows (1, 2, 3…) and columns (A, B, C…). Each box is a cell with an address: column letter + row number, e.g. B3. A block of cells is a range: B1:B3 means B1, B2 and B3.
A cell can hold text (labels), numbers, dates or a formula. A file is a workbook with one or more sheets.
Useful tools: sort (A→Z, smallest→largest), filter (show only some rows), number formats (currency, %, decimals), and freezing the header row.
Formulas, functions and charts
A formula always starts with =. Operators: + − * / ^. Example: =B2*C2 multiplies price by quantity.
Functions are ready-made formulas:
- =SUM(B1:B10) adds; =AVERAGE(B1:B10) finds the mean
- =MAX, =MIN find largest and smallest; =COUNT counts numbers
- =IF(B2>=33, "Pass", "Fail") chooses between two results
Relative reference (B2) changes when you copy the formula down; absolute reference ($B$1) stays fixed, e.g. a tax rate in one cell. Formulas recalculate automatically when data changes. Common error: #DIV/0! (dividing by zero).
Charts: select data → insert chart. Bar/column to compare, line for change over time, pie for parts of a whole.
Presentations and good habits
A presentation is a series of slides. Good slides: one idea each, a short title, 3-5 short points, big readable text, a picture or chart, the same theme throughout. Transitions are effects between slides; animations move items on a slide; speaker notes are for you only.
Good habits: save often and keep a backup; use clear file names; check spelling; respect copyright for images; and protect personal data before sharing.
Try it
Open any free spreadsheet app. Type 7 days in A1:A7 and what you spent each day in B1:B7. In B8 type =SUM(B1:B7) and in B9 =AVERAGE(B1:B7). Insert a column chart. Change one day's amount and watch the total and chart change, just like the 3D free-play step.
Key formulas and definitions
- Cell address = column letter + row number (B3)
- Range = first cell : last cell (B1:B3)
- Every formula starts with =
- =SUM(range), =AVERAGE(range), =MAX(range), =MIN(range), =COUNT(range)
- =IF(condition, value if true, value if false)
- Relative reference B2 changes when copied; absolute $B$2 stays fixed
- Percentage = part ÷ whole × 100 (=B2/B10*100)
Worked examples
1. Write the address of the cell in column D, row 7. How many cells are in the range A1:C4?
D7. A1:C4 has 3 columns × 4 rows = 12 cells.
2. B1 = 12, B2 = 18, B3 = 30. What do =SUM(B1:B3), =AVERAGE(B1:B3) and =MAX(B1:B3) show?
SUM = 12 + 18 + 30 = 60. AVERAGE = 60 ÷ 3 = 20. MAX = 30.
3. Prices are in B2:B5, quantities in C2:C5 and the tax rate (5%) is in F1. Write a formula in D2 for the price with tax that can be copied down to D5.
=B2*C2*(1+$F$1). B2 and C2 are relative, so they become B3, C3… when copied. $F$1 is absolute, so every row uses the same tax cell. For 4 items at ₹50: 50 × 4 × 1.05 = ₹210.
4. Marks are in B2. Write a formula that shows "Pass" if the mark is 33 or more, otherwise "Fail".
=IF(B2>=33, "Pass", "Fail").
Common mistakes
- Forgetting the = sign, so the formula shows as plain text.
- Writing the row first (3B). Addresses are column first: B3.
- Typing totals by hand instead of using =SUM, so they do not update when data changes.
- Copying a formula that should always point to one cell without using $ (absolute reference).