Computer Operator Practical Question Model-2

लोक सेवा आयोगद्वारा लिइने राजपत्र अनंकित प्रथम श्रेणी, कम्प्युटर अपरेटर पदको प्रयोगात्मक परीक्षाको लागि nareshmdr.com.np/ictexams द्वारा तयार पारिएको

(लोक सेवा आयोगको पाठ्यक्रममा आधारित नमुना प्रश्न)

 Computer Operator Practical Question (Model Set-2)

1.  तलको विवरण अनुसारको पत्र तयार पारी १० जनालाई पठाउनुहोस् ।

उपकार बचत तथा ऋण सहकारी संस्था लिमिटेड

तीनदोबाटो, बनेपा, काभ्रे

मितिः २०७०।०५।२४

श्री………………..……………………ज्यू

………………………………..………..

 विषयः बैठकमा उपस्थित हुने बारे ।

       यस संस्थाको संचालक समितिको बैठक तपसीलको मिति, स्थान र समयमा हुने भएकोले यहाँको अनिवार्य उपस्थितिका लागि हार्दिक अनुरोध गर्दछु ।

बैठक कार्यक्रमः

मितिः २०७०।०६।१० गते

समयः विहान ७ बजे

स्थानः संस्थाको कार्यालय, तीनदोबाटो, बनेपा, काभ्रे ।

केदार धिताल

कम्पनी सचिव

2. Calculate the wages for the following workers.

S.N.

Name

Working Days

Absent Days

Wages

1. Sanjaya Neupane

20

10

2. Sarita Ghimire

24

6

3. Hari Sharma

28

2

4. Raju Acharya

29

1

Conditions: Rs.450 is given for working days and 4 days holiday is announced per month. 50% amount is deducted for absent days except holidays and 50% extra wages is given for working on holidays.

3. Create a database and make a table “employee”.

empid, empname, address, dob, salary

- Insert 5 records.

- Make a query to display the list of employees whose age is more than 25 years.

4. Make a presentation with in 3 slides to describe about yourself.  Use automatic slide advancement effect by 5 seconds.

5. Create the following HTML document using notepad.

City

Population

Male

Female

Banepa 55000 58000
Kathmandu 105700 108900
Bhaktapur 33000 29500

Wish You All the Best!

©Manoj Kumar Neupane

23 comments

  1. Bswaraz says:

    Kindly send me the solution of excel question no. 2 sir ! thanks in advance !!!

  2. sanjita karki says:

    please provide answers of model practical questions thank you

  3. Manoj says:

    Kindly send me the solution of this question sir ! thanks in advance !!!

  4. suman says:

    can you send the formula of question no.2

  5. Formula for question No. 2
    Let,
    SN -> Column A1
    Name -> Column B1
    Working Days -> Column C1
    Absent Days -> Column D1
    Wages -> Column E1

    Formula for E2:
    =C2*450-IF(D2>4,(D2-4)*225)+IF(C2>26,(C2-26)*225)

  6. Lokesh Thagunna says:

    I need database question

  7. JanakDhami says:

    Give me answer question number 1 sir

    • 1. Prepare given letter in MSWord
      2. Click on “Mailings” ribbon
      3. Click on “Start Mail Merge” and then “Step by Step Mail Merge Wizard”
      4. A “Mail Merge” task pane will be display in the right side and follow the instructions.

  8. heera koli says:

    help me with qn 1

  9. heera koli says:

    help me with q n 1

  10. Hari Magar says:

    Would you mind telling to me about the answer of question number 3 and 5.

  11. Kameshwar says:

    Dear Naresh Manandhar sir plz solve my problem. Condition for interest Calculation :- (1) If deposit amount is equal or less than 50000, interest rate is 5%. (2) If deposit amount is equal or greater than 50000, interest rate is 6%. (3) If deposit amount is equal 100000, interest rate is 7%. (4) If deposit amount is greater than 100000 and less than 500000,interest rate is 8%. (5) If deposit amount is equal 800000, interest rate is 9%. (6) If deposit amount is greater than 800000 and less than 1000000, interest rate is 10%. (7) If deposit amount is greater than and 1000000, interest rate is 15%.
    (If year is greater than 2 year, interest rate will increase by 1%)

    • Deposited amount 50000 lies in both the condition 1 and 2 which is ambiguous, so the question is wrong.
      Condition 1: Deposited Amount >=50000 (Includes 50000)
      Condition 2: Deposited Amount <=50000 (Includes 50000)

Leave a Reply

Your email address will not be published. Required fields are marked *


*

*