Computer Studies Paper 2 Questions and Answers - MECS Pre Mock Exams 2023

INSTRUCTIONS TO CANDIDATES:

1. Answer all the questions.
2. All questions carry equal marks.
3. Passwords should not be used while saving in the CD/Removable storage medium.
4. All answers must be saved in your CD/Removable storage medium.
5. Make a printout of the answers on the answer sheet.
6. Arrange your printouts and tie/staple them together.
7. Hand in all the printouts and the CD/Removable storage medium used.
8. This paper consists of 4 printed pages.
9. Candidates should check the question paper to ascertain that all the pages are printed as indicated and that no questions are missing.
10. Candidates should answer the questions in English.

QUESTIONS

1. Rembo Company Ltd deals with sales of three types of electronic goods namely television sets, radio systems and smart watches. Below is a table showing details of June 2022 sales.
   

   Rembo Company L t d.  S a l e s  a s  p e r 3 0 th June  2022
   Category Code	Type	Item Description	Unit Price	Sold	Total	Tax	Net Amount
   TV001	TV	32” Vitron TV	16000	8
   TV002	TV	42” Hisense TV	60000	2
   RD001	Radio	Panda Radio	21000	12
   SW001	Watch	Oraimo Watch	7500	15
   TV003	TV	21” LG  TV	11000	22
   SW002	Watch	Asorock Watch	6200	18
   TV004	TV	21” Sony TV	15800	14
   SW003	Watch	Apple watch	4500	20
   RD002	Radio	Sundar Radio	3200	30
   RD003	Radio	Revo Radio	4700	8
   TV005	TV	14” Samsung  TV	8200	4
   SW004	Watch	Xiaomi Watch	6500	16
   Tax Rates			TV	15%
   			Watch	12%
   			Radio	8%

   Required:
   1.                      
      1. Type the following data in a spreadsheet and save it as Rembo Company (14marks)
      2. Copy the entire worksheet to sheet2 and rename it as Rembo New (2marks)
   2. Format Rembo new worksheet as follows:
      1. Center the Title across columns. (2marks)
      2. The text should be Cambria, 18 points, bold and centered within a cell. (2marks)
      3. Column Headings to be wrapped within the cells and centered (2marks)
   3. The Unit Price to be in two decimals and currency symbol Ksh. (3marks)
   4. Use appropriate cell references to calculate:
      1. The total, rounded to two decimals places. (3marks)
      2. The TAX is based on the type of the item. Use the rates given in the table above to calculate tax payable on each item sold. (3marks)
      3. The Net Amount, which is the total less tax. (3marks)
   5. Sort the worksheet in ascending order according to category. (2marks)
   6. Calculate the subtotals and grand total for the three types of electronic goods. (6marks)
   7. On a separate sheet, create a bar graph that compares sales for the three types of electronic goods. Label it appropriately. (6marks)
   8. Print the Rembo new and the bar graph (2marks)
2.                    
   1. Open a desktop publishing program and set the page layout in inches as follows. (5marks)
      1. Paper size : 2.6” width by 3.2” height
      2. Portrait: orientation
      3. Margins: 0.25” all round
      4. Layout type : multiple pages per sheet
      5. Target paper size; A4
         
   2. Designs the card as it appears ensuring that the card covers all the space in the page. (42marks)
   3. Save the publication as anniversary card (1mark)
   4. Print out 8 copies of the card on a single A4 page (2marks)

MARKING SCHEME

QUESTION ONE

QUESTION TWO