<=Back
<=KNEC Craft certificate in ICT Module 1: Computer Application I theory past paper July 2017
Table 1 shows an extract of a spreadsheet document showing the details of staff payroll in a manufacturing company. Use it to answer the questions that follow
a)Write a formula that would be used to compute the Gross salary for Joseph
b)Suppose the manager wanted the data in the worksheet arranged from the highest to the lowest paid staff and then alphabetically by Staff Names. Describe a spreadsheet feature he could use to achieve its objective
a)Write a formula that would be used to compute the Gross salary for Joseph
b)Suppose the manager wanted the data in the worksheet arranged from the highest to the lowest paid staff and then alphabetically by Staff Names. Describe a spreadsheet feature he could use to achieve its objective
Viewed: 524 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. With the aid of a diagram, differentiate between landscape and portrait page layouts as used in word processing documents
2. Explain the term worksheet as used in spreadsheet programs
3. Explain the function textbox feature as used in word processing programs.
4. Explain the term data validation as applied spreadsheet programs
5. Explain a reason why a database administrator would use a table template when creating a new database
6. Linet intends to restrict access to part of the worksheet she was working on. Explain a spreadsheet feature she could apply to achieve her objective
7. Explain the function of the Esc key of a computer keyboard
8. A company with many branches prefers to use video conferencing to a boardroom conferencing. Outline two reasons for their preference.
9. Differentiate between primary and secondary files as used in a mail merge feature of a word processing program
10. Explain a circumstance under which a many-to-many table relationship would be established in a database program
11. Table 1 shows an extract of a spreadsheet document showing the details of staff payroll in a manufacturing company. Use it to answer the questions that follow a)Write a formula that would be used to compute the Gross salary for Joseph b)Suppose the manager wanted the data in the worksheet arranged from the highest to the lowest paid staff and then alphabetically by Staff Names. Describe a spreadsh
12. An examination database stores details of students who sat for an exam. Each record has the following fields: (2marks) -Student ID Number -The student passport sized photo -Scores for each subject. -Total Fees Balance. State suitable data type for each of the fields
13. State the function of each of the following folders in an email program i)inbox ii) spam
14. Explain the function of the slide sorter feature as used in presentation programs
15. A company which deals with the importation of second hand motor vehicles has a website with various hyperlinks. Explain the function of this feature on the website
16. Gerald intends to print a spreadsheet document with no gridlines shown on the print out. Describe the feature he would use to achieve his objective
17. Cate intends to change the object in figure 2 to resemble the object in figure 3 Describe a presentation program feature she would use to achieve her objective
1. With the aid of a diagram, differentiate between landscape and portrait page layouts as used in word processing documents
2. Explain the term worksheet as used in spreadsheet programs
3. Explain the function textbox feature as used in word processing programs.
4. Explain the term data validation as applied spreadsheet programs
5. Explain a reason why a database administrator would use a table template when creating a new database
6. Linet intends to restrict access to part of the worksheet she was working on. Explain a spreadsheet feature she could apply to achieve her objective
7. Explain the function of the Esc key of a computer keyboard
8. A company with many branches prefers to use video conferencing to a boardroom conferencing. Outline two reasons for their preference.
9. Differentiate between primary and secondary files as used in a mail merge feature of a word processing program
10. Explain a circumstance under which a many-to-many table relationship would be established in a database program
11. Table 1 shows an extract of a spreadsheet document showing the details of staff payroll in a manufacturing company. Use it to answer the questions that follow a)Write a formula that would be used to compute the Gross salary for Joseph b)Suppose the manager wanted the data in the worksheet arranged from the highest to the lowest paid staff and then alphabetically by Staff Names. Describe a spreadsh
12. An examination database stores details of students who sat for an exam. Each record has the following fields: (2marks) -Student ID Number -The student passport sized photo -Scores for each subject. -Total Fees Balance. State suitable data type for each of the fields
13. State the function of each of the following folders in an email program i)inbox ii) spam
14. Explain the function of the slide sorter feature as used in presentation programs
15. A company which deals with the importation of second hand motor vehicles has a website with various hyperlinks. Explain the function of this feature on the website
16. Gerald intends to print a spreadsheet document with no gridlines shown on the print out. Describe the feature he would use to achieve his objective
17. Cate intends to change the object in figure 2 to resemble the object in figure 3 Describe a presentation program feature she would use to achieve her objective
