Computer practical Ms-Office questions and sample Paper Models for the Post of Kharidar, Nayaab Subba and Section Office.

Candidates who have been selected in the first phase and second phase examination of the Kharidar, Subba, and Section officer post for the computer skill test and interview as per the information related to computer skill test to be taken by the Public Service Commission office and other offices. In order to prepare for the Computer Practical Exam, I have presented the questions from each unit of the experimental course as follows.

The course of experimental examination

I have mentioned the syllabus of the experimental examination for the Kharidar, Subba, and branch officer posts as follows. Most of the time, it is seen that experimental exams are given without knowing the number of questions in the exam. I have detailed questions from each unit of the course. If you need a solution to these questions, please write "Must Need" in the comment.

If more than 100 comments are written, I will put them in the Telegram Group below with the solution of all the questions. These questions can be used not only for the Kharidar, Subba, and Section Officer but also for other offices covered by the course. 

My profiles

Telegram Group: Mohan Bhatt

Facebook Page: Mohan Bhatt Facebook Page

Kharidar

(Practical Examination Scheme)

Subject	Mark	Subject Matter	Mark	Time
(IT Skill Test)	१०	Devanagari Typing	2.5	५ Minutes
		English Typing	२.५	५ Minutes
		Windows Basic and Ms Word	५	५ Minutes
Total			१० Mark	१५ Minutes

 Nayaab Subba

(Practical Examination Scheme)

Subject	Mark	Subject Matter	Marks	Time
(IT Skill Test)	10	Devanagari Typing	2.5	5 Minutes
		English Typing	2.5	5 Minutes
		Windows Basic and Ms Word	५	५ Minutes
Total			१० Marks	१५ Minutes

Section Officer

(Practical Examination Scheme)

Subject	Marks	Subject Matter	Marks	Time
(IT Skill Test)	१०	Devnagari Typing	२.५	५ Minutes
		English Typing	२.५	५ Minutes
		Word Processing	२	१० Minutes
		Presentation System	१
		Electronic Spreadsheet	१
		Windows Basic, Email and Internet	१
Total			१० Marks	२०Minutes

Sample question paper

You need to develop the habit, the ability to do the practiced questions in time in the exam hall. If you can't do it in time, your practice may be lacking. But I think you practiced constantly on a daily basis but what happened in the exam? Why couldn't the exam be done? This is because the study practice you did at home can be considered as a result of not testing or testing at home. Therefore, out of the questions asked in the exam, I have prepared a sample of the following 5 question papers. Try to do it on time using the computer.

Tips: 

Don't waste time on the part of the question that can't be done in the exam. The other part of the question also carries weight. Not knowing

Go to the next part of the question. Please pay attention to the questions in the question paper and solve them only after reading and understanding.

See and Download PDF File of Sample Paper

From the MS-Word unit

I have collected the questions of Ms-Word asked in the examination of Public Service Commission from different places, Facebook, Website and put them here. Please read and understand these questions. If it is difficult to understand or solve, please write in the comment box. Similar questions seem to come to the Public Service Commission or other offices every year. These questions are useful not only for the Kharidar, Subba and Section Officer but also for other bodies covered by the course. I will put only 10-10 questions here. If necessary, write "More Questions" in the comment box. I'll keep it in a few days.

1.    Start Ms-Word App. Create a blank new word document. Save it with "PSC" and perform the following tasks in the word document file.

a. Type “PSC” in the header.
b. Type text “Hello Everybody” with font “Calibri” and font size “20”.
c. Insert any picture in the document.
d. Insert Page Number in the footer of the page as 1 of 1.

2.    Open Ms-Word software and solve the following problems.

a. Copy and paste the text from the English typing content of question 1 in the New Blank Document named “Format”.
b. Bold and Underline first paragraph.
c. Change the Page Margin as follows:
Left page margin = 1.5”,
Right page margin = 0.75”
Top margin = 2”
Bottom margin = 1”
d. Highlight first paragraph with blue color.

3.    Create a new word document using Ms-Word software and complete the following tasks in the word document file "Format".

