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 (3)
1) Explain the following terms as used in MS-Excel:
i) AutoFill.
ii) Cell range.
iii) Function.
iv) Formula.
v) Chart.
vi) Workbook
vii) Fill handle.
viii) Sheet tab.
ix) Wrap Text.
x) Merge Cells.
xi) Cell Reference.
2) List any three types of graphs you can use in MS – Excel and explain the situations each are most suitable.
3) Discuss any four advantages of electronic spreadsheets over paper spreadsheets.
4) Explain the steps you would follow to: -
a) Copy a range of data from an excel worksheet to a word document.
b) Copy a section of data in an Excel worksheet to an MS – Word document in such a way that when the data in the excel worksheet is changed, the one in the MS - Word changes automatically.
5) Give the syntax for an If function and explain each of its arguments.
6) Study the diagram below and answer the question that follows.
Write a formula to be attached to cell C1 so that the cell displays the two names combined (with a space between them) i.e. Lucy Kibaki.
7) a) Differentiate between SUM and SUMIF worksheet functions.
b) Give the proper syntax for SUM and SUMIF and explain the arguments used in each case.
8) a) Differentiate between COUNT and COUNTIF worksheet functions.
b) Give the proper syntax for COUNT and COUNTIF and explain the arguments used in each case.
9) Explain three ways you can add up values in a certain range of cells.
10) Explain two ways of placing charts in excel.
11) You are about to print an excel document and you realize your document stretches to two pages. Outline two ways of fitting the text into one page.
12) Differentiate between the following: -
a) Relative Cell reference and Absolute cell reference.
b) Copy & Paste and Cut & Paste.
c) Paste and Paste Special.
d) Save and Save As.
13) a) Differentiate between filtering and sorting.
b) Explain the steps you would follow to sort data in a given worksheet.
c) Explain different steps you might use to filter data in a worksheet and how each works.
14) Study the data below and answer the questions that follow.
a) Write an If function to compute the tax amount using the following classification: -
Home Price Tax Amount
0 – 400,000 10%
400,000 – 4,000,000 14%
>= 4,000,000 16%
b) Write a formula to compute the net cost of the house.
c) Repeat (b) but this time use a function.
d) Write a function to count the number of commissions less than 500,000.
e) Write an IF function to classify the home as follows.
Net Cost Classification
0 – 500,000 Lower Class
500,000 – 6,000,000 Middle Class
>= 6,000,000 Upper Class
g) Explain the following formula: -
=IF(C2*D2 = 0,“ ”,C2*D2)
Practical Part
15) The table below gives the basic salaries of the employees of different departments in an organization. Save as Que14.xls.
a) Allowances depend on the department and basic pay as follows:-
IT department gets 22% of their basic pay as allowance.
Account department gets 18% of their basic pay as allowance.
Training department gets 16% of their basic pay as allowance.
Use the IF function to calculate the allowances.
b) Calculate the allowances and Total pay.
c) Create a column graph based on the above data (don’t include the departments).
d) Create a 3D pie chart based on the basic salary of the employees.
e) Format all the currency amounts so that they are displayed in Kshs. and correct to two decimal places.
d) Include a function that counts all the employees who earn more than 25,000. The function should be placed in an appropriate cell and should also be accompanied by meaningful text.
e) Include another function that counts the number of the employees in the IT department.
f) Include a header that reads CarolSoft Inc. and page numbers at the bottom of each page.
g) Change the appropriate settings so that when the data above is printed, the gridlines and row and column headings are also included.
h) Format the Basic Salary column using AutoFormat so that all salaries below 13,000 are displayed in blue in cell with orange background.
i) Copy-paste the data to a word document in such a way that if you change the data in the worksheet, the data in word is automatically updated. Save the document as data1.doc
j) Repeat the process in (i) above but this time make sure that the data in excel and the one in word are independent i.e. changes in the excel data do not affect the data pasted in word. Save this new workbook as data2.doc
* * * * * All the best – John Maina * * * * *
More Question Papers