<=Back
<=KNEC Craft certificate in ICT module 1: Computer Applications I theory past paper November 2018
Differentiate between sorting and filtering data as used in spreadsheet program
Viewed: 593 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 effect of applying each of the following mouse techniques to a computer folder; i)right click ii)double click
2. Most computer users opt for operating systems that offer a graphical user interface. Outline two benefits they get from this interface
3. Moses has prepared a word processing document that has four paragraphs. He intends to move the first paragraph to the end of the document. Describe the feature he would use to achieve his objective
4. Explain the purpose of the section break feature in a word processing program
5. State one benefit of using document templates in a word program
6. Ann created the following documents using a word processing program. Use it to answer the question that follows. State six formatting features that she applied on the document.
7. John intends to use a macro to apply the same formats to many worksheets in workbook. Explain one benefit that he would have from using this tool
8. Differentiate between sorting and filtering data as used in spreadsheet program
9. Explain the function of the freeze pane feature in a spreadsheet program
10. Joan wishes to have a column containing formulas in a worksheet not visible to users. Explain in a spreadsheet program feature that she could use to achieve this.
11. Explain one benefit of using forms in a database application
12. Explain the term criteria as used in database querying
13. Big Deal Company has opted to use an online word processing program rather than the traditional offline word processors. State two benefits the company could get from using this approach
14. Janet wishes to have a personal computer connected to the internet. Outline two hardware devices required for her to achieve her objective
15. Jean is going to present her project using equipment provided by the college. i)Explain why she may need to package her presentation ii)Outline two ways she would make use of the slide sorter view while preparing her presentation
16. List two examples of database management systems
17. With the aid of a diagram describe the hierarchical database model
1. State the effect of applying each of the following mouse techniques to a computer folder; i)right click ii)double click
2. Most computer users opt for operating systems that offer a graphical user interface. Outline two benefits they get from this interface
3. Moses has prepared a word processing document that has four paragraphs. He intends to move the first paragraph to the end of the document. Describe the feature he would use to achieve his objective
4. Explain the purpose of the section break feature in a word processing program
5. State one benefit of using document templates in a word program
6. Ann created the following documents using a word processing program. Use it to answer the question that follows. State six formatting features that she applied on the document.
7. John intends to use a macro to apply the same formats to many worksheets in workbook. Explain one benefit that he would have from using this tool
8. Differentiate between sorting and filtering data as used in spreadsheet program
9. Explain the function of the freeze pane feature in a spreadsheet program
10. Joan wishes to have a column containing formulas in a worksheet not visible to users. Explain in a spreadsheet program feature that she could use to achieve this.
11. Explain one benefit of using forms in a database application
12. Explain the term criteria as used in database querying
13. Big Deal Company has opted to use an online word processing program rather than the traditional offline word processors. State two benefits the company could get from using this approach
14. Janet wishes to have a personal computer connected to the internet. Outline two hardware devices required for her to achieve her objective
15. Jean is going to present her project using equipment provided by the college. i)Explain why she may need to package her presentation ii)Outline two ways she would make use of the slide sorter view while preparing her presentation
16. List two examples of database management systems
17. With the aid of a diagram describe the hierarchical database model
