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 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)
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 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.
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.
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.
In cell F6 to F11, calculate the profit/loss by subtracting the Total Cost from the Day’s Sales.
Format all currencies to have the ‘UGX’ symbol before the vale.
Use a function to compute the GRAND TOTALS in row 13.
Make the title in font size 22, bolded in blue colour., Fill your title with a light green background colour
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.
In cell F3 on sheet 1, calculate the second highest profit made.
Shade the Grand totals with an orange background colour.
Add your name as footer and print your work.
KAKURU BENARD
Kakuru Benard is a distinguished specialist in Digital Learning and teaching. A consultant trainer and researcher in ICTs, computer science and geography, Kakuru has also published books with the Uganda National Curriculum Development Centre, undertaken Interactive and Adaptive Digital Content Creation with Yaaka Digital Network (www.yaaka.cc), digital content creation and optimization for online learning, and digital classrooms in order to help learners and teachers improve at all levels. Since 2015 Kakuru Benard has taught ICT, trained teachers, tutors and lecturers in ICT Integration, multimedia and digital communications and digital pedagogy, helping them to learn and teach better in organizations and schools including Equatorial College School, St Joseph of Nazareth High School, Yaaka Digital Network, as well as Multimedia and 21st Century Skills trainings with Makerere University Department of Journalism and Communication, Brac Uganda, Uganda Christian University, Ultimate Multimedia Consult, Uganda Martyrs University, UNICEF, US Mission and FAWE Uganda. Kakuru Benard is a graduate from Uganda Martyrs University.
View Comments