Copy and paste the text from the English typing content of question 1 in New Blank Document named “Format”.
a. Change Font Heading size to 18.
b. Change Heading Font color to red.
c. Set Line Spacing to 2 lines.
d. Insert Page Number as i, ii, iii, in the bottom middle of the page.

4.    Execute Ms-word software. Solve the following problems in a word document file named as "Setting".

a. Copy all paragraphs from English typing that you typed before from questions 1 and paste in a new word document.
b. Insert a table having 2 Rows and 3 Columns.
c. Insert any Picture on the top-middle corner of the page.
d. Insert Header as” Public Service Commission”, and Insert Footer as Page Number.

5.    Create a new blank word document. Complete the following operations in Ms-Word software.

a. Copy the English typed text from question 1 and paste the typed text in new Blank document file named as “Documents”.
b. Insert “Introduction” as a Header and Page Number as Footer.
c. Insert a Text Box below the paragraph and type “PSC Online Registration” inside the text box.

6.    Open Word Processing (Ms-Word app) Software. Solve the below questions in Ms Word.

a. Copy the English typed text from question 1 and paste the typed text in new Blank document and set the file name as “msword”.
b. Set the Paper Size A4 and Paper Orientation Landscape.
c. Insert any picture from Pictures Folders.
d. Insert the Page Number at the bottom middle of the page.

7.    Create a new word blank document. Complete the following settings in Word Processing Software Ms-word.

a. Copy the English typed text from question 1 and paste the typed text in new Blank document and set the file name as “msword”.
b. Change the before Paragraph Spacing to 12ptand Line Spacing to 1.5.
c. Insert the text “Hello World” at the Header of the document.
d. Insert a table of 3 rows and 3 columns.

8.    Open Microsoft Word Software. Complete the following settings in the word document file.
a. Copy the typed text and Paste in new Blank word document which you have typed in question no. 1, save it by applying file name “wordformat”and do as follows.
b. Select the all the Paragraphs break into two Equal Columns and Line Between.
c. Insert Picture anywhere in the document and place Caption as “Figure 1”.
d. Insert Header as “Header” at the top of the page and apply Heading Styles as “Heading 1” to the header.

9.    Create a new blank document in the desktop file name as “wordfile” and complete the following questions.
a. Type the following text in the document.
(a+b)2= (a+b)(a-b)
b. Set Page Margin: Left: 1.5” &Right: 1.5”
c. Protect the document with the Password Moh@123.

10.    Open Microsoft Word from start. Complete the following questions in the word document file.

a. Open Microsoft Word document that you have typed, copy all text of paragraph and paste in new blank word document file name as “wordformat”.
b. Apply “Times New Roman” font to all text.
c. Bold and Underline the Heading and Subheading.
d. Insert current File Path as Header.

11. Create a 2 page in 2 column layout format using Ms-word and do the following settings.

a) Each page should have an outside border, background colour and footnotes for the above document.
b) Build a table of contents for the document.
c) Give your document a title which should be displayed in the header.
d) Add confidential as a watermark.

12. Create a new Word document in two column layout you may copy the text from anywhere else to create the document.

13. Create a two-page document in two-column layout in Ms-word using the following instructions.

a) Each page should have a border and should be landscape-oriented.
b) Set background color and add "PSC" as the watermark.
c) Give your document a title which should be displayed in the header.
d) Create an index for the above document.

14. Create a new word document in Ms-word using the following instructions.

a) Add a picture to the document.
b) Resize it to make a smaller.
c) Add 5 lines to the document for the picture.
d) Tight wrap the text around the image.

15. Create the following table in Ms-word.

S.No.	A			B
1
2
3

16. Create the new Ms-word document and do the following tasks.

a) Create a table to record the attendance of students in a class. The table should have columns for Roll Number, Name and Presence Status.
b) Insert page numbering in the document.
c) Using the Word Count feature, find the number of words in the documents.

17. Perform the following tasks using Ms-word.

a) Change the line spacing to 2 and create 1.5 pt line space before and after a paragraph.
b) Create a table to maintain the address, mobile number, and email-id of your friends.

