Computer Operator and Assistant Computer Operator Practical Questions Collection: Ms-excel

लोक सेवा आयोग स्थानीय तह, प्रदेश सरकार र संघ अन्तरगत प्राविधिक तर्फका Computer Operator र Assistant Computer Operator पदहरुका लागि Ms-excel को महत्वपूर्ण प्रश्नहरुको नमूना संकलन । साथै अप्राविधिक तर्फ समेत उपयोगी । Solution समेत उपलब्ध गराउने छु । केही भय Comment गर्नु होला ।

Q.No. 1. Perform following calculation in MS-Excel.

Places	Target	Production	Achievement	Grade
Dolakha	4800	6000	125%
Sindhupalchwok	5000	4500	90%
Kavrepalanchwok	5000	5000	100%
Average	4933.33	5166.67	104.73%

a)      Calculate grade A+ for more than 100% achievement; A for 100% achievement and B for below 100% achievement.

b)      b. Create a bar chart to show the target and production of three places under observation.

Q.No.2  Enter following data in your worksheet.

Loan Amount	13500
Loan Duration in Years	7
Rate
Interest

a) Enter formula for the rate so that it will be 14% if Loan Duration is less than 5 years and Loan Amount is more than one lacks, otherwise it should be 8%. (2)

b) Calculate Interest = Loan Amount x Loan Duration x Rate / 100 (1)

c) Change the value of Loan Duration as necessary to get 80000 in Interest. (2)

d) Apply thick line boarder around the table and single thin line for the inner lines. (1)

e)  Enter “Interest Calculation” as header and set page number at the bottom center of page. (2)

Q.No.3 Create a bar chart with the following data in Sheet 1. (5)

Chart Title: “Crop Production on 2005-2010”.

X-Axis: Year

Y-Axis: Production

	2005	2006	2007	2008	2009	2010
Rice	3476	3485	3488	3490	3499	3500
Wheat	3000	3200	3500	3700	3900	4300
Maize	2854	2967	3087	3154	3223	3410
Barley	4000	3800	4200	4500	4800	4000

Q.No.4. Calculate commission for following data in Sheet 1. (5)

SNO	Product	Cost Price	Selling Price	Commission Percentage	Commission Amount
1	Makita Hand Drill 3420	$3000.00	$4200.00
2	Philips Steam Iron PS243	$300.00	$385.00
3	Soni Camcord $C331	$1200.00	$1800.00

a. Commission is 7% for all (Selling Price-Cost Price) is more than $500, otherwise it is 4%.

b. Commission Amount is calculated as Commission Percentage of Cost Price.

Q.No.5. Enter following data in your worksheet and calculate values for empty cells. (5)

qmd ;+Vof	Gffd y/	;+s]t g+a/	cf=a= @)^%–^^	cf=a= @)^^–^&	cf=a= @)^&–^*	s"n	cf};t
!	kbdk|;fb sf]O/fnf	!#&(@	(*=@@	((	(*=*(
@	sdn/fh bfxfn	#$!#	!))	((=@	!))
#	/fdafa' e6\6/fO{	@$!#%	(#=^	(&	((

a. On the worksheet of No1, configure the settings so that the marks in third, fourth and fifth column will be automatically displayed in red color when they are less than 99. (2)

b. Create a line chart to show the increasing or decreasing trend in share market in Sheet 2.

Organization	First Week	Second Week	Third Week	Fourth Week
Bank of Kathmandu	235	255	312	200
Everest Bank	110	150	180	212
Sanima Bank	300	235	200	220

a. Create lines for each bank in different color and show the index to indicate which color is for which bank.