Khyber Pakhtunkhwa Public Service Commission
Competitive Examination for the Posts of Assistant Sub-Inspector for Traffic
Warden System in Police Department (2018)
(COMPUTER LITERACY)
Time Allowed: 01 Hour Max Marks: 50
Note: Attempt any 10 Questions each question carries 5 marks,
Q l. What is the purpose of creating a PowerPoint presentation? Give any 5 reasons it is still effective to use in presentation.
Q 2. Create 5 slides/ presentation on “Polio Immunization” and execute them following by using Action button:
(i) Link 1st slide with the 3rd slide.
(ii) Link 2nd slide with the 5th slide.
(iii) Link 3rd slide with the 4th slide.
(iv) Give header and footer / slide number.
(v) Give Background color/ Insert picture.
Q 3. Perform the following calculation in MS Excel
| Cities | Target | Production | Achievement | Grade |
| X | 4800 | 6000 | 125% | .? |
| Y | 5000 | 4500 | 90% | ? |
| Z | 5000 | 5000 | 100% | ? |
| Avg | 4933.33 | 5166.67 | 104.73% |
(i) Calculate grade
(A+ more than 100%) (A for 100%) (B for Below 100%)
(ii) Create a Bar Chart to show the target and production of three places/ cities under observation.
Q 4. How many default Worksheets available In MS. Excel and what are the number of Rows/ Columns present in each Spreadsheet? How Worksheet relate with Spreadsheet In Excel?
Q5. Explain the following functions in MS. Excel.
(i) Max (ii) Sum (iii) Count (iiv) Day
Q 6. What are the steps to create MS. Word document with the following content of format?
(i) Insert a table having student info.
(ii) Demonstrate the Auto text feature of MS. Word.
(iii) How to apply Word Count Feature.
Q7. Create a list of 10 best friends. Create a Thank you letter.
(i) Use Mail Merge feature of MS Word.
Q8. How do Header/ Footer apply In MS. Word and apply page number also?
Q9. Define the Internet related terms.
(i)www (ii) http (iii) url (iv) ftp (v) DSL
Q10. Explain the relationship between Website and Web browser and how both are dependent on each other.
Q11. Define Email related terms:
(i) Attachment (ii) CC (iii) BCC (iv) inbox (v) Compose
Q12. Define the views of Document in MS. Word.
(i) NORMAL (ii) WEB LAYOUT (iii) PRINT LAYOUT