18. Write five Uses of Computer using numbered list by creating Ms-word blank document and do the following task.

a) Find all the occurrences of the word "Computer" and replace it with "PC" in the above document that you have typed.

19. Write at least five sentences on the employment potential of computer operators using Ms-word with following instructions.

a) Create a pointwise list of these sentences.
b) The spacing between these lines should be 2.0.
c) Convert this point list to a number list with the first 3 points numbered as points (i) to (iii). Now restart the numbering for the remaining points.

20. Create a new word document and do the following settings.

a) Save it named as “Format”.
b) Format the page such that it has three columns.
c) Also insert a Header and Footer to the document.

21. Perform the following tasks using Ms-word document.

a) Write two paragraphs about your future plans. Each paragraph should have a hanging indent.
b) Copy and paste these paragraphs to make the document of at least two pages, then set the mirror margins. For an even page, the margin should be 3" left and 1" right.
c) Format the document having 3 columns.

22. Create a blank new word document have following instructions.

a) Enter a table with student names and marks in three subjects. Find the total marks of each student by entering a suitable formula.

23. Perform the following tasks using Ms-word document.

a) Write a paragraph about Ms-word and format it into two columns.
b) Write the expression: a2-b2 = (a + b) (a - b)
c) Create a header "My document" for the document you are working with.
d) Change the page orientation to landscape and show the print preview of the file.

24. Create a new word blank document. Save it by named “Education Info”. In that document file, insert a table to store information about your educational qualification details having column: “S.N., Name, Address, School Name, Board, Passed Year, Percentage, Remark”.

25. Create a table to record the Computer PracticalSyllabus Courses of SECTION OFFICER Or NA.SU. Or KHARIDAR” of Public Service Commission using Ms-word Word document file named as “Syllabus”.

From the MS-Excel unit

I have put here the questions of Ms-Excel asked in the computer skill test of the Public Service Commission and other Offices. I have collected these questions from various websites, Facebook, candidates. It is very important for the candidates to be included in the computer skills test. I will keep only 10/10 of these questions. If you need more, please write in the comment box (keep more questions). Practice. If you don't know how to solve it, ask in the comment box. I even have a Telegram Group. Even in that Telegram Group, you can put unresolved questions. Even if I can't answer immediately, I will resolve it as soon as I have time. After a good practice, try to solve those questions in time. Please solve other similar questions as well.

Telegram Group: https://t.me/mohandattbhatt

Facebook Page: https://www.facebook.com/bhattmohandutt/

1.     Create the given table in Ms-Excel and calculate the Total Amount and Grand Total.

S.N.	Particular	Quantity	Rate Rs.	Amount
1	Apple	2 kg	120
2	Mango	1.5 kg	60
3	Guava	2.5 kg	40
Grand Total

2.     Enter the following table in Microsoft Excel. Calculate the following questions data in sheet 1 of Ms-Excel.

a.      Calculate the Total marks and Percentage of the following student of class 10.

S.N.	Student Name	Math	Science	Total	Percentate
1	Santosh Bhatt	89	92
2	Thaneshwar Bhatt	76	88
Total

3.     Open the Microsoft Excel spreadsheet, enter the following table data. Calculate the following task and Save it as “Salary sheet”.

a. Calculate the Yearly Salary of the following staff of an office.
b. Calculate the 1% tax.

S.N.	Name	Address	Post	Basic Salary	Yearly Salary	Tax 1%
1	Yadav Pant	Mahendranagar	Officer	31000
2	Anamika Bist	Dadeldhura	Na su	28800
3	Rina Bhatt	Darchula	Kharidar	27500

4.     Start Microsoft Excel Program. Create the following table in Sheet 1. Solve the following Electronic Spreadsheet question and Save it with name “Book Shop”.
a. Create a sheet with the following data.
b. Calculate the Amount, Discount Amount (2%) and Total Amount.

S.N.	Name of Books	Qty	Price Rs.	Amount	Discount	Total Amount
1	English 10 class	1	450
2	Math 8 class	2	250
3	Science 9 class	1	360

