लोक सेवा आयोगद्वारा लिइने राजपत्र अनंकित प्रथम श्रेणी, कम्प्युटर अपरेटर पदको प्रयोगात्मक परीक्षाको लागि nareshmdr.com.np/ictexams द्वारा तयार पारिएको
(लोक सेवा आयोगको पाठ्यक्रममा आधारित नमुना प्रश्न)
Computer Operator Practical Question (Model Set-1)
Q. No.1: You are the secretary of a Company. Make a list of 9 share holders of the company and prepare the letters to attend the meeting held on September 29, 2013.
Q.No.2: Prepare the following bill and calculate the bill amount for the customers. Also create a suitable chart.
Cust.No. |
Name |
Current Meter Reading |
Previous Meter Reading |
Consumed Unit |
Bill Amount |
A1001 | RajKumar Sharma | 1250 | 1130 | ||
A1002 | Hari Shankar | 1320 | 1305 | ||
A1003 | Anita K.C. | 768 | 599 | ||
A1003 | Sarita Thapa | 1380 | 1125 |
Condition: Minimum Charge upto 20 units is Rs.80, the charge for 21 to 250 units is Rs.7.30 per unit and the charge for more than 250 units is Rs.11.50 per unit.
Q.No. 3. Create a presentation (at least 3 slides) about Public Service Commission and its objectives. Use automatic slide advancement.
Q.No.4: Create a database and make a table named “salary” having the following fields:
empid, empname, address, dept, salary
- Insert any five records.
- Create a query to show the employees of “Account” department whose salary is greater than 10000.
Q.No.5: Crete a webpage and make the following table.
ABC Company Limited
Banepa, Kavre
Staff Details
S.N. |
Name |
Address |
Salary |
1. |
Hari Dhital |
Banepa |
15000 |
2. |
Kedar Sharma |
Panauti |
17000 |
Total |
32000 |
Wish You all the best!!!
Prepare By: Manoj Kumar Neupane (9851111638)
लोक सेवा आयोगद्वारा लिइने कम्प्युटर अपरेटर पदको प्रयोगात्मक परीक्षाको नमुना प्रश्नः
1. १० मिनेट भित्र दिइएको ४०० शब्दको Nepali Typing । = 15 Marks
2. ५ मिनेट भित्र दिइएको २२५ शब्दको English Typing । = 5 Marks
3. Word Processing मा Document तयार पार्ने, Formatting गर्ने लगायतका कामहरु = 10 Marks
4. Electronic Spreadsheet (EXCEL) मा Formula लगाएर Calculation । =10 Marks
5. PowerPoint मा Presentation तयार पार्ने = 3 Marks
6. MS Access मा database (Table, Query, Form, Report) = 4 Marks
7. HTML प्रयोग गरी Webpage बनाउने = 3 Marks
ke type garnu parne ho tesko sample rakhe sajilo hunthyo ki.
Thnak y sir, for this questions
please keep other sets.
thank u
sir i am happy. sir gold membership banna k garnu par6 . 9848192215 ma call garnuhola.
You do not have to pay any fee to be the member of our site. Its totally free of cost.
thank u sir
i would be thankful if you include some more model paper of computer paper. Thank you !!!!
answer pani dinu vaya ramro huntheyo sir
Sir Please Solved Qu.n0. 2
Formula for Question No. 2
Let,
Cust.No. -> Column A1
Name -> Column B1
Current Meter Reading -> Column C1
Previou Meter Reading -> Column D1
consumed Unit -> Column E1
Bill Amount -> Column F1
Now,
Formula for Unit Consumed (E2) =C2-D2
Formula for Bill Amount (F2) =IF(E2< =20,80, IF(AND(E2>20,E2<=250),80+(E2-20)*7.3,80+230*7.3+(E2-250)*11.5))
Dear Sir,
Mathi ko Bill Ammount calculate garne formula ma 230*7.3 kasari vayo ,maile bujhina ,please vanidinu huncha ki…
Because cost per unit from 21 to 250 unit (which is 230 unit) is Rs 7.3, that means cost of 230 unit is 230×7.3
which formula is used for subtracting in msword?
please tell me sir
You can subtract numbers containing in the Cells of MSWord table same as you do in Excel.
For example, if you want to subtract 1st column and 1st row with 1st column and 2nd row and want to place result in 1st column and 3rd row, place cursor in 1st column and 3rd row and click on formula (in layout ribbon) and type =(a1)-(a2) then click on OK
सर, मैले तपाइको Model Question set 1 राम्ररी अध्धयन गरियो तर यसमा दिइएको प्रश्न २ लाइ हाल गर्न सकिएन| यसका लागी केहि Hint पाए धेरै आभारी हुने थिए |
To develop a formula to solve problems or to calculate something in excel, first of all think what will you do if you have to calculate the result manually and then try to convert your manual process to formula.
i am a student
So what ???
You are great
would like to mind please share the modern questions
Why not !
hi, i will be thankful if you post the solution of sub computer operator 2073 or i will be thankful you provide me some link for that.i am waiting to hear from you. thnk you
Help me question no. 4 and 5.please?
Please click on the following link to download solved file.
http://nareshmdr.com.np/ictexams/uploads/model-1.zip