<=Back
<=KNEC Diploma in ICT module 1 Computer Applications I past paper: November 2022
Figure 1 is a spreadsheet extract showing revenue and expenditure for a country for a period of 5 years. Use it to answer the questions that follows.
(i)Using cell addresses, write the formula that would be used to compute Total revenue for the five years in cell G2
(ii)Use If function to write a formula in cell B5 that would Display the comment “PROFIT” if the revenue exceeds the expenditure otherwise to display “LOSS” for the five years
(i)Using cell addresses, write the formula that would be used to compute Total revenue for the five years in cell G2
(ii)Use If function to write a formula in cell B5 that would Display the comment “PROFIT” if the revenue exceeds the expenditure otherwise to display “LOSS” for the five years
Viewed: 417 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 advantages that an organization would get for using Email for their communication
2. Describe each of the following as used in desktop publishing application: (4 mark) (i) bleed; ii) Crop
3. Distinguish between device drivers and firmware as used in computers.
4. Nancy was tasked to design a database for data storage. Outline four types of keys she may use when creating the database fields
5. Outline the meaning of each of the following database concepts: (3 marks) i. Data security; ii) Data quality iii) Data integrity
6. Rose was tasked to design a database for an organisation data storage. outline four properties she may use when creating the database fields
7. A company’s Technician was required to design a network operating system. Explain two types of operating system design he could apply.
8. Joel was tasked to source an internet service provider to supply his college with internet. outline four other than cost the he should consider during the selection.
9. Outline the function of each of the following formula in a spreadsheet program: (i) IF; ii)Len iii)Concatenate
10. Explain one circumstance in each case that would necessitate the use of the following features in a word processing program. (4 marks) (i) Split window; ii)Zoom
11. Distinguish between a ruler guide and a column guide as applied in desktop publishing program
12. Agnes intends to align text in a slide created using a presentation program. Outline four text alignment she could apply.
13. State three reasons for using queries in database management system
14. Explain one function of each of the following database objects: (4 marks) (i) Forms; ii) reports
15. Lydia intends to use a tab stop feature to align text in a document created using a word processing program. Explain four examples of stop tab that she could apply
16. Outline the function of each of the following data types in a database: (3 marks) (i) AutoNumber; ii)Memo iii)Look up wizard
17. Distinguish between rotate and flip operation as used in Desktop publishing applications
18. Figure 1 is a spreadsheet extract showing revenue and expenditure for a country for a period of 5 years. Use it to answer the questions that follows. (i)Using cell addresses, write the formula that would be used to compute Total revenue for the five years in cell G2 (ii)Use If function to write a formula in cell B5 that would Display the comment “PROFIT” if the revenue exceeds the expenditure
19. Patrick created a presentation which he wishes to print. Outline four types of print layout he could use to print the presentation.
20. Explain each of the features as used in spreadsheet program: (i) sort; ii)Filter
21. David intend to include speaker notes in slides created using a presentation program. (i) Outline three items that he may include as speaker notes. ii)Outline two ways he could access the speaker notes during a presentation.
22. With the aid of a sketch in each case, describe the following components of an entity data model in database (i)Attributes ii)Relationships;
1. Outline three advantages that an organization would get for using Email for their communication
2. Describe each of the following as used in desktop publishing application: (4 mark) (i) bleed; ii) Crop
3. Distinguish between device drivers and firmware as used in computers.
4. Nancy was tasked to design a database for data storage. Outline four types of keys she may use when creating the database fields
5. Outline the meaning of each of the following database concepts: (3 marks) i. Data security; ii) Data quality iii) Data integrity
6. Rose was tasked to design a database for an organisation data storage. outline four properties she may use when creating the database fields
7. A company’s Technician was required to design a network operating system. Explain two types of operating system design he could apply.
8. Joel was tasked to source an internet service provider to supply his college with internet. outline four other than cost the he should consider during the selection.
9. Outline the function of each of the following formula in a spreadsheet program: (i) IF; ii)Len iii)Concatenate
10. Explain one circumstance in each case that would necessitate the use of the following features in a word processing program. (4 marks) (i) Split window; ii)Zoom
11. Distinguish between a ruler guide and a column guide as applied in desktop publishing program
12. Agnes intends to align text in a slide created using a presentation program. Outline four text alignment she could apply.
13. State three reasons for using queries in database management system
14. Explain one function of each of the following database objects: (4 marks) (i) Forms; ii) reports
15. Lydia intends to use a tab stop feature to align text in a document created using a word processing program. Explain four examples of stop tab that she could apply
16. Outline the function of each of the following data types in a database: (3 marks) (i) AutoNumber; ii)Memo iii)Look up wizard
17. Distinguish between rotate and flip operation as used in Desktop publishing applications
18. Figure 1 is a spreadsheet extract showing revenue and expenditure for a country for a period of 5 years. Use it to answer the questions that follows. (i)Using cell addresses, write the formula that would be used to compute Total revenue for the five years in cell G2 (ii)Use If function to write a formula in cell B5 that would Display the comment “PROFIT” if the revenue exceeds the expenditure
19. Patrick created a presentation which he wishes to print. Outline four types of print layout he could use to print the presentation.
20. Explain each of the features as used in spreadsheet program: (i) sort; ii)Filter
21. David intend to include speaker notes in slides created using a presentation program. (i) Outline three items that he may include as speaker notes. ii)Outline two ways he could access the speaker notes during a presentation.
22. With the aid of a sketch in each case, describe the following components of an entity data model in database (i)Attributes ii)Relationships;
