Here are the solutions to the questions:
Multiple Choice Questions (Right Column)
41. The writer of play is known as a ______
42. A narrative poem ______
43. A deliberate violation of the rules of versification constitutes
44. A verbal irony in a narrative manner
45. "A black beautiful brilliant bride" is an example of
46. The paragraph in prose can be compared to ______ in poetry
47. The juxtaposition of two seemingly contradictory words is
48. The use of visual display unit was a major breakthrough in the.
THEORY ANSWER 4 QUESTION IN ALL.
1. (A) Write short note on the following:
- A. worksheet: A worksheet is a single page within an Excel workbook, consisting of a grid of cells organized into rows and columns.
- B. Cell: A cell is the intersection of a row and a column in a worksheet, where individual pieces of data are entered.
- C. Active cell: The active cell is the currently selected cell in a worksheet, highlighted by a border, where data will be entered or edited.
- D. Cell reference: A cell reference is a unique identifier for a cell, formed by combining its column letter and row number (e.g., A1, C5).
- E. workbook: A workbook is a file in a spreadsheet program (like Microsoft Excel) that contains one or more worksheets.
1. (B) Write formula to Calculate the following using the table in 1(A):
Assuming Deborah's scores are in cells B2 (English), C2 (Maths), D2 (Civic), and E2 (Computer).
- A. Addition (Total for Deborah):
=SUM(B2:E2)
- B. Average (Average for Deborah):
=AVERAGE(B2:E2)
- C. Subtraction (Example: Maths minus Civic for Deborah):
=C2-D2
- D. Multiplication (Example: English score multiplied by 2 for Deborah):
=B2*2
1. (C) What is the spreadsheet function can be used to determine the highest subject
The spreadsheet function used to determine the highest value is MAX.
1. (D) Outline the procedure for calculating Deborah total core in all subject and give the result in cell
- Procedure:
- Click on the cell where you want the total score to appear (e.g., F2).
- Type the formula
=SUM(B2:E2).
- Press the Enter key.
- Result in cell F2: Based on the table (English=70, Maths=65, Civic=75, Computer=80), the total score for Deborah is 70+65+75+80=290.
The result in cell F2 would be 290.
2. (a) What is graphic package?
A graphic package (or graphics software) is an application software used to create, edit, and manipulate images, drawings, and other visual content.
2. (b) Give 3 Examples of graphic package
- Adobe Photoshop
- CorelDRAW
- GIMP (GNU Image Manipulation Program)
2. (c) Outline the steps taken to perform the following task using corel-draw application: i.Insert a circular shape ii. Add the caption "Happy birthday" around the circular shape. iii. Change the colour of the caption to green
- i. Insert a circular shape:
- Select the Ellipse tool from the toolbox.
- Click and drag on the drawing page while holding down the Ctrl key to create a perfect circle.
- ii. Add the caption "Happy birthday" around the circular shape:
- Select the Text tool.
- Click on the edge of the circular shape.
- Type "Happy birthday", and the text will follow the path of the circle.
- iii. Change the colour of the caption to green:
- Select the text "Happy birthday".
- Click on the green color swatch in the Color Palette.
3. (a) What is word processing?
Word processing is the creation, editing, formatting, and printing of text documents using a computer and specialized software called a word processor.
3. (b) Outline the steps involved in loading Microsoft word
- Click the Start button (or Windows icon) on the taskbar.
- Navigate to All Programs (or All apps).
- Find and click on Microsoft Word (or Word) in the list of programs.
3. (c) Itemize 6 facilities available in Microsoft word
- Text formatting (bold, italics, font size, color)
- Spell check and grammar check
- Page layout (margins, orientation, columns)
- Insert images, tables, and shapes
- Mail Merge
- Track Changes and Comments
4. (a) I. Define application package
An application package (or application software) is a program or group of programs designed for end-users to perform specific tasks, such as word processing, spreadsheet calculations, or graphic design.
4. (a) II. State one use each of any four application packages
- Word Processor (e.g., Microsoft Word): Used for creating and editing text documents, letters, and reports.
- Spreadsheet (e.g., Microsoft Excel): Used for organizing, analyzing, and calculating numerical data in tables.
- Presentation Software (e.g., Microsoft PowerPoint): Used for creating visual presentations with slides, text, images, and multimedia.
- Database Management System (e.g., Microsoft Access): Used for storing, organizing, and retrieving large amounts of structured data.
4. (b) List two benefit of a presentation package
- Helps to convey information clearly and engagingly through visual aids.
- Allows for easy organization of content into slides, making complex topics easier to follow.
4. (c) Outline three guidelines for creating a good power-point presentation
- Keep it concise: Use minimal text on each slide, focusing on key points rather than full sentences.
- Use visuals effectively: Incorporate relevant images, charts, and graphs to illustrate points and engage the audience.
- Maintain consistency: Use a consistent design template, font styles, and color scheme throughout the presentation for a professional look.
5. (a) What are soft-ware
Software refers to the set of instructions, data, or programs used to operate computers and execute specific tasks. It is the non-physical component of a computer system.
5. (b) Write the two types of software we have and explain them
- System Software: Software designed to operate and control the computer hardware and to provide a platform for running application software. Examples include operating systems (Windows, macOS) and utility programs.
- Application Software: Software designed for end-users to perform specific tasks or functions. Examples include word processors (Microsoft Word), spreadsheets (Excel), and web browsers.
5. (c) Differentiate the system software and application soft-ware
- System Software: Manages and controls computer hardware and provides a platform for other software. It is essential for the computer to function.
- Application Software: Designed for end-users to perform specific tasks. It relies on system software to run and is not essential for the basic operation of the computer.
Last free one today — make it count tomorrow, or type /upgrade for unlimited.