<=Back
<=KNEC Diploma in ICT module 1 Computer Applications I past paper:November 2017
Table 1 is a section of worksheet showing cash expenditure in Kenya shillings by departments for certain organization. Use it to answer the questions that follow.
i)Using a function and cell address only, write a formula that would be used to calculate the Average expenditure for accounts department
ii)Using the IF function, write a formula that would be used to enter remark
for Accounts department as “Excess Expenditure” when the average expenditure is over 80,000 and “Optimal Expenditure” when its less than 80,000
i)Using a function and cell address only, write a formula that would be used to calculate the Average expenditure for accounts department
ii)Using the IF function, write a formula that would be used to enter remark
for Accounts department as “Excess Expenditure” when the average expenditure is over 80,000 and “Optimal Expenditure” when its less than 80,000
Viewed: 625 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. State the full meaning of each of the following acronyms as used in desktop Publishing: i)WMT; ii)EPS; iii)TIFF; iv)JPEG.
2. Mercy intends to teach her class using a presentation program. Outline three ways she could run the slide show.
3. Distinguish between hypertext and hypermedia as used in internet programs
4. Joan has been advised to use macros to run various repetitive tasks in a word processing program. Outline four advantages of using this feature
5. Outline three applications of spreadsheet program in a banking sector
6. Differentiate between form header and page header as used in databases
7. Bitech Company intends to use distributed operating systems for their management information system in its various branches. Outline four benefits the the company would get from this move
8. Explain the function of each of the following system utilities: i)disk cleanup; ii)disk defragmenter
9. Lydiah has been tasked to create a student magazine using a publishing program. i)Outline three approaches she could use to create a new publication ii)Assume she decided to use a master page for this publication. Explain two reasons for her decision.
10. Distinguish between the functions of ruler guides and margin guides as used in desktop publishing programs.
11. Describe the mail merge feature as used in word processing programs
12. Explain the function of each of the following features as used in presentation programs. i)Record narration; ii)Rehearse timings.
13. Explain the function of each of the following views as used in presentation programs. i)Outline; ii)Notes page.
14. Data integrity ensures the correctness and completeness of the data in the database. Explain three types of integrity constraints that could be enforced during the creation of databases.
15. Table 1 is a section of worksheet showing cash expenditure in Kenya shillings by departments for certain organization. Use it to answer the questions that follow.
16. State four examples of items that could be used as header and footer on the notes and handout page of a Presentation.
17. Table 2 is a worksheet extract showing total sales in Kenya shillings made by salesmen of a certain company. Use it to answer the questions that follow With the aid of an illustration, write the expected results from the worksheet after performing each of the following commands on the data. i)Sorting the data using the salesman column. ii)Filtering data with the average sales greater or equal
18. The principal of VIBS College intends to extract the following information from the College’s database. State the criteria that could be used to achieve this. i)Details of students admitted from 1/07/2015 to 31/12/2015; ii)All students whose names begin with letter M
1. State the full meaning of each of the following acronyms as used in desktop Publishing: i)WMT; ii)EPS; iii)TIFF; iv)JPEG.
2. Mercy intends to teach her class using a presentation program. Outline three ways she could run the slide show.
3. Distinguish between hypertext and hypermedia as used in internet programs
4. Joan has been advised to use macros to run various repetitive tasks in a word processing program. Outline four advantages of using this feature
5. Outline three applications of spreadsheet program in a banking sector
6. Differentiate between form header and page header as used in databases
7. Bitech Company intends to use distributed operating systems for their management information system in its various branches. Outline four benefits the the company would get from this move
8. Explain the function of each of the following system utilities: i)disk cleanup; ii)disk defragmenter
9. Lydiah has been tasked to create a student magazine using a publishing program. i)Outline three approaches she could use to create a new publication ii)Assume she decided to use a master page for this publication. Explain two reasons for her decision.
10. Distinguish between the functions of ruler guides and margin guides as used in desktop publishing programs.
11. Describe the mail merge feature as used in word processing programs
12. Explain the function of each of the following features as used in presentation programs. i)Record narration; ii)Rehearse timings.
13. Explain the function of each of the following views as used in presentation programs. i)Outline; ii)Notes page.
14. Data integrity ensures the correctness and completeness of the data in the database. Explain three types of integrity constraints that could be enforced during the creation of databases.
15. Table 1 is a section of worksheet showing cash expenditure in Kenya shillings by departments for certain organization. Use it to answer the questions that follow.
16. State four examples of items that could be used as header and footer on the notes and handout page of a Presentation.
17. Table 2 is a worksheet extract showing total sales in Kenya shillings made by salesmen of a certain company. Use it to answer the questions that follow With the aid of an illustration, write the expected results from the worksheet after performing each of the following commands on the data. i)Sorting the data using the salesman column. ii)Filtering data with the average sales greater or equal
18. The principal of VIBS College intends to extract the following information from the College’s database. State the criteria that could be used to achieve this. i)Details of students admitted from 1/07/2015 to 31/12/2015; ii)All students whose names begin with letter M
