CS3: Assignment 1 On Spreadsheets

Answer all Questions

1. The spread sheet below shows “THE KATUNKUMA COLLEGE SHOP SALES”

The Shop sales spread sheet showing the result of changing a charity percentage to 25%

(a) State the entry for the cell below G5  (01 mark)

(b) (I) what is the formula used to calculate the total cost?       (01 mark)

(ii) Find the entry in C7           (01 mark)

(c) If the range of cells from A4 to A8 is A4:A8, given the range for

• The four cells below G7 (01 mark)
• The four cells to the left of G7 (01 mark)
• What else can you put in spread sheets cells besides text and numbers? (02 mark)

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

2.(a) Name three different types of number format you would expect in a spread sheet cell?    (03 marks)           (b) (I) Characteristics of label in a spread sheet cell (03 marks)

(ii) Outlining uses of electronic spread sheets (03 marks)

3.(a) What is the meaning of these terms?

• Worksheet (01 mark)
• Active cell (01 mark)

(b)  State two examples of spread sheet programs.    (02 marks)

(c) Mention three types of graphs created in spread sheets.       (03 marks)

(d) List three data types of entries in spread sheets.                  (03 marks)

4. (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)

5. (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……

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

(b).   Use the figure below 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)

7.(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)

8. (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)