SPREADSHEETS – MS EXCEL
1. (a) What is Electronic spreadsheet software? (2 marks)
(b). Explain the use of electronic spreadsheet software in business organizations. (4 marks)
2. Differentiate between the traditional analysis ledger sheet and an electronic spreadsheet. (5 marks)
3. (a) Describe the three components of a spreadsheet. (3 marks)
(b) Apart from Microsoft Excel, give any two other application programs classified as spreadsheets. (2m)
4. Explain five application areas where spreadsheet software can be used. (5 marks)
5. Describe any five features (advantages) of electronic spreadsheet software. 5 marks)
6. Explain the following terms as used in spreadsheets. (4 marks)
(a) Columns.
(b) Rows
(c) Cell.
(d) Chart.
(e) Automatic recalculation.
7. Explain the concept of ‘What if’ analysis. (2 marks)
8. (a) Explain the term ‘Range’. (1 mark)
(b) State two actions that can be performed on ranges in Microsoft Excel. (2 marks)
9. State any four data types used in a spreadsheet. (2 marks)
10. List four formatting features provided by Microsoft Excel. (4 marks)
11. Define the following terms as used in computer environment. (3 marks)
(i). Operator
(ii). Operands
(iii). Operation
12. (a) Define the following terms as used in spreadsheets: (6 marks)
(i) values
(ii) formula
(iii) Function
(iv) Labels
(b). List four mathematical functions provided by Microsoft Excel. (4 marks)
(c). List four types of information that can be entered into a spreadsheet cell. (4 marks)
14. (a) What is a cell reference? (1 mark)
(b) Mention four examples of cell reference (2 marks)
(c) Distinguish between Absolute cell reference and Relative cell reference. (2 marks)
(d) For each of the following, state the type of cell reference. (4 marks)
i) A5
ii) $F$5
iii) H$21
iv) $D7
15. Compute: (2 marks)
(i). 37 MOD 5
(ii). 37 DIV 5
16. (a) A formula to add the contents of B5 and C4 was entered in cell F5. What will it become when it is
copied to cell H8? (1 mark)
(b) Explain the reason for your answer. (2 marks)
1
17. (a) Write the formulae =F10 + G20 as absolute. (1 mark)
(b) The formulae =A1+C2 is initially typed in cells D1. What will it be when copied to cell
E1? (1 mark)
(c) What is the equivalent R1C1 reference for G20? (1 mark)
18. Give at least five categories of functions that are available in Microsoft Excel. (5 marks)
19. What is the role of the following functions as used in a spreadsheet program? (5 marks)
(a) Product
(b) SQRT
(c) Average
(d) Max
(e) IF
(f) COUNTIF
(g) SUMIF
21. Explain why a value such as 611233444555 may be displayed as ######### when typed on a
Spreadsheet. (2 marks)
22. (a). Assuming that the formula ‘= A5 * $B2’ is in cell C10 of a spreadsheet. Show how it will appear
after copying it to cell H12. (1 mark)
(b). Explain how you would select non-contiguous cells in spreadsheet. (2 marks)
24. (a) What is a Chart wizard in spreadsheets? (1 mark)
(b) Give two examples of charts that you know. (2 marks)
(c). Outline the steps required when creating a simple chart. (6 marks)
25. Andrew, Jane, David and Zablon had Tea, Sausages and Bananas for breakfast. They took one
sausage, two sausages, three sausages and one sausage respectively. In addition, they each took a cup of
tea and two bananas. Tea, sausages and bananas cost Ksh. 10, 15, and 5 respectively.
(a) By naming columns A, B, C, ………and rows 1, 2, 3……….Construct a worksheet showing the
above information. (7 Marks)
(b) State the expression you would use to obtain:
i) Total expenditure by David. (4 marks)
ii) Total number of sausages taken. (2 marks)
iii) The cost of the cheapest item. (2 marks)
27. What is a cell reference error as used in spreadsheets? (1 mark)
(b). Under what two conditions does a worksheet display # # # # # # (2 marks)
(c). A spreadsheet application can be used in analysis of trends of performance. List any
three types of charts you can make. (3 marks)
31. The cells K3 to K10 of a worksheet contain remarks on students’ performance such as Very
good, Good, Fair and Fail depending on the average mark. Write a formula that can be used
to count all students who have the remark “Very good”. (3 marks)
32. The following information shows the income and expenditure for “Bebayote” matatu for five
days. The income from Monday to Friday was Kshs. 4,000, 9,000, 10,000, 15,000, and
12,000 respectively while the expenditure for the same period was Kshs. 2,000, 3,000, 7,000,
5,000, and 6,000 respectively.
(i) Draw a spreadsheet that would contain the information. Indicate the rows as 1, 2, 3 ….and the columns
as A, B, C ….. (4 marks)
(ii) State the expression that would be used to obtain:
2
i. Monday’s profit (2 marks)
ii. Total income (2 marks)
iii. Highest expenditure. (2 marks)
33. (a) Distinguish between the following sets of terms as used in spreadsheets.
(i) Worksheet and workbook. (2 marks)
(ii) Filtering and sorting. (2 marks)
(b) State one way in which a user may reverse the last action taken in a spreadsheet package. (1 mark)
