Apply hanging ident to the first two paragraphs. Save the document as EXERCISE 2. (6marks) c) Select the text starting from the words example:….. information systems development” (at “For the end of the passage) and move it to a new page and save as EXERCISE 3. (5marks) d) (i) Retrieve EXERCISE document and convert it to two columns of the same width and height and justify them. (6marks) (ii) Double space the first paragraph of the passage and fit the entire passage into one page (4marks) (iii) Insert your name into the passage as a footer so as to appear as © your name. Save the document as EXERCISE 4. (5marks) d) Print EXERCISE, EXERCISE 2, EXERCISE 3, EXERCISE 4 (4marks) Employees of Sunshine Company are paid salaries which comprise of Basic salary, house allowance and medical allowances. The gross salary of each employee is calculated as the total of the three payment categories. Below is a list of allowances and basic salaries for ten employees in the month of July 2003. MEDICAL ALLOWANCE HOUSE ALLOWANCE BASIC SALARY MURTAZA 5,000 10,000 20,000 WASIM 3,000 8,000 16,000 MWANGI 3,500 8,000 16,000 ISHO 6,000 12,000 25,000 MITESH 2,500 6,500 12,000 MITHEU 2,500 6,500 12,000 KRISHNA 7,000 15,000 30,000 MBUGUA 3,500 8,000 16,000 KASOO 3,500 8,000 16,000 SARU 3,500 8,000 16,000 Using the above information, design an appropriate spreadsheet and enter the given sample data. Give the spreadsheet an appropriate title and save at MOCK_1. (12marks) Calculate the gross salary for each employee. Label it appropriately on the spreadsheet. Write the formular used for Saru’s gross salary, on the sheet provided. (6marks). Fatuma Ndeche joined the company at management level and was paid 20% Basic salary more than Krishna was paid. If her medical allowance and house allowance was calculated at 30% and 50% of her basic salary respectively. Calculate and fill a record for Fatuma Ndeche on the spreadsheet. Write the formulae used on the answer sheet provided. Save the spreadsheet as MOCK _2 (6marks)
Apply hanging ident to the first two paragraphs. Save the document as EXERCISE 2. (6marks) c) Select the text starting from the words “For example:….. information systems development” (at the end of the passage) and move it to a new page and save as EXERCISE 3. (5marks) d) (i) Retrieve EXERCISE document and convert it to two columns of the same width and height and justify them. (6marks) (ii) Double space the first paragraph of the passage and fit the entire passage into one page (4marks) (iii) Insert your name into the passage as a footer so as to appear as © your name. Save the document as EXERCISE 4. (5marks) d) Print EXERCISE, EXERCISE 2, EXERCISE 3, EXERCISE 4 (4marks) Employees of Sunshine Company are paid salaries which comprise of Basic salary, house allowance and medical allowances. The gross salary of each employee is calculated as the total of the three payment categories. Below is a list of allowances and basic salaries for ten employees in the month of July 2003. MEDICAL ALLOWANCE HOUSE ALLOWANCE BASIC SALARY MURTAZA 5,000 10,000 20,000 WASIM 3,000 8,000 16,000 MWANGI 3,500 8,000 16,000 ISHO 6,000 12,000 25,000 MITESH 2,500 6,500 12,000 MITHEU 2,500 6,500 12,000 KRISHNA 7,000 15,000 30,000 MBUGUA 3,500 8,000 16,000 KASOO 3,500 8,000 16,000 SARU 3,500 8,000 16,000 Using the above information, design an appropriate spreadsheet and enter the given sample data. Give the spreadsheet an appropriate title and save at MOCK_1. (12marks) Calculate the gross salary for each employee. Label it appropriately on the spreadsheet. Write the formular used for Saru’s gross salary, on the sheet provided. (6marks). Fatuma Ndeche joined the company at management level and was paid 20% Basic salary more than Krishna was paid. If her medical allowance and house allowance was calculated at 30% and 50% of her basic salary respectively. Calculate and fill a record for Fatuma Ndeche on the spreadsheet. Write the formulae used on the answer sheet provided. Save the spreadsheet as MOCK _2 (6marks)
Comp%20pp2%20016.docx