Computer Operator Practical Set-2 | Lok Sewa Aayog Practical Examination Preparation

 


Computer Operator Practical Set-2

Practice all the questions to improve your practical skills and boost your confidence for the Lok Sewa Aayog Computer Operator Examination.

1. Type given Nepali text as many words as you can type within 5 minutes:

नेपाल दक्षिण एसियामा अवस्थित एक सुन्दर, शान्त र प्राकृतिक सम्पदाले भरिपूर्ण देश हो। यसको उत्तरमा चीन र पूर्व, पश्चिम तथा दक्षिणमा भारत पर्दछन्। नेपालको राजधानी काठमाडौं हो। नेपाल विश्वकै सर्वोच्च शिखर सगरमाथाको देश भनेर विश्वभर प्रसिद्ध छ। यहाँ विभिन्न जातजाति, भाषाभाषी, धर्म, संस्कृति र परम्पराका मानिसहरू मिलेर बसेका छन्।

नेपाल प्राकृतिक सौन्दर्यका दृष्टिले अत्यन्त धनी देश हो। यहाँ हिमाल, पहाड र तराई गरी तीन भौगोलिक क्षेत्र छन्। सगरमाथा, कञ्चनजङ्घा, अन्नपूर्ण र माछापुच्छ्रे जस्ता सुन्दर हिमालहरूले नेपालको गौरव बढाएका छन्। नेपालमा कोशी, गण्डकी र कर्णालीजस्ता ठूला नदीहरू रहेका छन्। चितवन राष्ट्रिय निकुञ्ज, सगरमाथा राष्ट्रिय निकुञ्ज र लुम्बिनी यहाँका प्रमुख पर्यटकीय स्थल हुन्। लुम्बिनी गौतम बुद्धको जन्मस्थल भएकाले विश्वभर प्रसिद्ध छ।

नेपाल कृषि प्रधान देश हो। यहाँका अधिकांश मानिसहरू कृषि, पशुपालन, व्यापार, पर्यटन र विभिन्न व्यवसायमा संलग्न छन्। नेपालको प्रमुख खाद्यान्न बाली धान, मकै र गहुँ हुन्। जलस्रोत, वनजङ्गल, जडीबुटी र पर्यटन नेपालको आर्थिक विकासका महत्वपूर्ण आधार हुन्।

नेपालले विभिन्न समयमा राजनीतिक परिवर्तनहरू पार गर्दै २०७२ साल असोज ३ गते नयाँ संविधान प्राप्त गरेको हो। वर्तमान संविधानले नेपाललाई संघीय लोकतान्त्रिक गणतन्त्रात्मक राज्यका रूपमा स्थापित गरेको छ।

नेपाल हाम्रो प्यारो मातृभूमि हो। यसको प्राकृतिक सम्पदा, सांस्कृतिक विविधता र राष्ट्रिय एकता हाम्रो पहिचान हुन्। हामी सबैले देशको विकास, संरक्षण र समृद्धिका लागि इमानदारीपूर्वक योगदान दिनुपर्छ। देशलाई स्वच्छ, सुन्दर, शान्त र समृद्ध बनाउनु प्रत्येक नेपालीको कर्तव्य हो।

 

2. Type given English text as many words as you can type within 5 minutes:

Nepal is a beautiful country known for its geographical, cultural, religious, linguistic, and biological diversity. Although Nepal is a small country in South Asia, it is rich in natural beauty and cultural heritage. People from different communities, religions, castes, and ethnic groups live together in harmony. Nepal is divided into three geographical regions: the Himalayan region, the Hilly region, and the Terai region. Each region has its own climate, landscape, vegetation, and lifestyle. The Himalayan region is famous for its snow-covered mountains, including Mount Everest, the highest mountain in the world. The Hilly region is known for its beautiful valleys, hills, and forests, while the Terai region is famous for its fertile land and agricultural production.

Nepal is home to various ethnic groups such as Brahmin, Chhetri, Tharu, Newar, Tamang, Magar, Gurung, Rai, Limbu, Madhesi, and many others. People celebrate different festivals, including Dashain, Tihar, Chhath, Holi, Lhosar, Eid, and Christmas. Hinduism, Buddhism, Islam, Christianity, and other religions are practiced in Nepal. Many languages are spoken in Nepal, including Nepali, Maithili, Bhojpuri, Tharu, Tamang, Nepal Bhasa, and others. Nepali is the official language of the country.Nepal is also rich in biodiversity. It has different species of plants, animals, birds, and medicinal herbs. Rare animals like the one-horned rhinoceros, Bengal tiger, red panda, and snow leopard are found here.

In conclusion, diversity is the greatest beauty and strength of Nepal. It promotes unity, tolerance, cooperation, and mutual respect among people. We should respect all cultures, languages, religions, and traditions to maintain national unity and build a peaceful, prosperous, and inclusive Nepal.

3. Copy the text given in Question No. 2 and perform the following formatting tasks:

a) Set the line spacing of the entire document to 1.8 lines.

b) Insert “Practical Test” in the header, aligned to the top-left corner, and insert the page number at the bottom-right corner.

c) Change the page orientation to Landscape.

d) Set the page margins as follows:

  • Top Margin: 1.5 inches
  • Left Margin: 1.5 inches

e) Create the following list using appropriate bullets and sub-bullets:

  • Mathematical Equation
    • 3X² + 5
  • Chemical Reaction
    • CO₂

f) Create the following table and insert a hyperlink to open the Public Service Commission website.

SN

Name

Website URL

Code

1

Public Service Commission

www.psc.gov.np

0120

g) Save the document with the filename Practical_Test.docx.

h) Restrict document editing so that users can only read the document (Read Only).

 

4. Create the following student marksheet using MS Excel, maintaining the given layout and formatting.

Student Marksheet

Name

English

Math

Science

Total

Result

Ram

Shyam

Umesh

Rakesh

a) Enter marks for each student, assuming that the full marks for each subject are 100.

b) Calculate the total marks obtained by each student using an appropriate formula.

c)  If a student's total score is 220 or above, display "Selected"; otherwise, display "Rejected".

d) Copy the student records to another worksheet and sort the data in descending order based on the Total column.

e) Create a Bar Chart showing each student's name and total score. Set the chart title to "Total Score Marked".

 

4. Create a table named Personal with the following fields:

  • EId
  • EName

a) Enter at least four employee records into the table.

b) Create a query to display employee IDs (EId) and employee names (EName) in ascending order.

c) Create a query to count the total number of employee records in the Personal table.

 

5. Create a presentation consisting of three slides.

a) Insert the current date, time, and slide number on all slides.

b) Apply any suitable design theme to the presentation.

c) On the second slide, insert an object (such as a table or image) and apply an animation effect to it.

d) Apply any suitable slide transition effect to all slides.

e) Insert "Public Service Commission" as the footer text on every slide.

 

6.  Create an HTML webpage with the text "Ministry Contact" scrolling across the top of the webpage.

a) Create the following table and insert hyperlinks to open the respective organizations' websites.

Organization Name

Website URL

Telephone

Ministry of Communication and Information Technology

www.mocit.gov.np

140053245

Ministry of External Affairs

www.moca.gov.np

140036589

Ministry of Foreign Affairs

www.mofa.gov.np

1500369854

Ministry of Home Affairs, Nepal

www.moha.gov.np

1698500010

b) Apply appropriate formatting to the webpage using HTML and CSS.

Best of Luck!

Post a Comment (0)
Previous Post Next Post