<=Back
<=KNEC Craft certificate in ICT module 1: Computer Applications I theory past paper November 2017
Figure 2 is an extract of a worksheet showing daily sales made at Mama Zawadi shop. Use it to answer the questions that follow
a)Using cell references only, write a formula that could be used to calculate the total sales.
b)Using the sumproduct function and cell references only, write a formula to determine the total profit
a)Using cell references only, write a formula that could be used to calculate the total sales.
b)Using the sumproduct function and cell references only, write a formula to determine the total profit
Viewed: 564 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 two positive impacts of internet to the society
2. Differentiate between the terms server and client as used in internet connectivity
3. List two challenges that end users face while using command user interfaces
4. Explain the function of the macro tool in a word processing application
5. Figure 2 is an extract of a worksheet showing daily sales made at Mama Zawadi shop. Use it to answer the questions that follow a)Using cell references only, write a formula that could be used to calculate the total sales. b)Using the sumproduct function and cell references only, write a formula to determine the total profit
6. Table 1 shows a database table containing student details. Use it to answer the questions that follow i)State the appropriate field that could be used as a primary key. ii)Give one reason for your answer in (i).
7. Explain the term referential integrity as used in database applications
8. Explain the function of each of the following print options on a presentation program a)Slides b)Handouts
9. Adada has prepared a presentation and wishes to have her name and registration number appear at the bottom and top of every slide respectively. Describe the presentation tool that she could use to achieve this.
10. Differentiate between an email mail merging and letter mail merging as used in word processing
11. Describe systems software as used in computer systems
12. Explain a circumstance under which the Blind Carbon Copy (Bcc) option could be used when sending an email.
13. Computer devices such as keyboard and mice have become wireless due to technological developments. State two advantages of such wireless devices.
14. Differentiate between the terms auto correct and auto complete as used in word processing applications.
15. Figure 3 shows an extract of a worksheet. Use it to answer the questions that follow i)Assuming the records are to be arranged alphabetically on student names’ column, describe a spreadsheet tool that could be used to achieve this. ii)Describe a spreadsheet tool that could be used to display the names of students who have scored more than 50 marks
1. Outline two positive impacts of internet to the society
2. Differentiate between the terms server and client as used in internet connectivity
3. List two challenges that end users face while using command user interfaces
4. Explain the function of the macro tool in a word processing application
5. Figure 2 is an extract of a worksheet showing daily sales made at Mama Zawadi shop. Use it to answer the questions that follow a)Using cell references only, write a formula that could be used to calculate the total sales. b)Using the sumproduct function and cell references only, write a formula to determine the total profit
6. Table 1 shows a database table containing student details. Use it to answer the questions that follow i)State the appropriate field that could be used as a primary key. ii)Give one reason for your answer in (i).
7. Explain the term referential integrity as used in database applications
8. Explain the function of each of the following print options on a presentation program a)Slides b)Handouts
9. Adada has prepared a presentation and wishes to have her name and registration number appear at the bottom and top of every slide respectively. Describe the presentation tool that she could use to achieve this.
10. Differentiate between an email mail merging and letter mail merging as used in word processing
11. Describe systems software as used in computer systems
12. Explain a circumstance under which the Blind Carbon Copy (Bcc) option could be used when sending an email.
13. Computer devices such as keyboard and mice have become wireless due to technological developments. State two advantages of such wireless devices.
14. Differentiate between the terms auto correct and auto complete as used in word processing applications.
15. Figure 3 shows an extract of a worksheet. Use it to answer the questions that follow i)Assuming the records are to be arranged alphabetically on student names’ column, describe a spreadsheet tool that could be used to achieve this. ii)Describe a spreadsheet tool that could be used to display the names of students who have scored more than 50 marks
