Answer all Questions

1. (a) What is a relative address?                                            (01 mark)

(b) Give four advantages of electronic Spread sheets over manual Spread sheets.                   (04 marks)                

(c)With an illustration, explain how a shopkeeper can use spread sheets to run the business.      (04 marks)

2. (a) Name two situations where electronic spread sheet application software can be used in a shop. (02 marks)

(b) Give two situations that can necessitate one to use equal signs in an electronic spread sheet cell.  (02 marks)

(c) Using spread sheet functions given below; fill in the most appropriate function in the spaces provided. (04 marks)

MAX, SUM, MEDIAN, MODE, MIN, COUNTIF

(i) To determine the total of items in a given range……

(ii) Determining the lowest value in a given range…………

(iii) Counting values which fulfill a given CONDITION………

(iv) Determining the value which appears more times in a given range……

3. (a). State three data types used in electronic spread sheets. (03 marks)

(b).   Use the figure 1 above to answer questions following:

📷

(i).     State the result if =MAX (B2:B5) – MIN (B2:B5) is placed in cell B9. (02 marks)

(ii). If quantity sold is to increase by 30%. What will be the formula needed to return new quantity projection for Sumbusa in cell E2. (03 marks)

(iii). Explain how you insert a thousand separator for data in cell range B2:C5.    (04 marks)

4.(b) Explain the following terms in spread sheet

(i) Values              (02 marks)

(ii) Labels             (02 marks)

(c) Name three different operations, which you would expect in a spread sheet cell.              (03 marks)

(d) State any four application areas of spread sheets.             (04 marks)

5. (a). Give two characteristics of number data type as used in a spread sheet program. (02 marks)

(b). (i). If I select a cell range A4:E15, how many cells have I selected?

(ii). State any two examples of cell referencing techniques used in an electronic spread sheet.   (02 marks)

PRACTICAL QUESTION ONE

Using a suitable software package, type the file in figure 2 above that has been created to calculate the profit or loss on sales at Jinja Orange Juice Stall during a six day period. Save it Days Sales.

📷

1. Using absolute and relative cell references, type a formula in cell D6 to calculate the total cost for Monday which is a cups made. Copy it cells D7 to D11 for Tuesday to Saturday.
2. Using absolute and relative cell references, type a formula in cell E6 to calculate the Day’s Sales for Monday, as a product of the selling price and the number of Orange Juice cups sold. Copy it to cells E7 to E11 for Tuesday to Saturday.
3. In cell F6 to F11, calculate the profit/loss by subtracting the Total Cost from the Day’s Sales.
4. Format all currencies to have the ‘UGX’ symbol before the vale.
5. Use a function to compute the GRAND TOTALS in row 13.
6. Make the title in font size 22, bolded in blue colour., Fill your title with a light green background colour
7. Create a combined column-line combo chart with column chart representing the number of orange juice cups made in a weeks’ time and line graph showing trend of profits / loss on the secondary vertical axis. Locate it on its own new sheet.
8. In cell F3 on sheet 1, calculate the second highest profit made.
9. Shade the Grand totals with an orange background colour.
10. Add your name as footer and print your work.