Q.No.1: Prepare the
following bill and calculate the bill amount for the customers. Also create a
suitable chart.
Cust. No.
|
Name
|
Current Meter
Reading
|
Previous Meter
Reading
|
Consumed
Unit
|
Bill
Amount
|
A1001
|
RajKumar Sharma
|
1250
|
1130
|
||
A1002
|
Hari Shankar
|
1320
|
1305
|
||
A1003
|
Anita K.C.
|
768
|
599
|
||
A1003
|
Sarita Thapa
|
1380
|
1125
|
Condition: Minimum Charge upto 20 units is
Rs.80, the charge for 21 to 250 units is Rs.7.30 per unit and the charge for
more than 250 units is Rs.11.50 per unit.
Q.No.2. Enter following data in speadsheet and perform
as asked. (10)
SN
|
EMP Code
|
Sale AMT
|
Commission
|
Earning
|
Tax
|
Net Earning
|
1
|
1001
|
5000
|
||||
2
|
1002
|
3800
|
||||
3
|
1003
|
4000
|
a. Enter above
data in sheet 1. (2)
b. Calculate
Commission as 7% of Sales AMT. (1)
c. Calculate
Earning as sum of Sales AMT and Commission. (1)
d. Calculate Tax
as 13% of Earning for all Sales AMT equal or more than 4000. (2)
e. Calculate Net
Earning as the difference of Earning and Tax. (1)
f. Create a
column chart showing Earning and Net Earning for each EMP Code. (3)
Q.No.3. Create a line chart from following data. (10)
Product
|
January
|
February
|
March
|
April
|
May
|
June
|
Platinum
|
7000
|
|||||
Gold
|
2002
|
|||||
Silver
|
3003
|
Fill up the
blanks cells with following informations.
a. The quantity
of Platinum and Silver was increased by 20% in February and March.
b. The quantity
of Platinum is decreased by 5% in April and 4% increament in May and June.
c. The quantity
of Gold was steadily increasing by 3% in every months.
d. The quantity
of Silver was decreased by 2% in April, May and June.
Q.No.4. Calculate the Increment using by excel.
A
Trading company distributes incentive salary to the staff 25000/- because of
company boomed up.
SN
|
Designation
|
Before Increment
|
1
|
CEO
|
198000/-
|
2
|
Manager
|
150000/-
|
3
|
.........
|
........
|
4
|
.........
|
........
|
5
|
.........
|
........
|
Calculate the
increament Salary
a. Calculate the
Percentage as
(After Increment
Salary - Before Increment Salary)/Before Increment Salary * 100
b. Show the
percent in pie chart view.
Q.No. 5. Enter following data in Excel Worksheet. (10)
Product
|
Date
|
Qty
|
Rate
|
Disc%
|
Amount
|
USB Extension
|
150
|
186
|
7
|
||
Pen Drive
|
3000
|
1600
|
12
|
||
Memory Sticks
|
500
|
668
|
7
|
Fill up the
blanks cells with following information.
a. Display
current system data in Date column in YMD format such as 13 Oct 2012.
b. Format the
Rate column with one decimal digit and currency such as Rs. 186.0
c. Calculate
Amount for each row.
No comments:
Post a Comment