TIME: 3 HOURS
INSTRUCTIONS: ANSWER ALL QUESTIONS.
Section A (30 marks)
1. Spreadsheets are examples of _______________software.
A. Application
B. Inbuilt
C. System
D. Shareware
2. Which one of the following key combination is used to cut selected text and save it to the clipboard ready to paste elsewhere?
A. Crtl+X
B. Ctrl+End
C. Ctrl+W
D. Ctrl+Home
3. Identify a feature in office applications that is part of the spell checker to correct common spelling or typing errors, saving time for the user.
A. Auto Format
B. Autocorrect
C. Auto Change
D. Smart tags
4. Which one of the following is a cell reference that adjusts and change when copied for example using auto-fill such as SUM (B9:B15)?
A. Relative
B. Absolute
C. Active
D. Anchor
5. __________________shows the different levels of headings as designated by the styles applied in your document.
A. Outline view
B. Notes page view
C. Slide sorter
D. Slide show
6. The left border, Right border and Center are part of horizontal alignment for Data in a cell.
A. True
B. False
7. Which one of the following key combination is used to open an existing power-point document?
A. Ctrl+ C
B. Ctrl+ O
C. Ctrl+ E
D. Ctrl+ U
8. _____________ function returns the correct position of sorted or unsorted data.
A. Sum()
B. LCM()
C. Sort()
D. Rank()
9. Which one of the following is a technology used to combine information from different applications into your tables in access?
A. Ole Object
B. Memo
C. Lookup Wizard
D. Hyperlink
10. _______________refers to set of instructions started by the user, program, or operating system.
A. Thread
B. Software
C. Process
D. Service
11. __________________is used to control the margins of your page and the indentation of paragraphs.
A. Margin
B. Padding
C. Ruler
D. Ribbon
12. _____serves as a starting point for a new document in windows.
A. Workbook
B. Macros
C. Template
D. Modules
13. The introductory slide in a presentation is known as?
A. Main slide
B. Title slide
C. Bullet slide
D. Table slide
14. When ____________is pressed it moves the cursor to the beginning of a line?
A. End
B. Page Down
C. Home
D. Insert
15. Which feature of a word processor is used to check synonyms of the text?
A. Spelling
B. Thesaurus
C. Find
D. Mail merge
16. Which of the following is the method for increasing text to make it legible?
A. Ctrl+Z
B. CTRL++
C. View
D. Home
17. An intersection between a row and a column is known as?
A. Data
B. Cell
C. Row
D. Column
18. Which of the following is produced using a publishing software?
A. Calendars
B. Reports
C. Analysis
D. Presentations
19. Which of the following controls all information about the theme, layout, background, color, fonts, and positioning of all slides?
A. File settings
B. Main slide
C. Master slide
D. Settings file
20. A field that uniquely identifies a record is known as?
A. Primary key
B. Alternate key
C. Main record
D. Foreign key
21. Which of the following is true about default printer in a computer system?
A. The printer that prints all jobs unless specified.
B. Printer connected directly to a computer
C. Printer connected through a network
D. Plug and play printer
22. Which of the following is an input as well as output device?
A. Touch screen
Mouse
B. Keyboard
C. Printer
23. Which one of the following accounts allow users to carry out tasks that require special permissions, such as installing software or renaming a computer?
A. Administrator account
B. Standard account
C. Guest account
D. Default account
24. __________________ is used to navigate the file system and manage the folders, sub-folders, and applications on storage media.
A. Internet explorer
B. Finder
C. Vscode
D. File explorer
25. Which one of the following is a logical function that returns one return one value if a condition is true and
another value if it’s false?
A. SUM
B. COUNTIF
C. AND D. IF
26. Which of the following keys opens the help window?
A. F12
B. F1
C. F8
D. F9
27. Which one of the following uses is NOT associated with Excel?
A. Financial analysis
B. Charting and graphing
C. Statistical Analysis
D. Programming
28. _________________ are animation-like effects that happen when you move from one slide to the next during a presentation.
A. Slide view
B. Slide show
C. Slide Sorter
D. Slide transitions
29. Which one of the following is used to select the objects that you want to have the same formatting in PowerPoint?
A. Ctrl+Shift+V
B. Ctrl+Shift+C
C. Ctrl+Shift+Drag
D. Ctrl+Shift+>
30. _______________is an Access object used to view, analyze, or modify data.
A. Worksheets
B. Form
C. Queries
D. Reports.
QUESTION 32
Consider the following information.
Slide 1
War and warfare
By James
Slide 2
Causes of war
Types of war
Popular war equipment
Dealing with war
Slide 3
Causes of war
Religion.
Nationalism.
Revenge.
Civil War.
Revolutionary War.
Defensive War.
Slide 4
Types of war
Cold.
Colonial war.
Invasion.
Proxy war.
Slide 5
Dealing with war
Talk about it.
Take care of yourself.
Limit exposure to images of the war
Ask for help.
Required:
Using a presentation software, enter the above information in a presentation software and name as
“QUESTION TWO”. (15mks)
3. Apply a slide transition of your choice for the first two slides (2mks)
Create a diagram as shown below. (8mks)
QUESTION 34
Using a desktop publisher design the publication below (10 marks)
