<=Back
<=KNEC Diploma in ICT module 1 Computer Applications I past paper:November 2021
Figure 2 is a spreadsheet extract. Use it to answer the questions that follow
Using a function and cell addresses only, write a formula that may have been used to compute each of the following;
i)weighted score in cell D3
ii)average weighted score in cell D6.
Using a function and cell addresses only, write a formula that may have been used to compute each of the following;
i)weighted score in cell D3
ii)average weighted score in cell D6.
Viewed: 617 times
For Better experience and learning,for video answers, after video ends playing, click next question in the questions list!!!
Share in:
Questions List:
1. Outline three features of a graphical user interface in operating systems
2. Describe each of the following types of the operating system. i)Distributed operating system ii)Multiprocessing operating system.
3. Alice intends to create a document using a word processing program. Outline four types of computer keyboard keys she is likely to use during this process
4. Joab created slides using a presentation program. Outline four ways he could view the slides
5. State six functions of an operating system software in a computer system.
6. Explain the function of each of the following data types as used in database table. i)OLE object; ii)Hyperlink.
7. Distinguish between data source and main document as used in word processing programs
8. Susan used master slides in a presentation she created. Outline four kinds of master slide she could have used
9. Karaha Ltd intends to connect its computers to the internet. Outline three types of Internet services they would get from this connectivity
10. Distinguish between a macro and a module as used in databases
11. Figure 1 shows the errors generated when a strong formula is entered in cell C1 and C2 in a worksheet. Write the formula that may have been entered in the cells to generate the errors in cell C1 and C2.
12. Marion has been tasked to design wedding cards for her friend using a desktop publication application. Outline four types of layout guides she could use while designing the cards.
13. With the aid of two examples, explain the term transition as used in presentation program.
14. Julie intends to add a table in a database she created. Outline four ways she could achieve this
15. Figure 2 is a spreadsheet extract. Use it to answer the questions that follow Using a function and cell addresses only, write a formula that may have been used to compute each of the following; i)weighted score in cell D3 ii)average weighted score in cell D6.
16. An organization has noted that the security of their data in the database is compromised. Explain two types of threats that the database could have been exposed to
17. State six effects that could be applied to the shape created in a slide of a presentation program.
18. Distinguish between tracking and leading as used in desktop publishing applications
19. Joan entered the number 13000.8779 in cell A1 of a worksheet in a spreadsheet. Write a formula that would be used to round the number; i)to the nearest integer ii)as a multiple of 5.
20. Outline three ways that could be used to align text in a paragraph while designing a brochure in a desktop publishing application
21. Explain the circumstance that would necessitate the use of each of the following operators when querying a database. i)AND ii)OR
22. San intends to view a report created using a database program before printing. Explain two ways he could use to achieve this
23. Peter intends to print slides created using a presentation program. Outline four options he could use to print the slides
1. Outline three features of a graphical user interface in operating systems
2. Describe each of the following types of the operating system. i)Distributed operating system ii)Multiprocessing operating system.
3. Alice intends to create a document using a word processing program. Outline four types of computer keyboard keys she is likely to use during this process
4. Joab created slides using a presentation program. Outline four ways he could view the slides
5. State six functions of an operating system software in a computer system.
6. Explain the function of each of the following data types as used in database table. i)OLE object; ii)Hyperlink.
7. Distinguish between data source and main document as used in word processing programs
8. Susan used master slides in a presentation she created. Outline four kinds of master slide she could have used
9. Karaha Ltd intends to connect its computers to the internet. Outline three types of Internet services they would get from this connectivity
10. Distinguish between a macro and a module as used in databases
11. Figure 1 shows the errors generated when a strong formula is entered in cell C1 and C2 in a worksheet. Write the formula that may have been entered in the cells to generate the errors in cell C1 and C2.
12. Marion has been tasked to design wedding cards for her friend using a desktop publication application. Outline four types of layout guides she could use while designing the cards.
13. With the aid of two examples, explain the term transition as used in presentation program.
14. Julie intends to add a table in a database she created. Outline four ways she could achieve this
15. Figure 2 is a spreadsheet extract. Use it to answer the questions that follow Using a function and cell addresses only, write a formula that may have been used to compute each of the following; i)weighted score in cell D3 ii)average weighted score in cell D6.
16. An organization has noted that the security of their data in the database is compromised. Explain two types of threats that the database could have been exposed to
17. State six effects that could be applied to the shape created in a slide of a presentation program.
18. Distinguish between tracking and leading as used in desktop publishing applications
19. Joan entered the number 13000.8779 in cell A1 of a worksheet in a spreadsheet. Write a formula that would be used to round the number; i)to the nearest integer ii)as a multiple of 5.
20. Outline three ways that could be used to align text in a paragraph while designing a brochure in a desktop publishing application
21. Explain the circumstance that would necessitate the use of each of the following operators when querying a database. i)AND ii)OR
22. San intends to view a report created using a database program before printing. Explain two ways he could use to achieve this
23. Peter intends to print slides created using a presentation program. Outline four options he could use to print the slides
