COMPUTING INFORMATION SYSTEM APPLICATIONS APRIL 2022 PAST PAPER

TIME:3HRS
INSTRUCTIONS: ANSWER ALL QUESTIONS. MARKS ALLOCATED TO EACH QUESTION ARE SHOWN

SECTION I
1. Which one among the following is a user interface that allows the user to interact with the operating system working with icons and menus?
a. API
b. CLI
c. GUI
d. PnP

2. Which one of the following is a built-in user account provided the operating system?
a. Administrator account
b. Standard account
c. Guest account
d. Default account

3. Which one of the following is not a benefit associated with New technology File system (NTFS)?
a. Performance
b. Security access control
c. Disk space utilization
d. Intermediary between user and hardware.

4. Which one of the following tasks would best suitable the use of a word processor document?
a. Compute income and expenditure
b. Draw a diagram
c. Paint a picture
d. Type board meeting minutes

5. Which one of the following key combination moves the cursor to the end of the document?
a) Crtl+X
b) Ctrl+End
c) Ctrl+W
d) Ctrl+Home

6. Which one of the following keys is used to increase left indents?
a. Ctrl+I
b. Ctrl+M
c. Alt+I
d. Escape

7. Identify the use of pasteboard in graphics design.
a. Working area                                                                                                                                                                                                                   b. Print graphics
c. Backup graphics
d. Placing unwanted graphics

8. Identify the output device that produces durable carbon copies.
a. Laser printer
b. Dot matrix
c. Inkjet
d. Thermal

9. Identify the word processor feature in this text X2
a. subscript
b. Superscript
c. Window
d. Orphans

10. Which one of the following is a cell reference in spreadsheets that does not change when it is copied?
a. Relative
b. Absolute
c. Active
d. Anchor

11. Which one of the following is a special toolbar at the top of the Excel worksheet window, labeled with function symbol (fx)?
a. Psi function
b. Menu
c. Icon
d. Formula bar

12. What is the name of the intersection between a row and a column in spreadsheets applications?
a. Cell
b. Tabs
c. Name box
d. Worksheet

13. Which one of the following is a file extension for excel files?
a. .doc
b. .xls
c. .ppt
d. .db

14. Which one among the following is a feature in excel that fixes a row or column to be displayed when scrolling in spreadsheet?
a. Freeze pane tool
b. Format Painter tool
c. Go To tool
d. Autofill Tool

15. Excel charts allow spreadsheet users to create visualizations of data sets. What is the name of the region surrounding the chart?
a. Legend
b. Axis
c. Plot area
d. Chart area

16. Which of the following technology stores volatile data?
a. RAM
b. EPROM
c. EEPROM
d. Flash disk

17. What is the name given to giving live to text in presentation applications?
a. Transition                                                                                                                                                                                                                            b. Slide show
c. Animation
d. Fade

18. The interlinking of worldwide computers for communication purposes over the public network is called?
a. Network
b. WWW
c. Web
d. Internet

19. Where is the physical location of swap memory in a computer system?
a. RAM
b. ROM
c. Hard disk
d. Flash disk

20. Which one of the following functions counts the number of cells within a range that meet a given criteria?
a. COUNTA
b. COUNTBlank
c. COUNTIF
d. ACCRINT

21. The trimming of excess area of an image in Desktop publishing is called:
a. Framing
b. Bleeding
c. Cropping
d. Layering

22. ___________is the slide that controls the design of all other slides.
a. Master slide
b. Title slide
c. Formatting slide
d. Editing slide

23. Which of the following is an internet protocol that automatically translates internet addresses to their numeric machines address that computers use?
a. HTTP
b. DNS
c. FTP
d. NAT

24. Which one among the following is NOT an Access Database object?
a. Worksheets
b. Forms
c. Queries
d. Reports.

25. Which one of the following establishes a relationship between tables?
a. Ole Object
b. Memo
c. Lookup Wizard
d. Hyperlink

26. Identify the query that displays its own dialog box prompting you to enter information before executing.
a. Select Query
b. Crosstab Query
c. Dialog Query
d. Parameter Query

27. Which among the following allows you to navigate around your Access database application?
a. Database Window                                                                                                                                                                                                             b. Design View Window
c. Switchboard
d. Query Window

28. Which one among the following indicates the format of valid input values such as ##### being displayed when one enters data?
a. Input Mask
b. Subnet mask
c. Indexed
d. Validation Rule

29. Which of the following Desktop Publishing tools is used to locate the exact position to place graphics?
a. Ruler
b. Gridlines
c. Pixels
d. Pasteboard

30. A set of instructions that perform a specific task is known as?
a. Hardware
b. CPU
c. Software
d. Orgware

SECTION II

QUESTION 31
a. Create the following table and enter the following details using a word processor application and save it as “Question one”.

b. Compute savings using table formula as income minus expenses for Farming type (3 mks)

c. Calculate totals for “Income”,”expenses”, and “savings” for all types of farming (3 mks)

d. Add a row just below totals for the projections and compute average for “Income”,”expenses”, and “savings” for all types of farming.(3 mks)

QUESTION 32

Consider the information from Mr. Kioko’s presentation below
Slide 1:

Slide 2:
Group 1
Drawing
Painting
Photography

Slide 3:
Group 2
Modelling
Dress Making
Printing

Slide 4:
Group 3
Hill walking
Hiking
Cycling

Required
a. Create a power point presentation and save as “Question 2” (6 mks)
b. Input the following data in slide one. “GROUPS”, “BY MR. KIOKO” (2 mks)
c. Insert a new slide after slide 4 and input the following information (5 mks)

d. Insert a slide after the one in (c). Insert a column chart to compare the % per hob(3mks)
e. Apply animation of your choice for text in slide 1 and 2 (4mks)

SOLUTION

QUESTION 33

Consider the information below about Mavuno land buying company

a. Enter the above data in a spreadsheet software as it is and save it as “plots” (8 marks)
b. Perform the following calculations using functions insert the relevant row or column header

  • Total contributions for each person (4 marks)
  • Input the target contribution for all members as 1,800,000 (3 marks)
  • While refereeing to the cell with the value 1,800,000 in (ii) above calculate the deficit for each member (5 marks)

SOLUTION

(Total:20 marks)

QUESTION 34

Using a desktop publisher create the following publication name it as “Question 4” (15 marks)

(Visited 12 times, 1 visits today)
Share this:

Written by