Section A — 1 Mark Questions
1. What is the primary purpose of a word processor? [1 Mark]
Answer: It is used for creating, editing, formatting, and printing text-based documents.
2. What does the clipboard feature do? [1 Mark]
Answer: It is a temporary storage area that holds data that has been cut or copied for later pasting.
3. Define 'font' in the context of word processing. [1 Mark]
Answer: A font is a set of characters of a specific design, size, and style.
4. What is a cell address in a spreadsheet? [1 Mark]
Answer: It is the unique identifier for a cell, represented by its column letter and row number (e.g., A1).
5. Which element displays the contents of the active cell? [1 Mark]
Answer: The formula bar.
6. How is a new slide typically added to a presentation? [1 Mark]
Answer: By selecting the 'New Slide' option from the toolbar or using a shortcut key.
7. What is the function of spelling and grammar tools? [1 Mark]
Answer: They identify and suggest corrections for errors in spelling and grammatical structure.
8. What is a slide transition? [1 Mark]
Answer: It is the visual effect that occurs when moving from one slide to the next during a presentation.
9. Can formulas in a spreadsheet contain mathematical operators? [1 Mark]
Answer: Yes, they use operators like +, -, *, and /.
10. What is paragraph formatting? [1 Mark]
Answer: It involves adjusting alignment, line spacing, indentation, and margins for a block of text.
11. How do you identify the active cell in a spreadsheet? [1 Mark]
Answer: It is the cell currently selected, often highlighted by a thicker border.
12. What is animation in presentation software? [1 Mark]
Answer: It refers to the motion effects applied to individual elements (like text or images) within a slide.
13. What does 'page setup' involve in a word processor? [1 Mark]
Answer: Setting margins, orientation, and paper size for a document.
14. What is the first character entered when starting a spreadsheet formula? [1 Mark]
Answer: The equals sign (=).
15. What is a spreadsheet? [1 Mark]
Answer: An electronic document that organizes data into rows and columns for analysis.
16. What is the purpose of the 'Bold' feature? [1 Mark]
Answer: It makes the selected text appear thicker and darker.
17. Can you insert images onto a slide? [1 Mark]
Answer: Yes, most presentation software allows for image insertion and editing.
18. What is the result of using 'Cut' on a block of text? [1 Mark]
Answer: It removes the selected text from its original position and places it on the clipboard.
19. What is a chart in a spreadsheet? [1 Mark]
Answer: A graphical representation of numeric data.
20. What is the purpose of paragraph alignment? [1 Mark]
Answer: To determine the horizontal positioning of text relative to page margins.
Section B — 2/3 Mark Questions
1. Explain the difference between 'Copy' and 'Cut'. [2 Marks]
Answer: 'Copy' creates a duplicate of the selected data while leaving the original intact, whereas 'Cut' removes the original data from its position to be relocated elsewhere.
2. List three key elements of a spreadsheet. [3 Marks]
Answer: 1. Cells (the intersection of rows and columns). 2. Rows (horizontal sets of data). 3. Columns (vertical sets of data).
3. Describe the purpose of Slide Transitions. [2 Marks]
Answer: Slide transitions provide visual continuity between slides, helping the audience follow the progression of the presentation by defining how the screen changes from one slide to the next.
4. What are the two main types of formatting in word processing? [2 Marks]
Answer: Character formatting (changing fonts, size, color) and paragraph formatting (changing alignment, line spacing, and indentation).
5. How do formulas work in a spreadsheet? [3 Marks]
Answer: Formulas perform calculations on cell data. They start with an '=', contain operators, and refer to cell addresses (e.g., =A1+B1) to produce dynamic results that update if cell values change.
6. Explain the use of the 'Spelling and Grammar' tool. [2 Marks]
Answer: It automatically scans a document for errors, highlights them, and provides context-sensitive suggestions for correction to ensure document professionalism.
7. Differentiate between Animation and Transition. [3 Marks]
Answer: Transitions apply to the entire slide as it appears on screen. Animations apply to specific objects like text boxes or images within a slide, controlling how those elements enter, exit, or move.
8. What does 'Page Setup' include? [2 Marks]
Answer: It includes settings for margins (the space around the text), page orientation (portrait or landscape), and paper size (A4, Letter, etc.).
9. Why use a chart in a spreadsheet? [3 Marks]
Answer: Charts simplify complex data, allow for quick identification of trends, and make presentations of numerical information more effective and visually accessible for the audience.
10. Explain the significance of cell addresses. [2 Marks]
Answer: Cell addresses allow for precise referencing of data in formulas. This enables automation, as changing a value in a referenced cell automatically updates any dependent calculations.
Section C — 5 Mark Questions
1. Explain the core features of word processing software. [5 Marks]
Answer:
Introduction
Word processing software is a tool for creating professional text-based documents, offering a range of features for efficient content production.
Key Features
- Text Editing: Allows for insertion, deletion, cutting, copying, and pasting of text via the clipboard, enabling easy revisions.
- Formatting: Users can apply character-level changes (bold, italics, font style) and paragraph-level changes (alignment, line spacing) for better readability.
- Page Setup: Controls the physical appearance of the document, including page margins, orientation (portrait/landscape), and paper size selection.
- Proofing Tools: Integrated spelling and grammar checkers ensure documents are free from typos and stylistic errors.
- Table Creation: Enables the organization of complex data into structured rows and columns within the document.
2. Describe the creation and use of spreadsheets. [5 Marks]
Answer:
Introduction
Spreadsheets are powerful tools designed for data management, numerical analysis, and reporting through a structured grid system.
Creating and Managing Data
- Grid Structure: Data is entered into cells, identified by column letters and row numbers.
- Formulas: Essential for processing data. A user starts with '=', then performs operations such as summation or averages using cell references like =SUM(A1:A10).
- Formula Bar: This serves as the primary area to view and edit the contents or complex calculations associated with the active cell.
- Visualization: Spreadsheets allow for the creation of charts (pie, bar, line), which convert rows of numbers into visual trends.
- Application: They are widely used for financial reporting, budget tracking, and data organization across various industries.
3. Elaborate on the process of creating and delivering a presentation. [5 Marks]
Answer:
Introduction
Presentation software enables the creation of multimedia slide decks to communicate information effectively to an audience.
Steps for Presentation
- Slide Creation: The process begins by creating individual slides, choosing layouts, and adding headers or content placeholders.
- Content Management: Users insert text, images, and shapes, applying formatting to ensure clear readability.
- Adding Motion: Transitions are used to animate the movement between different slides, while animations are applied to individual objects within a slide to reveal content sequentially.
- Structuring: A logical flow is maintained by organizing slides in a sequence that supports the narrative or data being presented.
- Delivery: Once created, features like transition effects and animations help maintain audience engagement during the actual delivery of the presentation.
4. Discuss the importance of formatting in document preparation. [5 Marks]
Answer:
Introduction
Formatting is essential for transforming raw text into a professional, easy-to-read document, serving both aesthetic and functional purposes.
Types of Formatting
- Character Formatting: Involves changing the font face, font size, color, and styles like bold or underline to emphasize key information.
- Paragraph Formatting: Manages how text is presented in blocks, including alignment (left, right, center, justified) and spacing, which prevents the text from appearing cluttered.
- Page Layout: Ensures the document looks balanced. Proper margins prevent text from being cut off during printing, and orientation choices depend on the nature of the data.
- Visual Hierarchy: Through consistent formatting, users can guide the reader's eye to headers and important sections.
- Conclusion: Effective formatting increases clarity and credibility, making it easier for the reader to absorb information quickly.
5. Explain how data is manipulated using spreadsheet formulas and charts. [5 Marks]
Answer:
Introduction
Spreadsheets transform raw numeric values into actionable insights through the dual use of automated formulas and graphical data representation.
Formula Mechanics
Formulas act as the engine for processing data. By using mathematical operators and functions, a spreadsheet automatically recalculates results whenever the input data in a referenced cell changes. This eliminates the need for manual updates and reduces human error.
Chart Application
Charts provide the visual component of data analysis. By selecting a range of cells, users can generate charts that represent data relationships:
- Bar Charts: Ideal for comparing values between different categories.
- Pie Charts: Useful for showing part-to-whole relationships.
- Line Charts: Best suited for demonstrating trends over specific time periods.
By combining formulas and charts, users can create dynamic reports that are both accurate and easy for stakeholders to understand.