Proficiency Test Junior Clerk 2019

PUNJAB PUBLIC SERVICE COMMISSION

MS OFFICE PROFICIENCY TEST

Paper Date: 22-02-2020 

Junior Clerk (27C2019)

Services & General Administration Department

Time Allowed: 45 Minutes

1.               On every page of question paper and Answer Sheet, type your Roll Number, Name and Father Name before start of test.

2.               Create a folder on desktop and make on file each of MS Word, Excel and PowerPoint.

3.               During completion of tasks save your work regularly. While saving your work if you lost your work you will be responsible. So Be Careful.

4.               At the End, sign printed pages of your work produced by you.

5.               Use to Calculator is NOT ALLOWED.

 

Section 1 of 3: Microsoft Word – Marks: 10

 

Question 1

Type the passage below an save it. (1 Mark).

Central Processing Unit and Software Compatibility

    The computer processor inside a PC or PC-clone computer has totally different architecture inside the central processing unit chip. In other words, the specific way the circuits are laid out in a computer chip (CPU, central processing unit) is called the chip architecture. PC chips and Mac chips have processing units with totally different architecture. Software is not interchangeable. Buy Mac software for the Macintosh and buy PC software for PC computers. An Apple or Mac computer is not a PC.

INSTRUCTIONS

1.                  Replace every occurrence of the word computer with “COMPUTER” using Replace All Button. (1 Mark)

2.                  Copy the passage you typed previously and paste it in three columns with a line between. (2 Mark)

3.                  Change the layout of the page to landscape and change all margins to 2 cm. (2 Mark)

4.                  Insert a page border (1 Mark)

5.                  Perform Drops caps on every character that begin a paragraph. (1 Mark)

6.                  Insert a Title Page in the document. (1 Mark)

7.                  Hyperlink “Central Processing Unit and Software Compatibility” to https://www.google.com/”. (1 Mark)

Section 2 of 3: Microsoft Excel – Marks: 10

 

Question 2

Create an excel sheet and do the following:   (10 Marks)

1.      Enter the following data using same format in the excel sheet in range A3 to F15. (2 Marks)

DAYS	ALI	ADNAN	ASIM	KASHIF	SOHAIL
Monday	106	401	493	120	269
Tuesday	423	433	468	280	153
Wednesday	416	195	249	270	209
Thursday	369	105	391	209	161
Friday	370	242	489	109	417
Saturday	390	256	477	387	171
Sunday	273	144	170	467	148
A
B
C
D
E

Perform the following tasks on the data available in range B4 to F10: (2 Marks each)

2.      Calculate sum of each column (B to F), in row 11.

3.      Calculate average of each column (B to F), in row 13.

4.      Calculate MAX of each column (B to F), in row 14.

5.      Calculate MIN of each column (B to F), in row 15.

 

Section 3 of 3: Microsoft PowerPoint – Marks: 10

 

Question 3

Create a presentation that consists of 2 slides and:

1.      Apply any animation on both slides.  (1 Mark)

2.      Use different Layout and Theme for each slide.     (2 Marks)

SLIDE ONE: Use following title (Font Size 65) and contents:      (1 Mark)

Title: “The Season”

Subtitle: By: “Your Name”

SLIDE TWO: Use following title (Font Size 50) and contents:     (1 Mark)

Title: SPRING

·         March 20^th is the first day of Spring

·         Spring lasts from March to June

Question 4

In Power Point, create two slides and:

1.                  Apply different layout style for each slide. (1 Mark)

2.                  Apply different slide design on each slide. (1 Mark)

3.                  Add actions button to advance the slide back ward and forward. (2 Marks)

4.                  Apply animations and transitions on slides. (1 Mark)