5.     Open Ms-excel sheet. Complete the following task and Save it name as “Commission sheet”.
a. Create the following table for calculating the Commission for sales, 5%, if sales greater than 10000, otherwise 3%.

S.N.	Sales	Commission %	Commission Amount
1	5600
2	8600

6.     Open the Ms-Excel program from your computer. Calculate the following data in Sheet 1 of Ms-excel. Save it.
a. Create the following table in Ms-Excel.

S.N.	Student Name	Marks	Remarks (Pass or Fail)
1	Rohan Bhatt	30
2	Ram Joshi	45

b. Find the remark “Pass”, if marks are 35 or above, otherwise fail.

7.     Perform the following tasks in Ms excel 2007. Save it.

a. Input the following table for the salary sheet.

S.N.	Name	Designation	Monthly Income	Yearly	Tax %	Tax amount
1	Lalita Pant	Officer	35000
2	Raju Bohara	Na su	28800

 b. Calculate Yearly Income:- =D2 x 12

c. Calculate Tax% =1% if yearly income is below 350000, otherwise 5%

8.     Start Microsoft Excel Spreadsheet. Create the following table in Sheet1. Do the following tasks in Ms-Excel Application Software. Save it
a. Calculate the Discount Amount and Total Amount of Vegetable shop.
b. If anyone buys potatoes more than 10 kg, then discount 2%.
If anyone buys tomatos more than 10 kg, then discount 5%.

S.N.	Vegitables Name	Rate (Rs.)	Kg	Amount	Discount %	Discount Amount	Total Amount
1	Potato	40	20
2	Tomato	100	9

9.     Perform the following operations in the Ms-Excel app. Save it with the name “Result”.
a. Make the following excel table in sheet 1.

S.N.	Student name	Marks	Division (Distinction, First, Second, Third, Fail)
1	Santosh Bhatt	55
2	Thaneshwar Bhatt	88

 b.     Calculate the Division of students as follows:

• If marks are above 80, Distinction,
• If marks are greater than or equal 60 and below 80 as First Division,
• If marks are greater than or equal 45 and below 60 as Second Division,
• If marks are greater than or equal 32 and below 45 as Third Division, otherwise fail.

10.      Perform the following questions in Microsoft excel. Save it with name “Salary Sheet”.
a. Open ms excel document. Type the following employee table.

S.N.	Name	Designation	Salary	Allowance
1	Priya Joshi	Manager	40000
2	Rita Bohara	Officer	50000

b. Calculate the allowance of an employee as follows
Allowance:
For Manager = 5%
Officer = 3%,
Otherwise = 1%

From the Ms-Powerpoint unit

I have collected questions for Ms-Powerpoint. Practice. Practice well and try to answer those questions in time. If you need other similar questions, please write in the comment box below. I will upload it on the website for your preparation. If there is any problem in solving it, please write in the Comment Box. Even from these units, I have put 10/10 questions here. Practice.

Q.No. 1.     Create a presentation for a teacher to present in his class about Computer Generations. The presentation should contain 1 slide. The text should appear flying in when slide show. [1 marks]

Q.No. 2.     Create a presentation at least 1 slide about Public Service Commission and its objectives. Use automatic slide advancement.

Q.No. 3.     Make a presentation within 1 slide to describe yourself. Use automatic slide advancement effect by 5 seconds.

Q.No. 4.     Prepare a presentation about sales details of a company.

Item	Sales Qty
Hard Disk	1500
CPU	2250
Mouse	3000
Keyboard	1250

- Show the sales details in bar diagram. 

Q.No. 5.     Perform following tasks in PowerPoint.

a. Create a slide with following

Computer Generations
· First Generation
· Second Generation
· Third Generation
· Fourth Generation
· Fifth Generation

b. Apply custom animation so that those five generations will appear flying in.  

Q.No. 6.     Create a presentation file with 1 slide about computer generations. Apply transaction effect and slide advances every two seconds automatically. [1 marks]

Q.No. 7.     Create a presentation with 3 slides to give an introduction to where you live. Set the auto timing to show for 1 second, 3 seconds, and 1 second for the first, second, and third slide respectively. Show the slide numbers at the bottom right of each slide. [1]

