लोक सेवा आयोग स्थानीय तह, प्रदेश सरकार र संघ अन्तरगत प्राविधिक तर्फका 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.
No comments:
Post a Comment