Answered

T CITO101 CAT TWO
TIME: ONE Hour
(30 Marks)
Answer all questions

### Question One
1. Discuss the purpose and use of the following software found in microcomputers:
a. System software (2 marks)
b. Application software (2 marks)
c. Utility software (1 mark)
2. Give two examples of utility software (1 mark)

### Question Two
1. Define mail merging (1 mark)
2. Outline the three basic steps required to mail merge a document (3 marks)
3. List any two ways of merging a document with its data source (2 marks)
4. List and explain four mathematical functions provided by Microsoft Excel (4 marks)
5. Differentiate between:
a. Single and multiple cell referencing (2 marks)
b. Relative and absolute cell referencing (2 marks)

### Question Three
Some students in JKUAT main campus use computers to do homework. Name the package used to:
1. Do calculations and draw graphs (4 marks)
2. Write an essay (4 marks)
3. Make a presentation (4 marks)

You have been selected to design the IT department's website. Specify the code to include:
1. A background color (1 mark)
2. An image (1 mark)
3. A table with two rows and two columns (2 marks)
4. An ordered list, unordered list, and definition list (2 marks)



Answer :

GinnyAnswer

Final answer:

Explanation of system, application, and utility software in microcomputers, mail merging process, Excel functions, and IT tasks & website design.


Explanation:

System software serves as the backbone of a computer system, providing essential functions like managing hardware components and providing a platform for running application software.
Application software is designed to perform specific tasks for the user, such as word processing, multimedia editing, or gaming.
Utility software includes tools like antivirus programs, disk cleaners, and system optimizers that help enhance system performance and user productivity.

Two examples of utility software are Disk Cleanup and CCleaner.

Mail merging is the process of combining a template document with a data source to create personalized documents in bulk.

  1. Three basic steps for mail merging are selecting the document type, choosing the data source, and inserting merge fields.
  2. Two ways of merging a document with its data source are using the Mail Merge Wizard in word processing software or using dedicated mail merge software.

Four mathematical functions in Microsoft Excel are SUM (adds cells), AVERAGE (calculates the average), MAX (finds the maximum), and MIN (finds the minimum).

Single cell referencing refers to referencing a specific cell, while multiple cell referencing involves referencing a range of cells.

Relative cell referencing adjusts the cell reference when copied, while absolute cell referencing maintains the same reference regardless of its location.

The package used for various tasks at JKUAT main campus: i. Microsoft Excel for calculations and graphs, ii. Microsoft Word for essay writing, and iii. Microsoft PowerPoint for presentations.

Designing the IT department website: i. Background color can be set using CSS, ii. An image can be inserted using HTML, and iii. A table with two rows and two columns can be created using HTML tags.

For lists, ordered lists use numbered items, unordered lists use bullet points, and definition lists define terms with descriptions.


Learn more about Software and IT Tools here:

https://brainly.com/question/37701293


Other Questions