CS6: Assignment on Spreadsheets

Answer All Questions

1.(a) Name three different types of number format you would expect in a spread sheet cell?    (03 marks)

(b) Characteristics of label in a spread sheet cell (02 marks)

2. Outlining uses of electronic spread sheets (05 marks)

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

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

(b)  State three examples of spread sheet programs.    (03 marks)

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

(b) List two data types of entries in spread sheets.                  (02 marks)

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

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

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

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

• 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.
• on sheet 3 show all formulas used.
• Add your name as footer and print your work.

8. (a) Open  a file  called  XMADASA.xlsx that  is  in you  folder  and  work  out  the  following tasks.        (20 marks)

• Adjust the Column width to 15 inches and row heights to 30 inches. (01 mark)
• Format the font style/font face to Arial rounded. (01 mark)
• Delete the first row and first column to from the data (01 mark)
• Fix part of the worksheet to remain visible while the rest of spreadsheet scrolls.                                                                    (01 mark)
• Using font  size  16  in  upper  case,  include  the  title “stock of goods” above  the data.                                                                   (01 mark)
• Transfer a copy of records within the range A1:E19 to sheet 2                                                                                                 (01 mark)
• Apply all boarders on your work. (01 mark)
• Format all the values in the selling price column with UGX units By using information on sheet two (01 mark)
• Use absolute referencing and data in cell B2 to determine the Discounts on sale.                                                                    (01 mark)
• With the help of the following grading system, use IF function to assign grades to the products basing on their discount values. (01 mark)

• Determine the total discounts (01 mark)
• If the government set maximum price for any item sold at 45,000, use a function  to  determine  the  number of  items that  were  sold  above  the  government price.                                                      (01 mark)
• In a new column, convert the cost price into US Dollars if the current  exchange rate  is  1USD = 3,500  UGX  and round  off values  to  1 decimal                                (02 marks)
• Use text filters and number filters to filter out items that contain letter “e” but whose price on purchase is not greater than SHS 70,000. Save it as Contain e greater70000. (02 marks)
• Create a labeled pie chart to include values for USD and name of item. Save it as USD Pictorial Graph. (03 marks)
• Print the work on sheet two &the graph save changes. (01 mark)