Computer Operator Practical Set-1

 

Public Service Commission 

Computer Operator Practical Set-1

Digital Nepl69


Create a folder named as Digital Nepal69_YourSymbol No. Use to save all your files inside this folder as needed. 

WORD-PROCESSING 

1)  Design a thank you letter to your teachers and relatives giving them credit of your success on Computer  Operator Examination 2078. Prepare letters for every individual using the information below: (10) 

a) Set the pages as Aqua Accent Page color. 

b) Page border should be double lined Showed on Red Accent 2 color as darker as your    wish. 

c) Set the watermark as your full name in any Devnagari Font having any one font style. 

 

S.N. 

Name 

Last Name 

Address 

Relation

Poonam 

Sharma

Jaleshwar-2, Mahottari 

Teacher

Prem 

Basnet 

Pokhara-5, Kaski 

Teacher

Ram 

Bahadur

Janakpur-12,Dhanusha 

Uncle

Raju 

Karki

Kirtipur-2, Kathmandu

Friend

Dipak

Bhujel

Lumbini-4, Lumbini 

Friend

 

SPREADSHEET 

2) Design & calculate a Vat Bill of "The Mithila  Resort" where the following items has been served to you.

a) Save your sheet as excel binary file. 

b) Insert a appropriate chart to show the proper info graphic of the bill. 

c) Set currency data format on appropriate field.  

 

S.N.

Item Name

Rate

Quantity

Service

Charge

VAT

Disscount

Total

1.

Momo

80

6

 

7%

 

13%

 

5%

 

2.

Chowmin

100

5

 

3.

Pizza

250

12

 

4.

Burger

120

9

 


DATABASE 

3) Create the table "Client" and entry the following records. Create a query to show only those Clients details  who have more than Rs 5000 due amount.. 

a) Set the Client Name Field's first letter should be in capital. 

b) Set client history Field as '...Years' when you type the number it automatically output 'Years'. 

 

S.N.

Client Name

Package Type

Location

Client History

Due Ammount

1.

Sagar Upaddhay

128 Kbps

Jaleshwar

4 years

2600

2.

Bipana Dhakal

256  Kbps

Suga

3 years

3500

3.

Rajesh Khanal

5 Mbps

Matihani

5 years

3000

4.

Sweta Bhatta

10  Mbps

Sari

2 years

6000

5.

Laxmi Shrestha

20 Mbps

Bajrahi

6 years

5500



PRESENTATION 

4) Create a presentation having 3 slides where first slide is for info about your institute, second for the list of  founding members of your institute and the last one for the service you provide. Set your preferred  transaction and design. 

HTML 

5) Make an html page which shows your own bio-data.

 

*** Digital Nepal69 ***

Post a Comment (0)
Previous Post Next Post

ADS 1

ADS 2