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

Computer Studies (Excel) Question Paper

Computer Studies (Excel)

Course:Public Health

Institution: Jomo Kenyatta University Of Agriculture And Technology question papers

Exam Year:2013

Jomo Kenyatta University of Agriculture and Technology.
Excel Exercise Questions (2)

1) Differentiate between a worksheet and a workbook.
2) Discuss three different ways you can use to rename a worksheet in excel.
3) Discuss two different ways to delete a worksheet in excel.
4) Discuss two different ways of inserting: -
i) A worksheet.
ii) A row.
iii) A column
iv) A cell.
5) Giving examples, and explaining how they are used and what they do, discuss the following functions.
i) Sum ii) Average iii) Product iv) Max v) Min iv) SumIf v) CountIf vi) Count vii) If
6) a) Explain the term chart as used in Excel.
b) Explain two ways of inserting a chart in a worksheet.
c) List and explain three types of charts used in Excel.
7) Explain the steps followed to hide and unhide: -
i) A row.
ii) A column
iii) A worksheet.
8) a) Giving examples, explain the term conditional formatting as used in excel.
b) Explain the steps followed to conditionally format a cell.
9) Explain the steps followed to format a cell so that: -
a) It displays values in terms of Ushs.
b) It has a yellow background.
c) It displays the text in blue.
d) It has a border.
e) It displays values correct to 3 decimal places.
10) Explain two different steps followed to include a header in your worksheet.
11) Explain the steps followed to print only a certain section of data in a worksheet.
12) Explain the steps followed to change the orientation of a worksheet from portrait to landscape.
13) Explain the steps followed to ensure that when you print your worksheet, the gridlines are also printed.
14) Explain the steps followed print a worksheet including the row and column headings.
15) Explain the steps Carol would follow to copy data in a row but paste it in columnar format.
16) The data displayed in a certain cell C2 is the result of a formula i.e. =A2 + B2. Explain how Isaac would copy the value and paste it in cell D2 without copying the formula.
17) The value displayed in cell F4 is 40 and the one displayed in H5 is 65. Cell F4 is formatted but H5 is not. Explain how Musyoka would: -
a) Copy the format in F4 to H5 without affecting the value in H5.
b) Copy the value in F4 to A2 in such a way that if the value in F4 is changed the one in A2 also changes automatically to the new value.
18) Explain how you would create a copy of an already existing worksheet.
19) Study the data below and answer the questions that follow.

a) Write the formula you would use to calculate the total for Patrick, which would then be auto filled for the other students.
b) Write the formula you would use to calculate the average for Patrick, which would then be auto filled for the other students.
c) Using nested if functions write a complete formula that will return Patrick’s order of merit (Award). The classification is as follows.

Average Mark Award
75 – 100 Distinction
65 – 75 Credit
50 – 65 Pass
0 – 50 Fail

d) Write functions that will count the number of students who got
i) Distinctions.
ii) Credits.
iii) Passes.
iv) Fails.
These functions will be attached to cells B8, B9, B10 and B11 respectively.
e) Explain the steps you would follow to come up with a column chart to analyze the performance of all the students in each individual unit.
f) Explain the process you would follow to come up with a pie chart to analyze the overall performance of all the students.
g) If the above worksheet was to be printed, explain the steps you would follow to include page numbers.
20) Explain four different ways of opening Excel.

* * * * * All the best – John Maina * * * * *

Computer Studies (Excel) Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams