<=Back
Viewed: 303 times
Share in:
<=Craft Certificate in Information Studies Module 1, Computer Application (Theory) Past Paper July 2015
With aid of examples in each case, explain the following types of cell references as used in spreadsheet programs
a)Absolute
b)Relative
a)Absolute
b)Relative
Viewed: 303 times
Share in:
Questions List:
1. Explain two advantages of the graphical user interface in computers
2. Jane comes across the following types of software when revising for examination; antivirus, Linux, backup software and android classify them as either utility or operating software.
3. Outline the function of each of the following keyboard key; (i) F10 (1 mark) (ii) Escape (1 mark)
4. Explain the term conditional formatting as used in the spreadsheet application
5. Distinguish between auto complete and auto correct are used in word processing application
6. With aid of examples in each case, explain the following types of cell references as used in spreadsheet programs a)Absolute b)Relative
7. Outline two forms in database programs
8. Figure 1 shows an extract of a worksheet. Use it to answer the question that follows Write a formula in cell B8 that could be used to count Mellon occurrence
9. Zippy set the following field properties in a data table (i)input mask (ii) Indexed. Explain the function of each property
10. With an aid of a diagram, explain each of the following types of relationships as applied in database application. (i)one-to-many ii)Many-to-Many
11. Kirundi secondary school intends to introduce the use of internet to its students. Explain two negative social security issues that students are likely to be exposed
12. Moses intends to print 20 slides presentations and produces four slides per page. Explain the feature that he could use to achieve this objective
13. Wireless fidelity (Wi-Fi) has become one of the most popular modes of internet connection in recent days .Explain two reason for this trend
14. Explain the function of format painter feature as applied in computer application
15. Explain the circumstance under which hide slide feature would be used in presentation
1. Explain two advantages of the graphical user interface in computers
2. Jane comes across the following types of software when revising for examination; antivirus, Linux, backup software and android classify them as either utility or operating software.
3. Outline the function of each of the following keyboard key; (i) F10 (1 mark) (ii) Escape (1 mark)
4. Explain the term conditional formatting as used in the spreadsheet application
5. Distinguish between auto complete and auto correct are used in word processing application
6. With aid of examples in each case, explain the following types of cell references as used in spreadsheet programs a)Absolute b)Relative
7. Outline two forms in database programs
8. Figure 1 shows an extract of a worksheet. Use it to answer the question that follows Write a formula in cell B8 that could be used to count Mellon occurrence
9. Zippy set the following field properties in a data table (i)input mask (ii) Indexed. Explain the function of each property
10. With an aid of a diagram, explain each of the following types of relationships as applied in database application. (i)one-to-many ii)Many-to-Many
11. Kirundi secondary school intends to introduce the use of internet to its students. Explain two negative social security issues that students are likely to be exposed
12. Moses intends to print 20 slides presentations and produces four slides per page. Explain the feature that he could use to achieve this objective
13. Wireless fidelity (Wi-Fi) has become one of the most popular modes of internet connection in recent days .Explain two reason for this trend
14. Explain the function of format painter feature as applied in computer application
15. Explain the circumstance under which hide slide feature would be used in presentation
