Computer Form Two Mid-Term M.S

COMPUTER FORM TWO MID-TERM EXAMS TERM 1
Name:…………………………………………………… Adm:
…………………………………………………… Total Marks: 30
Answer Key
1. Describe three hardware-related factors that you need to consider for the project to
be implemented successfully (3 marks).
o Processor Speed: Ensure the computers have a fast enough processor to handle
the tasks required by the users, such as Intel i5 or higher.
o RAM: Ensure the computers have sufficient RAM (at least 8GB) to support
multitasking and running multiple applications smoothly.
o Storage: Consider the type and size of storage, opting for SSDs over HDDs for
faster boot times and overall performance, with at least 256GB of storage space.
2. Describe two search options that Kipsmart must use to locate the word "whenever"
within the passage (2 marks).
o Find Function: Use the 'Find' function (Ctrl + F) to open the search dialog box
and type "whenever" to locate every instance of the word in the document.
o Navigation Pane: Enable the Navigation Pane from the 'View' tab and type
"whenever" in the search box to see all occurrences listed and navigate through
them easily.
3. Describe two components of a spreadsheet (2 marks).
o Cells: The basic unit of a spreadsheet where data is entered, defined by the
intersection of a row and a column.
o Worksheet: A single page within a spreadsheet file (workbook) that contains a
grid of rows and columns.
4. State how the line of text will appear if he applies the following change case options
(2 marks). a) Sentence case (1 mark): "Maranda high school" b) Title case (1 mark):
"Maranda High School"
5. Write a formula to calculate the average of the values in cells A1 to A10 (2 marks).
o =AVERAGE(A1:A10)
6. How do you sort a data range in ascending order based on a specific column (3
marks)?
o Select the data range you want to sort.
o Go to the 'Data' tab and click on 'Sort'.
o In the 'Sort' dialog box, choose the column by which you want to sort, select
'Ascending', and click 'OK'.
7. Use illustrations to describe two types of alignment (2 marks).
o Left Alignment: Text is aligned along the left margin.
o Center Alignment: Text is centered between the left and right margins.
8. Explain how to apply a predefined style to a paragraph in Microsoft Word (2
marks).
o Select the paragraph you want to style.
o Go to the 'Home' tab, find the 'Styles' group, and click on the predefined style you
want to apply from the gallery.
9. Using examples, differentiate between insert mode and type over mode as used in a
word processor (2 marks).
o Insert Mode: When you type, new text is inserted at the cursor position, pushing
existing text to the right. Example: Typing "hello" in "he_llo" results in "hehello".
o Type Over Mode: When you type, new text replaces existing text at the cursor
position. Example: Typing "hello" in "he_llo" results in "hello".
10. Define mail merging (2 marks).
o Mail merging is the process of creating personalized letters, labels, and emails by
combining a standard template document with a data source containing individual
recipient information.
11. Give two advantages of mail merge over copy and pasting several times to mass mail
a document (2 marks).
o Efficiency: Automates the creation of personalized documents, saving time and
reducing manual effort.
o Consistency: Ensures uniformity in the format and content of the documents,
minimizing the risk of errors.
12. Outline any two main features that make word processors popular programs (3
marks).
o Text Formatting: Allows users to easily format text, including font style, size,
color, and alignment.
o Spell Check and Grammar Check: Provides tools to automatically check and
correct spelling and grammatical errors.
13. Define the following terms as used in a worksheet (3 marks): i) Columns: Vertical
divisions in a worksheet identified by letters (A, B, C, ...). ii) Rows: Horizontal divisions
in a worksheet identified by numbers (1, 2, 3, ...). iii) Cell: The intersection of a row and
a column where data is entered, identified by a combination of the column letter and row
number (e.g., A1, B2).

Computer Form Two Mid-Term M.S

Uploaded by

Copyright:

Available Formats

Computer Form Two Mid-Term M.S

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Computer Form Two Mid-Term M.S

Uploaded by

Copyright:

Available Formats

COMPUTER FORM TWO MID-TERM EXAMS TERM 1

You might also like