QUESTION TWO (20 Marks) a) What is a spreadsheet (2 Marks) b) Describe Four lealures of a spreadsheet (4 Marks) c) Differentiate between a manual Spreadsheet and an Electronic Spreadsheet (6 Marks) d) How can you carry out the following operations in Microsoft Excel i Cregle a new worksheet ii. Insert a column iii. Delete a row iv. Wrep-texl (8 Marks) QUESTION THREE (20 MARKS) (6 Marks) b) Outline any Five symptoms of a computer virus and Explain the measures youwould adopt to safeguard your files from viruses. (10 Marks) C) Explain Two ways Ihrough which Computer Viruses spread from one computer to the other? (4 marks) QUESTION FOUR (20 MARKS) ay What is a word Processor (2 Marks) b) Describe how you can insert Page Breaks in Microsofl Word (4. Marks) c) Explain the difference between Save and Save as commands as used in Word Processing (6 Marks) d) Explain the meaning of the following Shortcut Keys: CTRL+C ii. CTRL+X iii. CTRL+P iv. CTRL+s (8 Marks) QUESTION FIVE (20 MARKS)K a) An operating system executes many functions Explain FIVE of its essential functions (10 marks) b) Differenticle between system software and application software. (4 marks) c) Discuss THREE leatures of an electronic database management system (6 marks) 140800 e

QUESTION TWO (20 Marks)<br /><br />a) What is a spreadsheet? (2 Marks)<br />A spreadsheet is a software application that allows users to organize, manipulate, and analyze data in a tabular format. It consists of rows and columns, where data can be entered and calculations can be performed.<br /><br />b) Describe Four features of a spreadsheet. (4 Marks)<br />1. Data Organization: Spreadsheets allow users to organize data in a structured manner, making it easier to manage and analyze.<br />2. Data Manipulation: Users can perform various operations such as addition, subtraction, multiplication, and division on the data in the spreadsheet.<br />3. Data Visualization: Spreadsheets provide tools for visualizing data through charts, graphs, and pivot tables, making it easier to interpret and present information.<br />4. Conditional Formatting: Spreadsheets offer the ability to apply conditional formatting, which allows users to highlight or format cells based on specific conditions or criteria.<br /><br />c) Differentiate between a manual Spreadsheet and an Electronic Spreadsheet. (6 Marks)<br />A manual spreadsheet refers to a physical paper-based spreadsheet where data is entered manually and calculations are performed manually. It lacks the ability to perform complex operations and lacks data visualization tools.<br /><br />On the other hand, an electronic spreadsheet is a software-based application that allows users to enter data, perform calculations, and visualize data using various tools and features. Electronic spreadsheets are more efficient, versatile, and offer advanced functionalities compared to manual spreadsheets.<br /><br />d) How can you carry out the following operations in Microsoft Excel? (8 Marks)<br />i. Create a new worksheet: To create a new worksheet in Microsoft Excel, click on the "New" button in the File menu or press the "Ctrl + N" shortcut key.<br />ii. Insert a column: To insert a new column in Microsoft Excel, right-click on the column header where you want to insert the new column, select "Insert" from the context menu, and choose "Insert Columns."<br />iii. Delete a row: To delete a row in Microsoft Excel, right-click on the row header you want to delete, select "Delete" from the context menu, and choose "Delete Rows."<br />iv. Repeat a row: To repeat a row in Microsoft Excel, select the row you want to repeat, right-click on the selected row, choose "Fill" from the context menu, and select "Down" or "Up" depending on whether you want to repeat the row below or above the selected row.<br /><br />QUESTION THREE (20 MARKS)<br /><br />a) What is a computer virus? (6 Marks)<br />A computer virus is a malicious software program designed to replicate itself and spread from one computer to another. It can cause harm to computer systems, steal personal information, or disrupt normal computer operations.<br /><br />b) Outline any Five symptoms of a computer virus and Explain the measures you would adopt to safeguard your files from viruses. (10 Marks)<br />1. Slow computer performance: A virus can consume system resources, leading to slow performance.<br />2. Unusual error messages: Viruses may cause unexpected error messages or crashes.<br />3. Pop-up advertisements: Viruses can display unwanted pop-up ads or redirect web pages.<br />4. Data corruption: Viruses can modify or delete files, leading to data loss or corruption.<br />5. Unauthorized access: Viruses can allow unauthorized access to personal information or sensitive data.<br /><br />Measures to safeguard files from viruses:<br />- Install and regularly update antivirus software.<br />- Avoid opening suspicious email attachments or clicking on unknown links.<br />- Regularly back up important data.<br />- Avoid downloading software or files from untrusted sources.<br />- Keep the operating system and software up-to-date with the latest security patches.<br /><br />c) Explain Two ways through which Computer Viruses spread from one computer to the other? (4 marks)<br />1. Email attachments: Viruses can be attached to email messages and spread when recipients open the infected attachments.<br />2. Infected websites: Visiting infected websites can download viruses onto a computer, especially when using outdated or vulnerable web browsers.<br /><br />QUESTION FOUR (20 MARKS)<br /><br />a) What is a word Processor? (2 Marks)<br />A word processor is a software application used for creating, editing, and formatting text documents. It provides tools for typing, formatting, and organizing text, as well as adding images, tables, and other elements to documents.<br /><br />b) Describe how you can insert Page Breaks in Microsoft Word. (4 Marks)<br />To insert a page break in Microsoft Word, follow these steps:<br />1. Place the cursor where you want the page break to occur.<br />2. Go to the "Layout" tab in the ribbon.<br />3. Click on the "Breaks" button in the "Page Setup" group.<br />4. Select "Insert Page Break" from the dropdown menu.<br /><br />c) Explain the difference between Save and Save as commands as used in Word Processing. (6 Marks)<br />The "Save" command is used to save the current document with its existing name and location. It updates the existing file without changing its name or location.<br /><br />On the other hand, the "Save As" command is used to save