Q.No. 8.     Create 2 slides, when the slideshow starts after the first slide second slide will display after 50 seconds without clicking the mouse and using the keyboard. (2068)

Q.No. 9.     Make a presentation describing "Public Service Commission" in 1 slide with suitable animation. (Hetauda)

Q.No. 10.   Create a presentation with 1 slide. The first slide should contain the title and a chart. Apply 'Textured' slide design to the presentation.   

Window Basic Email and Internet 

I have put here the questions of Window Basic, Email, and internet asked in the computer skill test of the Public Service Commission and other Offices. I have collected these questions from various websites, Facebook, candidates. It is very important for the candidates to be included in the computer skills test. I will keep only 10/10 of these questions. If you need more, please write in the comment box (keep more questions). Practice. If you don't know how to solve it, ask in the comment box. I even have a Telegram Group. After a good practice, try to solve those questions in time. Please solve other similar questions as well.

1.        Complete the following task related to Window basic.

a.      Create a shortcut of any file at the desktop.

b.      Create a folder on the desktop and make it read-only.

2.        Create a folder named as "Format" on desktop and change the icon of the folder.

3.        Insert the file path of the current word file.

4.        Copy your all files of your current test folder. Make a new folder named “Important The document” on any drive except c: drive and paste it on that folder.

5.        Find the IP address of your computer, screen shoot the image and save it an image on desktop.

6.        Show the window from where you uninstall or change a program. Screenshot the image and save it as an image on the desktop name as “uninstall”.

7.        Create a folder named “Shared Documents” on drive D: and share that folder in the local network. Take a snapshot, save it as an image on the Desktop.

8.        Create a shortcut of any file, a folder that is stored on the hard drive  of the computer:

9.     Find screen resolution of your computer, take a snapshot and put it into your test folder.

10.    Check your window is activated. Screenshot the image, paste it into the word file and save it.

11. Change the background image of the screen of your PC.

12. Format a pen drive and change its level.

13. Delete a file and then recover it.

14. Change the screen resolution.

15. Show the steps of creating a new folder and copy any one file in that folder.

16. Find errors on your hard disk

17. Increase the size of desktop icons.

18. Change the date and time of the system and then restore the original settings of data and time

19. Share a file with other computers using a password.

20. Create a picture file and reduce its size.

21. Create a folder in D-drive and copy a file in it.

22. Perform the ScanDisk function

23. Find the list of all active processes and applications.

24. Change the sound setting of your PC; mute all the sounds.

25. Change the wallpaper and appearance of your desktop.

26. Find the disk errors and report the actions taken to recover from those errors.

27. Recover a file that has been deleted.

28. Find all the audio devices connected to your computer. Screenshot it.

29. Show how you can change the Start Menu. Screenshot your work.

30. Your hard disk has some errors, demonstrate the tool that you would use.

If you have any queries, comment below in the comment box.

For more Updates and to download PDF files, Join my Social Profiles.

Join my Telegram Group:- Mohan Bhatt Telegram Group

Also Like & Share my Facebook Page:- Mohan Bhatt Facebook Page

If you want also Practical questions on the Ms-Word, Ms-Excel, Ms-Powerpoint & HTML topic, click the link

Ms-Word (Word Processing) Practical questions collection  PSC to learn more about your Computer Skill Test.

Ms-Excel (Electronic Spreadsheet) Practical questions collection  PSC to learn more about Ms-Excel questions.

Ms-Powerpoint (Presentation) Practical questions collection  PSC to learn more about your Computer Skill Test.

HTML (Web Designing) Practical questions collection  PSC to learn more about HTML.

Computer Typing, Ms Office Setting & Interview Guide will help you in your computer skill test exam.  Click the link below

Tips on Computer Typing, Ms Office Setting & Interview Guide

 

And further, if you need the preparation and practical guide for the final exam. The post or article Practical Exam Guide Exam of PSC and the other article about Sample Job Interview Questions really helps you.

Any other information regarding on it, you can ask in the comment section, visit the next page to read more about learning materials for the Public Service Commission.