12:12:00
1st Year Computer Science Student Practical No. 04 (b)
PRACTICAL NO. 4(B)
INPUT :-
B) Enter a
Formula to calculate unit consumed. Excel Using spread sheet. Create a utility
bill of electricity according the instruction:
|
METER
NUMBER
|
PREVIOUS
UNITS
|
CURRENT
UNITS
|
UNITS
CONSU
MED
|
ELECTR
ICITY
CHARGES
|
SURCHA
RGE
|
AMOUNT
PAYABLE
|
|
SN-256
|
78561
|
88650
|
|
|
|
|
|
SN-654
|
65445
|
87
|
|
|
|
|
|
SN-785
|
78564
|
66471
|
|
|
|
|
1)
Enter a Formula to calculate units consumed.
2)
Cost of one unit of electricity is RS. 2.26.
3)
Computer the surcharge as 15% of electricity charge.
4)
Computer the amount due as.
5)
Amount due
= electricity + surcharge.
6)
And round up the amount pay able to one decimal
place using ROUND () function.
7)
Save and also print.
PROCEDURE:-
1. Click
file option from file menu, click
new,
2. Type
the heading, type column header as given in the question. (e.g. meter no,
pervious unit etc.) in second row and in columns from A to G.
3. Under
the heading “Meter No”, enter Meter
No. in cells from A4 to A7, likewise enter the data (according to question) in
“column and “current unit” column.
4. Place
the cursor in first data cell (D4) of “unit
consumed” and type formula:
=current unit – pervious unit.
5. Place
the mouse pointer at the corner of this cell (D4), a + this sing appears ; drag
this fill till last data cell (D7).
6. Place
the cursor in first data cell (E4) of “Electricity
charge” and type formula:
=Units consumed*2.26
7. Drag
fill corner of this cell (E4) till last data cell (E7).
8. Place
the cursor in the first data cell (F4) of “Surcharge”
and type formula:
=Electricity charge*15/100
9. Drag
fill corner of this cell (F4) till last data cell (F7).
10. Place
the corner in the first data cell (G4) under the heading “Amount payable” and type
formula: =ROUND (Electricity charge+
surchange,0)
11. Drag
fill corner of this cell (G4) till data cell (G7).
12. Click
File option from File menu, click save or short key by pressing Ctrl +S for
save document.
13. Click
file option from file menu, click Print.
14. Optional
if you want page setting, click file menu, click page setup.
No comments
Post a Comment