लोक सेवा आयोगद्वारा लिइने राजपत्र अनंकित प्रथम श्रेणी, कम्प्युटर अपरेटर पदको प्रयोगात्मक परीक्षाको लागि nareshmdr.com.np/ictexams द्वारा तयार पारिएको
(लोक सेवा आयोगको पाठ्यक्रममा आधारित नमुना प्रश्न)
Computer Operator Practical Question (Model Set2)
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
Kindly send me the solution of excel question no. 2 sir ! thanks in advance !!!
Sir kindly send me Question no.5 Ans me . pls send me sir
please provide answers of model practical questions thank you
Kindly send me the solution of this question sir ! thanks in advance !!!
can you send the formula of question no.2
See the formula.
absolute formula it help me to develop new formula
????
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*450IF(D2>4,(D24)*225)+IF(C2>26,(C226)*225)
Sir, I have written
=IF(AND(C2D2=30),C2*450+4*(450*50%),(C2*450(D2*(450*50%))))
SN > Column A1
Name > Column B1
Working Days > Column C1
Absent Days > Column D1
Wages > Column E1
Is it wrong?
yes, it is wrong
I need database question
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.
help me with qn 1
help me with q n 1
First of all prepared the given letter in MSWord and then use Mail Merge and provide emails of any ten persons to send them the document
Iam student .
So what????
Would you mind telling to me about the answer of question number 3 and 5.
Please click on the following link to download solved file.
http://nareshmdr.com.np/ictexams/uploads/model2.zip
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)