Get premium membership and access revision papers, questions with answers as well as video lessons.

Form 2 Computer Studies Cat 2 Term 2 Question Paper

Form 2 Computer Studies Cat 2 Term 2

Course:Computer Studies

Exam Year:2013

NAME..................................................................................ADM NO..................... CLASS...................

ELERAI MCK GIRLS’ SECONDARY SCHOOL
P. O. BOX 435
SULTAN HAMUD
Motto “Discipline and Hard Work for Excellence”

FORM II
COMPUTER STUDIES
CAT II
TERM II 2013

INSTRUCTION
• Answer ALL the questions in the spaces provided below each question

1. Define spreadsheet (2mks)

2. Name the two types of spreadsheets (2mks)

3. Give any two advantages of using electronic spreadsheet (2mks)

4. Give any two examples of spreadsheet application programs you know (2mks)

5. Describe the use of spreadsheets in any two application areas (4mks)

6. State three components of spreadsheet (3mks)

7. Differentiate between a worksheet and a workbook (2mks)

8. Differentiate between a formulae and a function (2mks)

9. Give any two uses of an autofill handle (2mks)

10. Write the following formula as an absolute (2mks)
=F10 + G20

11. The formula =A1 + C2 is initially typed in cell D1 then copied to cell E1. Write down the new formula in cell E1 (2mks)

12. Distinguish between sorting and filtering features of spreadsheet (2mks)

13. In a worksheet, the marks scored by TEN students are stored in cell B3 to B12.
i) Write an expression you would use to obtain positions of the students using marks scored in descending order (4mks)

ii) In cell B13, write an expression you would use to extract the highest mark scored (2mks)

14. The table below shows the records of FOUR students.

ADMNO SEX MARKS CLASS
026 F 70 4
118 M 40 3
150 F 50 3
152 M 30 4

Given the following logical function

=IFNOT((SEX = “F”) AND (MARKS >=50) AND (CLASS = 3))

Indicate the result of the expression whether FALSE or TRUE when applied in the record with admission 150 (3mks)

15. The following function was entered into the cell D2 in the table below to award the students.

=IF(C2>=75, “DISTINCTION”, IF(C2>=65, “V.GOOD”, IF(C2>=55, “GOOD”, IF(C2>=45, “AVERAGE”, “TIA BIDII”))))

Fill in the table with appropriate award for each student when the formula was copied down the column (4mks)

A B C D
1 ADMNO NAME AVERAGE MARK AWARD
2 004 ROSE 48
3 008 MERCY 56
4 003 KIBET 68
5 012 NDUTA 34

Form 2 Computer Studies Cat 2 Term 2 Question Paper

More Question Papers

Popular Exams