NICHTECH TECHNOLOGIES COMPUTER TRAINING CENTER
FINAL EXAM THEORY
NAME: ……………………………………………………….. DATE:……./……../2023
1. Explain any four (4) keyboard key groups and their functions: (20 marks)
2. What is the difference between data and information? (5 marks)
3. Explain the meaning of the following keyboard shortcuts and terms (12 marks)
i. Ctrl + V
ii. Booting
iii. Footer
iv. Ctrl + z
v. Alt + shift + t
vi. Header
vii. CTRL + Z
viii. Grouping
ix. Ctrl + A
x. Editing
xi. Hardware
xii. Hardcopy 1 2 3
4.
4 5 6 7 8
1. MINIMIZING BUTTON 2. MAXMIZE BUTTON [Link] BUTTON [Link] 5 STATUS BAR 6. TASK BAR
7. RULE 8. SCROLL BAR
i. Name the parts of the MS WORD window labeled. (10 marks)
1, 2, 3, 4, 5, 6, 7, 8,
ii. What is the use of the part labeled 8? (5 marks)
iii. Which part do you first click when you want to open MS WORD application? (5 marks)
5. What do we call the process of cutting a picture into the desired size or shape? (5 marks)
6. To highlight is to shed a word or document, which keys on the keyboard can we combine to
have the whole document highlighted? (5 marks)
7. When you crop a picture, it will be cut into a certain shape, explain the process of cropping a
picture. (10 marks)
8. Explain the process of creating a folder on the desktop. (10 marks)
9. What is the difference between save and save as
SECTION B
1 2 3 4
10. What is a spreadsheet
11. What do we call the process of combining two or more cells to work as one in excel?
12. What name is given to a single box in a spreadsheet?
13. By default, a spreadsheet opens with how many sheets?
14. Explain the function of the auto sum feature in excel.
15. Mention any two important features of MS Excel.
16. Why would you prefer to use MS Excel than MS PowerPoint?
17. What is database?
18. What is the importance of MS PowerPoint?
SECTION B PART 2
(Fill in the blank)
19. The …………………… is an input device used to enter word in the computer. (1 marks)
20. …………………………… is the process of cutting the picture into the desired shape. (2 marks)
21. Time and date on the computer displays on the ……………… bar. (2 marks)
22. A …………………….. Is an electronic machine used to store data? (2 marks)
23. To ………………….. is to feed information into the computer
24. …………….. Is uncompleted information while ……………… is completed data. (3 marks)
25. …………………… is a combination of lettered columns and numbered rows
26. The combination of two or more worksheets is called …………………………….
27. Explain the process of putting a developer tab in the ribbon.
28. What is the process of creating a folder on the desktop?
29. Mention the stages / process of creating a dropdown list of names in MS Excel.
30. What is the use of count blank formula in Excel?
31. Explain in details the use of find and replace feature in Excel
SECTION C
32. What is a copyright ,
33. Why is it important to have a copyright
34. With examples, define what intellectual properties are
35. Mention and explain only three characteristics of a computer
All the best
NICHTECH TECHNOLOGIES COMPUTER TRAINING CENTER
FINAL EXAM PRACTICAL
INSTRUCTIONS
No use of cell phones in the exam room
No extra time will be added after the stipulated time
Read the questions and understand them before you start answering
Create a folder on in the documents and save all your work.
There are two questions in this paper, answer all the questions, question one (1) is compulsory
QUESTION 1.
Open MS EXCEL and type in the following data as guided below
(i) In column A1, type in the word product, come up with 10 product of your choice.
(ii) In column B1, type QTY and come up with the quantity of your choice.
(iii) In column C1, type PRICE and come up with the prices of your choice.
(iv) In column D1, type totals
(v) Use the formula to find the totals
(vi) With the help of a lookup in cell A16, show how you can much the products with the
price
(vii) In the same cell A16, come up with a drop down list of all the products
(viii) By the use of count if formula in cell D12, show how many times each product is
appearing in the column.
(ix) In cell E1, Put a formula that will show how much each product coasted
(x) Replicate the formula through E10.
(xi) Compare name and prices with a pie chart.
Question 2.
Open MS PUBLISHER and work out the following.
(i) Design a calendar that will show all the months on one page
(ii) Show the important dates, events and holidays by listing them in a text box
(iii) Save your work as “ my last exam publisher”
ALL THE BEST
NICHTECH TECHNOLOGIES COMPUTER TRAINING CENTER
WINDOWS / MS WORD PRACTICAL EXAM.
NAME: ……………………………………………………….. DATE:……./……../2022
DURATION: 1:30 MINUTES
Instructions: follow & understand the questions & answer them accordingly. You are required to do all
tasks.
BASIC OPERATIONS OF A COMPUTER
The basic operations of a computer include the following; Input, Process, Store and Output.
1. Input: To input simply means to enter or feed data (text, numbers, pictures, sound) into the
computer system and this data is fed into the computer system via (through) input devices or
peripherals. There are a number of input devices, which include keyboards, touch sensitive
screen, and digital cameras. Now before we move on to look at another basic operation of a
computer it is just important to briefly define and distinguish data and information.
Data: refers to raw facts, figures, text, etc, that is not processed and has no meaning. Data can
also mean unprocessed facts, figures, text, etc. that carry no meaning. Information on the other
hand is processed data. In other words data only becomes information when it has been
converted or processed into meaningful information.
2. Processing: Is the conversion of raw data into useful information. Processing includes the
following: calculating, drawing, searching, etc. the processing component in a computer is called
a CPU- Central Processing Unit or a Microprocessor. (Found on the mother board which we will
look at later in our discussion).
3. Storage: Refers to the safe keeping of the data that has been entered into the computer so that
it can be used when required. Data can be stored both temporally (while a program is running or
while the computer is on) and long term so that it can be preserved while software and hardware
is not in use or in simple terms when the computer is off.
4. Output: Refers to the visible and audible data that has been processed. Outputs are made
available by output peripherals or devices.
TASK
QUESTION 1
1. Type the statement above correctly. (10 marks)
2. Save the statement in my documents under the file name HIV AIDS.(10 marks)
3. Create a folder on the desktop with the name “AIDS 2” (10 marks)
4. Copy the file HIV AIDS from my documents and paste it in the folder you created on the
desktop under the name AIDS 2. (10 Marks)
QUESTION 2 10 marks
1. Create a data entry form in MS WORD by the use of a developer tab with
the following details and put the appropriate data type.
a. 5 names, b. gender, c. dob, d, religion, country