Computer Operator Practical Exam Ms-Excel Questions Collection

I have collected and presented the questions asked from Ms-excel in the final stage of Computer Experimental Examination for the posts of Computer Operator and Assistant Computer Operator under Public Service Commission Local Level, State Government, and Union. It is also useful in non-technical aspects. I will provide the solution later. If you have any queries, please comment in the comment box.
Q.No. 1. Perform the 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) Create a bar chart to show the target and production of three places under observation.
Q.No.2 Enter the 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 a thick line border around the table and a single thin line for the inner lines. (1)
e) Enter “Interest Calculation” as header and set page number at the bottom center of the 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 the following data in your worksheet and calculate values for empty cells. (5)

क्रम ;;;;संख्या	नाम थर	;;संकेत नं‍‌	cf=a= @)^%–^^	cf=a= @)^^–^&	cf=a= @)^&–^*	s"n	cf};t
!	kbdk|;fb sf]O/fnf	!#&(@	(*[email protected]@	((	(*=*(
@	sdn/fh bfxfn	#$!#	!))	(([email protected]	!))
#	/fdafa' e6\6/fO{	@$!#%	(#=^	(&	((

a. On the worksheet, configure the settings so that the marks in the third, fourth, and fifth columns 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 the 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

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