Excel prectis Set (Sumit_yadhuvansi).pdf
161 views
24 slides
May 04, 2024
Slide 1 of 24
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
About This Presentation
Excel is a powerful spreadsheet program commonly used for data analysis, calculations, and organizing information.
Slide Content
\'ALU£ J
OM SAi COMPUTBa INSTITUTE
Set: 1
Microsoft Excel 2007
VALUE 2
J+2•V/\LUE 3 \/ALU[ 3 · ...... \it,LUB•VAlU£4 VAI.UE S/ ...... .
4 s 6
✓ VAlUI: l WILL DE ADD WITH VALUE 2 (20+10) = VALL1E 3 (30)
✓ VAt lJC J (30) WILL SUUSl'RACT UY ANY NUMBER, ex ... 30-4 = 26. WOULD B~ VALUE~-
✓ VALUC 4 (2<i) WILL OE MULl'IPY UY ANY NUMBER, ex ... 2GX2 :::52. WOULD GE VALUE 5.
✓ VALUI! S (52) WILL Ot: CIIVIDE OY ANY NUMBEI~, ex ... 52/3 = 17.33. WOULD GE \iALUE b.
OM SAi COMPUTBa INSTITUTE
Set: 1
Microsoft Excel 2007
VALUE 2
J+2•V/\LUE 3 \/ALU[ 3 · ...... \it,LUB•VAlU£4 VAI.UE S/ ...... .
4 s 6
✓ VAlUI: l WILL DE ADD WITH VALUE 2 (20+10) = VALL1E 3 (30)
✓ VAt lJC J (30) WILL SUUSl'RACT UY ANY NUMBER, ex ... 30-4 = 26. WOULD B~ VALUE~-
✓ VALUC 4 (2<i) WILL OE MULl'IPY UY ANY NUMBER, ex ... 2GX2 :::52. WOULD GE VALUE 5.
✓ VALUI! S (52) WILL Ot: CIIVIDE OY ANY NUMBEI~, ex ... 52/3 = 17.33. WOULD GE \iALUE b.
I
100
100
SUraJ 100 78 58 45
' t
Seema 100 S6 78 S6
Rlghuma"i 100 90 89 34 89 90
Siksha 100 89 98 56 98 89 89 519
Reena 100 57 so'. 67 ,, so,' .:_ 57.:t
· · 57 ,:,, . ·w.:338 ·
.· .,:.,,,;)".:}~.;,~: ·, ~~t~: :':;-)('?-.
. ~,
Yaasir 100 47 49 78 49 47 47 319
THIS IS A SAMPL~ OF MARKSHEET
✓ MAKE Dlf-FERENT CELLS THAT INCLUDE NAME OF STUDENTS, MARKS OUT OFF, SUBJECTS, TOTAL
MARKS, PERGNT f,.. GHADE.
✓ Fill THE CELLS W!TH SPECIFIC VALUES.
✓ C'\LUtATE TOT.'~L MARKS BY USING FORMULA (=SUM ENGLISH: SANSKRIT).
✓ CALCULATE PERCFNT BY USING FORMULA (=TOTAL MARKS/TOTAL NUMBER OF SUBJECTS).
✓ APPLY GRADE V·i! rH SPECIFC MARKS OBTAIN BY THE STUDENTS.
QUE: 1
PREP.b.~f AN EXCEL SHEET fHAT CONTAINS FOLLOWING CALCUIATIONS
ADDiTION, SUBSTR/\CTION, MULTIPLICATION, DIVISION.
QU!:: 2
P~EPft.RE AN EXCEL SHEET OF ATLE/1.ST 20 CANDIDATES THAT CONTAINS FOLLOWING CALCULATIONS
AD;:"11TJON, '.iUESTRACTION, iv1ULT!PLIC/\liON, DIVISION.
PREPARE /\N LXCLL SHEET THAT CONTAINS MARKSHE.ET OF A PRTICULAR SCHOOL. IT INCLUDE 20
STUDENT & Li S'..13JECTS. CALCUL~Tc TOTAL f 1ARKS, PERCENTAGE AND GRADE.
CATEGORl['i /',HE AS :-OLLCV ✓S:
ROLL NO, NAME, PARENT'S f\i',l\Efvl, sue.JECTS, TOTAL M/\RKS, AVERAGE, PERCENTAGE, GRACE.
~~
~
~
-~
1
--~
J
. ~
100
100
SUraJ 100 78 58 45
' t
Seema 100 S6 78 S6
Rlghuma"i 100 90 89 34 89 90
Siksha 100 89 98 56 98 89 89 519
Reena 100 57 so'. 67 ,, so,' .:_ 57.:t
· · 57 ,:,, . ·w.:338 ·
.· .,:.,,,;)".:}~.;,~: ·, ~~t~: :':;-)('?-.
. ~,
Yaasir 100 47 49 78 49 47 47 319
THIS IS A SAMPL~ OF MARKSHEET
✓ MAKE Dlf-FERENT CELLS THAT INCLUDE NAME OF STUDENTS, MARKS OUT OFF, SUBJECTS, TOTAL
MARKS, PERGNT f,.. GHADE.
✓ Fill THE CELLS W!TH SPECIFIC VALUES.
✓ C'\LUtATE TOT.'~L MARKS BY USING FORMULA (=SUM ENGLISH: SANSKRIT).
✓ CALCULATE PERCFNT BY USING FORMULA (=TOTAL MARKS/TOTAL NUMBER OF SUBJECTS).
✓ APPLY GRADE V·i! rH SPECIFC MARKS OBTAIN BY THE STUDENTS.
QUE: 1
PREP.b.~f AN EXCEL SHEET fHAT CONTAINS FOLLOWING CALCUIATIONS
ADDiTION, SUBSTR/\CTION, MULTIPLICATION, DIVISION.
QU!:: 2
P~EPft.RE AN EXCEL SHEET OF ATLE/1.ST 20 CANDIDATES THAT CONTAINS FOLLOWING CALCULATIONS
AD;:"11TJON, '.iUESTRACTION, iv1ULT!PLIC/\liON, DIVISION.
PREPARE /\N LXCLL SHEET THAT CONTAINS MARKSHE.ET OF A PRTICULAR SCHOOL. IT INCLUDE 20
STUDENT & Li S'..13JECTS. CALCUL~Tc TOTAL f 1ARKS, PERCENTAGE AND GRADE.
CATEGORl['i /',HE AS :-OLLCV ✓S:
ROLL NO, NAME, PARENT'S f\i',l\Efvl, sue.JECTS, TOTAL M/\RKS, AVERAGE, PERCENTAGE, GRACE.
~~
~
~
-~
1
--~
J
. ~
Set: 3
Office Assistant 14000 , I 1
F-';::'.:"i-::::-~~~::.:_+::.:.:::::.::=~:._--L-~ ........ ---.---- ,----· . --.
8 ApameshSingh ~~~ --3-·
1
-ii6~~ .; ··-\-·--i·+ '.
· : 9 . :: Saumya Yadav- s.o. --. 18000 ---I ---r·· -
1
-• • • •
~=-1:-:o::t_R~~i:.:ya~_u:.:..:...P~a.:.:d~=h;.:,v~c1:.v._-~:R.::e~s:...p::.:t;io:.:.:n=ist --··- 17000 ~-~-t~·-·----~L __ -~--J- --·. . --. ~· . -
FORMAT OF SALARY SHEET
✓ !1,'\S!C SALARY;. ALLOWANCES RECIVED rROM COMPANY=GROSS SALARY.
✓ GROSS SALARY-INCOME TAX= NET SALARY.
✓ PUT A VALUE IN BASIC SALARY BLOCK.
✓ CALCULATE T.A 3.90%, D.A 1.50%, H.R.A7.00%, MEDICAL ALLOWANCE 4% ON BASIC SALARY.
✓ SUSTRACT INCO;v,E TAX 5% ON GROSS SALARY.
✓ FINALVALUEISNITSALARY.
QUE: 1
PREPARE AN EXCEL SHEEf FOR SALARYSHEET THAT CONTAINS NAME CF EMPLOYEE. DESIGNATION, 3ASIC
SAU\RY,
Allowances' .:re as follows:
TA ,= 4.9%
DA=S.7%
fiRA =11.6%
MEDICAL ALLOWANCE =2.6%
Tax & Deductions ar<:> :)S follows:
INCOME TAX= 2%
FUND= 1.3%
CALCULATE NET SALARY OF EACH EMPLOYEE.
d :lt:.J.:lfsTON#M#rrr· ~,,u,
Office Assistant 14000 , I 1
F-';::'.:"i-::::-~~~::.:_+::.:.:::::.::=~:._--L-~ ........ ---.---- ,----· . --.
8 ApameshSingh ~~~ --3-·
1
-ii6~~ .; ··-\-·--i·+ '.
· : 9 . :: Saumya Yadav- s.o. --. 18000 ---I ---r·· -
1
-• • • •
~=-1:-:o::t_R~~i:.:ya~_u:.:..:...P~a.:.:d~=h;.:,v~c1:.v._-~:R.::e~s:...p::.:t;io:.:.:n=ist --··- 17000 ~-~-t~·-·----~L __ -~--J- --·. . --. ~· . -
FORMAT OF SALARY SHEET
✓ !1,'\S!C SALARY;. ALLOWANCES RECIVED rROM COMPANY=GROSS SALARY.
✓ GROSS SALARY-INCOME TAX= NET SALARY.
✓ PUT A VALUE IN BASIC SALARY BLOCK.
✓ CALCULATE T.A 3.90%, D.A 1.50%, H.R.A7.00%, MEDICAL ALLOWANCE 4% ON BASIC SALARY.
✓ SUSTRACT INCO;v,E TAX 5% ON GROSS SALARY.
✓ FINALVALUEISNITSALARY.
QUE: 1
PREPARE AN EXCEL SHEEf FOR SALARYSHEET THAT CONTAINS NAME CF EMPLOYEE. DESIGNATION, 3ASIC
SAU\RY,
Allowances' .:re as follows:
TA ,= 4.9%
DA=S.7%
fiRA =11.6%
MEDICAL ALLOWANCE =2.6%
Tax & Deductions ar<:> :)S follows:
INCOME TAX= 2%
FUND= 1.3%
CALCULATE NET SALARY OF EACH EMPLOYEE.
d :lt:.J.:lfsTON#M#rrr· ~,,u,
A\aJ • "'
~~•re1s~llowm•
-~ETAX•4"
FUND•~
CAl.CUlATt NET SAlARY OF EACH EMPLOYEE.
QUE:3
PREPARE AN EXCEL SHEET FOR SALARYSHEET THAT CONTAINS NAME OF EMPlO'IEE, DESIGMA1\0M#
SALARY . , . , . . .. . . - •
Allowances' are as follows:-
TA = 4.5%~
CA= 2.7%
. -) .
HRA =9.6%
. . '
MEDICAL ALLOWANCE:. =2.6% ..
Tax & Deductions 3re as fotlows:
INCCME TAX:.: n-f. ·
FUND::: 1.9%
CALCULATE NET SALARY OF EACH EMPLOYEE.
~~•re1s~llowm•
-~ETAX•4"
FUND•~
CAl.CUlATt NET SAlARY OF EACH EMPLOYEE.
QUE:3
PREPARE AN EXCEL SHEET FOR SALARYSHEET THAT CONTAINS NAME OF EMPlO'IEE, DESIGMA1\0M#
SALARY . , . , . . .. . . - •
Allowances' are as follows:-
TA = 4.5%~
CA= 2.7%
. -) .
HRA =9.6%
. . '
MEDICAL ALLOWANCE:. =2.6% ..
Tax & Deductions 3re as fotlows:
INCCME TAX:.: n-f. ·
FUND::: 1.9%
CALCULATE NET SALARY OF EACH EMPLOYEE.
llla>•a11t 0e11s Rules •
a 1£ A __ 8 __
___ I __ C _;_ D __ L E F • u ~
(
1 Nameofthestudent
Marks out off Engllsh Hindi S.St Math's Sci!~_-.k~~J~t~~n-~~~2~-
:,•~-a~-
z ;Amar
100 79 67 47 67 79 r· .t13 f~i f,; :
_____________
....;;;;.;;.;;. _ _;;.;_ __ _,,__. _____ ,,.__ .--...... ,~.,,,-·.-___ ,,,.. ___,... .. ____ . .,_ ... ...._. ...
J .-Deepalc
100 39 78 67 78 3'= 3S~;r ;;:: ~t:.S7 0.
-------r,~ ... R,o•-•-•;-------· ----· ----__ ...,.
" :s.uaJ
100 7E 58 45 58 7~ 73 i. ' 31)5 ~~ S~ C
----·--------·~--~= -• -----il'.:W: ·. -.~ .. -------· .. -·•-, ___,
5 /Seema
100 56 78 55 78 56 ::), , ;· ~~J 63 3J (
__, _______________
;;;;,;.;.;~_,.-;..;,_,...~Aoll.""'''
··•,v•.-_,;a,.,,•,--------..,_ ~w ,-·~•.,.•,}lf--•---• ---•~ ~;: ___ ...,,.. _ _.._
6 ;Raghumani
100 90 89 3! 89 9C ~\J :.: r ··lt: : ~~ ~
, ·
--·---
---------·
..... -~--"'"•
'·•···,.,,_- , ,
,,W-'<.•-l.·>:" .......... T'-•~---
' ,. :-, •.: -.... __ .,,
1 ;Siksha
100 89 98 ~( · JB 8S 8:l:,:· . . .. ..;.:--
£ ·Reena
· 9; Yaasir
10,
------'#;: ... ,•-----~--r,,,,.,,; .. i. .......... ··•·•~-~-,y ._,_.....
.. ~---'"'....._ ............... -, •• _
..... --... • .
..... . -~-
a 1£ A __ 8 __
___ I __ C _;_ D __ L E F • u ~
(
1 Nameofthestudent
Marks out off Engllsh Hindi S.St Math's Sci!~_-.k~~J~t~~n-~~~2~-
:,•~-a~-
z ;Amar
100 79 67 47 67 79 r· .t13 f~i f,; :
_____________
....;;;;.;;.;;. _ _;;.;_ __ _,,__. _____ ,,.__ .--...... ,~.,,,-·.-___ ,,,.. ___,... .. ____ . .,_ ... ...._. ...
J .-Deepalc
100 39 78 67 78 3'= 3S~;r ;;:: ~t:.S7 0.
-------r,~ ... R,o•-•-•;-------· ----· ----__ ...,.
" :s.uaJ
100 7E 58 45 58 7~ 73 i. ' 31)5 ~~ S~ C
----·--------·~--~= -• -----il'.:W: ·. -.~ .. -------· .. -·•-, ___,
5 /Seema
100 56 78 55 78 56 ::), , ;· ~~J 63 3J (
__, _______________
;;;;,;.;.;~_,.-;..;,_,...~Aoll.""'''
··•,v•.-_,;a,.,,•,--------..,_ ~w ,-·~•.,.•,}lf--•---• ---•~ ~;: ___ ...,,.. _ _.._
6 ;Raghumani
100 90 89 3! 89 9C ~\J :.: r ··lt: : ~~ ~
, ·
--·---
---------·
..... -~--"'"•
'·•···,.,,_- , ,
,,W-'<.•-l.·>:" .......... T'-•~---
' ,. :-, •.: -.... __ .,,
1 ;Siksha
100 89 98 ~( · JB 8S 8:l:,:· . . .. ..;.:--
£ ·Reena
· 9; Yaasir
10,
------'#;: ... ,•-----~--r,,,,.,,; .. i. .......... ··•·•~-~-,y ._,_.....
.. ~---'"'....._ ............... -, •• _
..... --... • .
..... . -~-
}
t
;
I
~
t
l
r
,CaleU1at9 Temp_,.__ Set: 5
Ullft9 COIOf acaa. Concllllonal fonr ... 4 .
1
2
.l
5
c;
s
~
10
11
1
3
5
r,
..,
I
s
9
11
;.
An-h"'"'""'
Bo~tnr,
C!1ka~~
:'oJ?.:W York Cit-;
.:'-?'1\'1:?'
'.)all~s
Phr_,<en,x
r.1;a!T,:
Syrir;.:c\'
Auckland
.\11(11 01?.gt-
Briston
Ch;,:a~(J
··ie·,
1
: •for~ t :t·;
i),;·,ver
Dall:,s
PhCl-:'11'),
Mi,..;1i
Sytl:1cy
~t.:•: ~ :.1nd
J,;n
--·
36
:,.:
~~-
.:is
=jl
67
-r
,-
"'-1
C
J?.n
~?
;_._,
31:.
• l .,,.
:;·:1
, -
... ;)
~..,
-·.
C7
7;:i
"7':
·-'
74
F"?h Mar
27 3-1
30 ..i~
:o 45
-12 ~-0
:16 34
Gi F,·~
71
--,
I /
73 ~C;
7?. 72
,o 68
r-et, M,ir
27 :-!~
~I~ 4c::
31) -16
j~ ':/•
.!6 :.-l
(, l
... v
71 :7
78 ,30
..,.
I:> 72
:-c G8
F
Apr
.14
56
59
60
61
77
85
83
66
63
Custom Fonnat Trick
••• ,,,
G H
. A~~rae~ Hleh Temper~t~;~ lF(;~'.\I;;TI;g~.:J ... ..;'~~--11,,o'lil,;;
May IUll Jul Aug Sep : . oct :,,:·Now'~:'.:··.,_.::'¥
56 63 65
66 iS 81
70 81 84
71 79 85
72 82 90
84 91 95
9C 95 93
87 89 91
61
~s 4.:i
57 49 .14
64 i8 2S 5S 4C
80
82
83
88
%
92
91
57
49
72
75
76
"70 ,_
89
91
89
61
55
61 S1 41
63 48 36
65 54 44
66 S2 4S
80 6S S8
89 76 66
86 s2 n
64 70 74
59 62 64
---:-:~ ~. "YW.:.•~ '!:··. r:--.•.;~~~ .. \~:!~
V·lh1c~ city is the hottESt & who:~·!s it_the'hottest? .· ·.; _ ~----:. · · . ._::., :.'\~t
:. ,... ".;;, . .,•·. ,;· - ,, '.; .c~{..'_ ';..-.,,;_ ./ -i:. ,: : ~ .
G H
Apr
44
56
59 70 81
60 71 79
cil , .. 82
77 84 91
85 90
. .
95
83 87 89
66 61 55
63
57 49
~.t- •~~~~ -'!'..~~ •-•.:►.:~ .. ~~1,~}r,f.~·'~,.~A~• .. _@ . iA.6#. ~ . ...-, ___ #.£.£ _ .k._ .. [email protected] .. tt. Q_.z -□-LS!L Lil
.. ·---· -----------OM
Si\i COMPUTER 1r.STITUTE, Sindhora l3asantpur road, Varanasi, Phone: 9140699612
t
;
I
~
t
l
r
,CaleU1at9 Temp_,.__ Set: 5
Ullft9 COIOf acaa. Concllllonal fonr ... 4 .
1
2
.l
5
c;
s
~
10
11
1
3
5
r,
..,
I
s
9
11
;.
An-h"'"'""'
Bo~tnr,
C!1ka~~
:'oJ?.:W York Cit-;
.:'-?'1\'1:?'
'.)all~s
Phr_,<en,x
r.1;a!T,:
Syrir;.:c\'
Auckland
.\11(11 01?.gt-
Briston
Ch;,:a~(J
··ie·,
1
: •for~ t :t·;
i),;·,ver
Dall:,s
PhCl-:'11'),
Mi,..;1i
Sytl:1cy
~t.:•: ~ :.1nd
J,;n
--·
36
:,.:
~~-
.:is
=jl
67
-r
,-
"'-1
C
J?.n
~?
;_._,
31:.
• l .,,.
:;·:1
, -
... ;)
~..,
-·.
C7
7;:i
"7':
·-'
74
F"?h Mar
27 3-1
30 ..i~
:o 45
-12 ~-0
:16 34
Gi F,·~
71
--,
I /
73 ~C;
7?. 72
,o 68
r-et, M,ir
27 :-!~
~I~ 4c::
31) -16
j~ ':/•
.!6 :.-l
(, l
... v
71 :7
78 ,30
..,.
I:> 72
:-c G8
F
Apr
.14
56
59
60
61
77
85
83
66
63
Custom Fonnat Trick
••• ,,,
G H
. A~~rae~ Hleh Temper~t~;~ lF(;~'.\I;;TI;g~.:J ... ..;'~~--11,,o'lil,;;
May IUll Jul Aug Sep : . oct :,,:·Now'~:'.:··.,_.::'¥
56 63 65
66 iS 81
70 81 84
71 79 85
72 82 90
84 91 95
9C 95 93
87 89 91
61
~s 4.:i
57 49 .14
64 i8 2S 5S 4C
80
82
83
88
%
92
91
57
49
72
75
76
"70 ,_
89
91
89
61
55
61 S1 41
63 48 36
65 54 44
66 S2 4S
80 6S S8
89 76 66
86 s2 n
64 70 74
59 62 64
---:-:~ ~. "YW.:.•~ '!:··. r:--.•.;~~~ .. \~:!~
V·lh1c~ city is the hottESt & who:~·!s it_the'hottest? .· ·.; _ ~----:. · · . ._::., :.'\~t
:. ,... ".;;, . .,•·. ,;· - ,, '.; .c~{..'_ ';..-.,,;_ ./ -i:. ,: : ~ .
G H
Apr
44
56
59 70 81
60 71 79
cil , .. 82
77 84 91
85 90
. .
95
83 87 89
66 61 55
63
57 49
~.t- •~~~~ -'!'..~~ •-•.:►.:~ .. ~~1,~}r,f.~·'~,.~A~• .. _@ . iA.6#. ~ . ...-, ___ #.£.£ _ .k._ .. [email protected] .. tt. Q_.z -□-LS!L Lil
.. ·---· -----------OM
Si\i COMPUTER 1r.STITUTE, Sindhora l3asantpur road, Varanasi, Phone: 9140699612
------
Cynas..t.. I
'Ila taer
~; ~w i
----~; ~~;Jpl1
~
~ QUE:1
~ SHORT AN MARKSHEET WITH ALPHABATICAL ORDER A to Z & Z to A.
~ QUE:2
~ SHORT AN SALARYSHEET WITH ALPHABAT\CAL ORDER A to Z & Z to A.
~ QUE:3
~
FILTP~ J',.N MARKSHEF.T.
~
~I QUE:4
~, FILTER AN SALARYSHEET.
lS);
~'
~
~
~'
~
t.Si·
Cynas..t.. I
'Ila taer
~; ~w i
----~; ~~;Jpl1
~
~ QUE:1
~ SHORT AN MARKSHEET WITH ALPHABATICAL ORDER A to Z & Z to A.
~ QUE:2
~ SHORT AN SALARYSHEET WITH ALPHABAT\CAL ORDER A to Z & Z to A.
~ QUE:3
~
FILTP~ J',.N MARKSHEF.T.
~
~I QUE:4
~, FILTER AN SALARYSHEET.
lS);
~'
~
~
~'
~
t.Si·
: r ·, i
!:It,,...
·-~ .... __ _
3-t' Cc.lun,r.
. ·s.No--·--,,i~~--; Of
: Employel! ·
---·---..
1-
-·-·-·--
·--. --
2,
3
4
5
6'
7
8
9·
10
11
12 ·
13
14
15.
i'
Basic salary ··iA·-·r-o.A--r-Hi.A_r_ M.A Gross
Tax
Net
salary
salary
2.00%
·•.
·· ... :-·~·-.
16000
·· 4:9ai .... t ""s":10% ·-·\11.60%-~---l.---.i.-----+----t
·-•-· ··------~---_1 _____ ~6_0_%_j, ____ ~----1---1
, ______ ___ .... ____ L __________ ,..i ___ .L-----l-----+---i
. __ ?.~~----t---~-~~ __ _l_ _ __:~~-: 416 l 19953 . 399
19s69
i:~~ci--. ·• ::;_ -~~~: -- --~~~:-- :~:~~~:: :~:
22015
23238
_ ~~~ __ , ·:..~-~40 · ·· :2~:io~J~~~~20 1 24960 _4_99_--+i-•
;._:l4_6_1-t
20000
24000
14000
lSG'JO
~~-roo
23000
25000
18000
19000
22000
23000
7.5000
1~7-~---~--B68 j _ 2_?.~~---L __ 6:~_L~~~2 599 2935~
'--
686 798 162~_ I _ _36_~--\---~~1y2 L-~~ _ 11123
735
ss5 1140 : 390 , 1s120
I 374 18346
- .. --. •·-__ : ______ ·---! _______ __._ _________
-I
1029 1197 2436 J .. _ 546___ _ 26208 524 25684
1127 1311 2668 598 28704 574
. 28130
1225 . 1425
..
1
.
29-QQ -- 650 31200 ·1 624 30576
.. 8.82--. 1026 : ··2088-- ·1··· 468 22464·-;--
__ -_. 449 .... 22015~.
. -~: 9~~---·:_\_·-l~~j-. ··2·204·-·r···494-··-~2. 474 ~§.
1078 ! 1254 • 2552 I 572 l 27455 549 26907 ·
-·,-·---·-·-+· .. -·-
1311 2668 .
..... s.~~---·---2s10~-4----·--57A 2s130
1225 : 1425 2900 , 650 31200
i 624 -30576,,
-··--·-· .•...•. J. -··· ··-·_._ _________ ,_...._ _____ -..L. __ ....
11.27
1C.'!-~P.·~~ . .s:a..'f~~~.,.:1-~tt~•., .. l~~:--t•~.~~~ .. _.1_t.t' .~?!'r',;I'~~~
'!'!'!''•.~ ----·-••*--•··· .. ______ . ___ _ ····-. _____ •····-···---·--
!!'!~ ··--· -~ .. ·or-1 SAI COMPUTER fN~".'flTU1T Sindhora Basantpur road, Varanasi, Phone:
9140699612
!:It,,...
·-~ .... __ _
3-t' Cc.lun,r.
. ·s.No--·--,,i~~--; Of
: Employel! ·
---·---..
1-
-·-·-·--
·--. --
2,
3
4
5
6'
7
8
9·
10
11
12 ·
13
14
15.
i'
Basic salary ··iA·-·r-o.A--r-Hi.A_r_ M.A Gross
Tax
Net
salary
salary
2.00%
·•.
·· ... :-·~·-.
16000
·· 4:9ai .... t ""s":10% ·-·\11.60%-~---l.---.i.-----+----t
·-•-· ··------~---_1 _____ ~6_0_%_j, ____ ~----1---1
, ______ ___ .... ____ L __________ ,..i ___ .L-----l-----+---i
. __ ?.~~----t---~-~~ __ _l_ _ __:~~-: 416 l 19953 . 399
19s69
i:~~ci--. ·• ::;_ -~~~: -- --~~~:-- :~:~~~:: :~:
22015
23238
_ ~~~ __ , ·:..~-~40 · ·· :2~:io~J~~~~20 1 24960 _4_99_--+i-•
;._:l4_6_1-t
20000
24000
14000
lSG'JO
~~-roo
23000
25000
18000
19000
22000
23000
7.5000
1~7-~---~--B68 j _ 2_?.~~---L __ 6:~_L~~~2 599 2935~
'--
686 798 162~_ I _ _36_~--\---~~1y2 L-~~ _ 11123
735
ss5 1140 : 390 , 1s120
I 374 18346
- .. --. •·-__ : ______ ·---! _______ __._ _________
-I
1029 1197 2436 J .. _ 546___ _ 26208 524 25684
1127 1311 2668 598 28704 574
. 28130
1225 . 1425
..
1
.
29-QQ -- 650 31200 ·1 624 30576
.. 8.82--. 1026 : ··2088-- ·1··· 468 22464·-;--
__ -_. 449 .... 22015~.
. -~: 9~~---·:_\_·-l~~j-. ··2·204·-·r···494-··-~2. 474 ~§.
1078 ! 1254 • 2552 I 572 l 27455 549 26907 ·
-·,-·---·-·-+· .. -·-
1311 2668 .
..... s.~~---·---2s10~-4----·--57A 2s130
1225 : 1425 2900 , 650 31200
i 624 -30576,,
-··--·-· .•...•. J. -··· ··-·_._ _________ ,_...._ _____ -..L. __ ....
11.27
1C.'!-~P.·~~ . .s:a..'f~~~.,.:1-~tt~•., .. l~~:--t•~.~~~ .. _.1_t.t' .~?!'r',;I'~~~
'!'!'!''•.~ ----·-••*--•··· .. ______ . ___ _ ····-. _____ •····-···---·--
!!'!~ ··--· -~ .. ·or-1 SAI COMPUTER fN~".'flTU1T Sindhora Basantpur road, Varanasi, Phone:
9140699612
OM SAi COMPUTER INmTUTE
l
3StXXI
-
--·----·-...
25a
2cm,
Im
i
1m,
I
m
I
1 0 :
l ! I
1 I
j
I
I
I
..,
Que:1
Convert An Mark ::iheet in Column Chart.
Que:2
Convert An Salary sheet in Pie Chan.
l
3StXXI
-
--·----·-...
25a
2cm,
Im
i
1m,
I
m
I
1 0 :
l ! I
1 I
j
I
I
I
..,
Que:1
Convert An Mark ::iheet in Column Chart.
Que:2
Convert An Salary sheet in Pie Chan.
l~llOO
1-,.00
16.'l.lXI
16~.oo
.......
. '
.-Si.ti~
1s:1.~4
2:3~.~2
..
, . =~3~.:2
-
-
--·-..:, .
: .. 16~0.00
: .
.- A
161Jf
1n
:0666 ... 6
Format of this spreacf Sheet:
-Profit & Loss= Incorr:c-Expenci:turc
Profit
& Loss %'"' J;1comc/Expt~nditure-l
U90.~S ]61.45 · wr,
B69.00 ,u.oo.
, 30',
401."4
.
lS'-1
Ul0.00
. .
1611.81 622.01 39~·-
15~7.6) ~ 959.59
_, . -61~:,
U23.98 22 6.02
i 16~,
1~98.12 ·,..:,2us • I 2''•
i .
177~1.9~ 292t52
.•
I 16'~
>-
Annual Tm::il Profit & Loss% =TotDi Income/ Tot~l Expenditure-1
Qne: 1
Convert this table i11t(1 Chart
l: Column Chart,
2: Pie Chart
. -. --
:
...
~ ··-----
• . . -
. ...
·~
' ...
~ ..
-
[ l
1-,.00
16.'l.lXI
16~.oo
.......
. '
.-Si.ti~
1s:1.~4
2:3~.~2
..
, . =~3~.:2
-
-
--·-..:, .
: .. 16~0.00
: .
.- A
161Jf
1n
:0666 ... 6
Format of this spreacf Sheet:
-Profit & Loss= Incorr:c-Expenci:turc
Profit
& Loss %'"' J;1comc/Expt~nditure-l
U90.~S ]61.45 · wr,
B69.00 ,u.oo.
, 30',
401."4
.
lS'-1
Ul0.00
. .
1611.81 622.01 39~·-
15~7.6) ~ 959.59
_, . -61~:,
U23.98 22 6.02
i 16~,
1~98.12 ·,..:,2us • I 2''•
i .
177~1.9~ 292t52
.•
I 16'~
>-
Annual Tm::il Profit & Loss% =TotDi Income/ Tot~l Expenditure-1
Qne: 1
Convert this table i11t(1 Chart
l: Column Chart,
2: Pie Chart
. -. --
:
...
~ ··-----
• . . -
. ...
·~
' ...
~ ..
-
[ l
OMSAI
Set: 9
Fizzy Drink Survey
I _ _J ._. J. ___ l ... •·•
r
r Que 1:
Convert this chart in Spreadsheet.
Quc2:
· Convert this chart into Column chart
•hpsa
l(.o,:a.:,~
~ ~.;:,•.;r.J.&Ul .. 1.. <f
~1r.a
, Gln.J!t !. ~'!I'
l«~ 1.....-:,::ia:le
Set: 9
Fizzy Drink Survey
I _ _J ._. J. ___ l ... •·•
r
r Que 1:
Convert this chart in Spreadsheet.
Quc2:
· Convert this chart into Column chart
•hpsa
l(.o,:a.:,~
~ ~.;:,•.;r.J.&Ul .. 1.. <f
~1r.a
, Gln.J!t !. ~'!I'
l«~ 1.....-:,::ia:le
Set: 10
Warranty Malnteaaace
C 0
10/2/2021! ,
I
--·· .... ··--· .... -·-·--·· ----.. ---------------,
~--~=-_' -~==-~~~--.-::_'-;_ :.~=-·-_--:-:~~~~G;:~--~,1-s-=_,;-• .. _:-=_~---_-v_v-a-,.,.-:;,-1,,-; ,-r, -M·0-,-1t-!·s---E-xp-ir-·; ·o-.~-t\:'----.----St-~t-i.1-s --=-_)--,
=ED! TE(DatE: c,f sale,Warra:Hy in Months}
3 StZ:tLi~
= r. t~,,,-,-'._iO.-Wt/, 'ii: W2rrantv",.'Exr)iled"i =IF(Expiry Date>=TOl)AV'.)_":,, ,Y:~~,~,,t-v'',''Explred•l
4 Curr,~rt One St,,;l .. : -·.', -_ >:1.!P!SES5.5BSl:%SlS.:C.1Li__!i'v:NS!SB$3:C3).C: :VlOOl<VPllD.All i:ENGE,COLUMNSl$8$3:0),0
. . -... . ···---·-------- ---·-----·-----•--....
Warranty Malnteaaace
C 0
10/2/2021! ,
I
--·· .... ··--· .... -·-·--·· ----.. ---------------,
~--~=-_' -~==-~~~--.-::_'-;_ :.~=-·-_--:-:~~~~G;:~--~,1-s-=_,;-• .. _:-=_~---_-v_v-a-,.,.-:;,-1,,-; ,-r, -M·0-,-1t-!·s---E-xp-ir-·; ·o-.~-t\:'----.----St-~t-i.1-s --=-_)--,
=ED! TE(DatE: c,f sale,Warra:Hy in Months}
3 StZ:tLi~
= r. t~,,,-,-'._iO.-Wt/, 'ii: W2rrantv",.'Exr)iled"i =IF(Expiry Date>=TOl)AV'.)_":,, ,Y:~~,~,,t-v'',''Explred•l
4 Curr,~rt One St,,;l .. : -·.', -_ >:1.!P!SES5.5BSl:%SlS.:C.1Li__!i'v:NS!SB$3:C3).C: :VlOOl<VPllD.All i:ENGE,COLUMNSl$8$3:0),0
. . -... . ···---·-------- ---·-----·-----•--....
1$
Is
5.
rs
0
-
OM SAi COMPUTER INSTITUTE_
•• n rw m .,.
-~ /2
1 3
ll/2512020 ICEYOOARD 45
w..~ 1m tt00=---+-4-11
t : 4 r.,. 712020 PENDRIVt 32 GB 10
I 13 llo'.2612020 NOIINTOR S
II 14 l1l29l2020 4GB RAN 10
~ _s ---+-111»'20.20 MOHIEll BOARD 20
12 j
13--;,----+-----f------l
M:
"5 ;
4t·---+---+------,1---J
For Purchases Stocks
Set: 10
Stock Maintenance
G H
1 1V24IZ020 COMPUTER 24Pos
2 1V25/2020 KEYBOAOD 14~cs
'.l 1V26l2020 11B HUD 21rc,
4 1W27l2020 P[NDRIVE 32 Gil 12Pc,
5 1V28/2020 MONITUR IJPcs
6 11/ZSl~O 4GDRAM 2Pes:
MOl IIER BOARD 10Pcs
,.,.
C:Clf'IPUl ti I 25 24
KEYBUArtD I 4~ 1,--.---=-31---1
lTBIILJO--t--,1--+---<!l ----20::--~
P[NlJHIYE 32 G6 1 10 _1._. __ 12_~---,•2=-----1
MONITOR --r---~--1 ~ .... • __ -s __
4GGilAH ~ 10 : 8
MU r11i.::1 uiJ.A11u j 211 -i--· ;,1 · : lU
--------,---- 1..-----.------<
..-Et.UHi\;( 6'I Gil 1 0 U · 0 __)
a,-::a HA~ 11 t O , U
z m HOO · ,; -I o --;-· --"---,I
LAPTO~--__ i O r:=y--=-~~-C _J
=SUTVIIF($C$5·$C$18,KS,$D$5:$D$18) =SUMIF(Select all Purchase item ,Select Item C.-i:,?ria , Select all ?ur. Qty ;,a:1ge
for Safes Stor.!{s
=SUMIF($r1$5:$li$19, KS,$1$5:$1$19) "'SUMIF(Selert all Sales Item ,Select It em Criter;j, S~lect a,1 :5,,:es Qtv Ran~c
Closing Stocks
=LS-MS =Purchase-Sales
~-ffflftt P21!1!r~ ·:._~~..!!!..!.!.£.Jgt~~!~''~'•~l-.' .'!"_t~.-~~~~.:~i•.l> ·-•• ... • .. ~· .. ".;•, ~· •~ '·.:.•"~.~: ·:-..,, r. ·~~--~_,:• ~~:,~·-"';•.,1-::"!".:·":: ~, . .,
. OM SAi COMP _'.'ffR INSTITUTE, Sindhora H asar.l t,ur :-oad, Var.::r,a:)1, p~,,1:ie: en 40(,1Y)•: 12.
Is
5.
rs
0
-
OM SAi COMPUTER INSTITUTE_
•• n rw m .,.
-~ /2
1 3
ll/2512020 ICEYOOARD 45
w..~ 1m tt00=---+-4-11
t : 4 r.,. 712020 PENDRIVt 32 GB 10
I 13 llo'.2612020 NOIINTOR S
II 14 l1l29l2020 4GB RAN 10
~ _s ---+-111»'20.20 MOHIEll BOARD 20
12 j
13--;,----+-----f------l
M:
"5 ;
4t·---+---+------,1---J
For Purchases Stocks
Set: 10
Stock Maintenance
G H
1 1V24IZ020 COMPUTER 24Pos
2 1V25/2020 KEYBOAOD 14~cs
'.l 1V26l2020 11B HUD 21rc,
4 1W27l2020 P[NDRIVE 32 Gil 12Pc,
5 1V28/2020 MONITUR IJPcs
6 11/ZSl~O 4GDRAM 2Pes:
MOl IIER BOARD 10Pcs
,.,.
C:Clf'IPUl ti I 25 24
KEYBUArtD I 4~ 1,--.---=-31---1
lTBIILJO--t--,1--+---<!l ----20::--~
P[NlJHIYE 32 G6 1 10 _1._. __ 12_~---,•2=-----1
MONITOR --r---~--1 ~ .... • __ -s __
4GGilAH ~ 10 : 8
MU r11i.::1 uiJ.A11u j 211 -i--· ;,1 · : lU
--------,---- 1..-----.------<
..-Et.UHi\;( 6'I Gil 1 0 U · 0 __)
a,-::a HA~ 11 t O , U
z m HOO · ,; -I o --;-· --"---,I
LAPTO~--__ i O r:=y--=-~~-C _J
=SUTVIIF($C$5·$C$18,KS,$D$5:$D$18) =SUMIF(Select all Purchase item ,Select Item C.-i:,?ria , Select all ?ur. Qty ;,a:1ge
for Safes Stor.!{s
=SUMIF($r1$5:$li$19, KS,$1$5:$1$19) "'SUMIF(Selert all Sales Item ,Select It em Criter;j, S~lect a,1 :5,,:es Qtv Ran~c
Closing Stocks
=LS-MS =Purchase-Sales
~-ffflftt P21!1!r~ ·:._~~..!!!..!.!.£.Jgt~~!~''~'•~l-.' .'!"_t~.-~~~~.:~i•.l> ·-•• ... • .. ~· .. ".;•, ~· •~ '·.:.•"~.~: ·:-..,, r. ·~~--~_,:• ~~:,~·-"';•.,1-::"!".:·":: ~, . .,
. OM SAi COMP _'.'ffR INSTITUTE, Sindhora H asar.l t,ur :-oad, Var.::r,a:)1, p~,,1:ie: en 40(,1Y)•: 12.
---
·• ~--=:.:...-~:..--:.:::_ --~-...
Vl!<ASH PAL
: fATIF:MJR
Phone:
[moil.
~87.,545675
THAl'II( ':!AJ FC·R GUSSll·IESS Will·'. \JS
1
0'. •f'•l,)''l•Cc6!)
.... , .... -~. -( ., ,.,,:. l .. , ..... __ , .. ., .... -
. I
Due Date:
123
10/2/21121
10/2/21121
Invoice 0?.tl!:
Account No;
llrcount Namt>:
Br;ince Name:
2.499. 00
9.9q<_l,OO
00-0865,-8975
Allahabaad Bank
Sindhora 3c1zar
I
·:-:_,: -~~:, ··::7'''.~lI:!F.T~~,~~
15 . -. 2% at 36.7~5.JO
,, .,, , ,,. .• ,.... I · _
I
I
I
I
I
I
------··
--~----27-1-,7-1-1-.8--0-1
subtoto!
I
CGST( Q•(.): ~ 2'1.454. (16 I
SGS-~lS%). ~ , .. -.2~,454~~
Totol . ·' :'::'.~, :: 31.0 619 9 l
.. " :. cii , . .;.: .: · ~ !i
Yo•Jr Mame ,s., Signature
·• ~--=:.:...-~:..--:.:::_ --~-...
Vl!<ASH PAL
: fATIF:MJR
Phone:
[moil.
~87.,545675
THAl'II( ':!AJ FC·R GUSSll·IESS Will·'. \JS
1
0'. •f'•l,)''l•Cc6!)
.... , .... -~. -( ., ,.,,:. l .. , ..... __ , .. ., .... -
. I
Due Date:
123
10/2/21121
10/2/21121
Invoice 0?.tl!:
Account No;
llrcount Namt>:
Br;ince Name:
2.499. 00
9.9q<_l,OO
00-0865,-8975
Allahabaad Bank
Sindhora 3c1zar
I
·:-:_,: -~~:, ··::7'''.~lI:!F.T~~,~~
15 . -. 2% at 36.7~5.JO
,, .,, , ,,. .• ,.... I · _
I
I
I
I
I
I
------··
--~----27-1-,7-1-1-.8--0-1
subtoto!
I
CGST( Q•(.): ~ 2'1.454. (16 I
SGS-~lS%). ~ , .. -.2~,454~~
Totol . ·' :'::'.~, :: 31.0 619 9 l
.. " :. cii , . .;.: .: · ~ !i
Yo•Jr Mame ,s., Signature
Set: 12
. Over Time Calculadon
;. ·. ,,. . •· . ,
. , I .. , . "
·:. · -------. -· --l ......... ~: . .. •, , . o _ _ "
~ ..
. ].
.!..
~-12/19/2020 A~Btt~iiiMillilWi~:pl:~~~~~~.:...j~.:.i.!;:.:,;._~_,:.~~~~~
S 12/19/2020 RAJAT
' ~6 l2/1S/202,;otv::::,s::H7Al:------+-.::..:_~.:_-----i._:.:=.:.::.:..i-_:_...:......~i-----::-t---:~;t-; -::;~
7l-;:;12;;;,,;;;9/;:;2:;::02=o±s:-:A-:-N-JA--Y---i.===--l..._:_:_=-=-:.--i. ___ +---"-"'.'+---:-:-:±:-;-:~;;1
ASSli/\NT 10:00 /\M
MANACt;M IJ:OOl'M
6:CO Pl.~ a ~ •!~ t 4C~.00
..
GH~• .
~c.c.o
8:00 :· ·.~ C t
CONTR/\ClOM lC.00 l'M 9:0C /,M
p ';H-1 ..
~ =~.OC
12/19/2020 AKASH
S,\~lS MANAOUl 9:J0 /\M 3:0C PM 0 ·~ -!~ t :cc.oi:
.•. 9 . 12/19/2020 V1,<AS
S/,Ll:S M/\:-lllC"•!,'R 11:C:1 l'M 8:0C /1\1 :1 'i-H 't 4SCa:;
Ml\!-~Gt.K S CG t-iv1 10:CC ~. '
1 -
I• ; -
.1-: ! 5 ~:;o.CC)
J\SSi l i\j,j 1 ':.l:OC;.\•I
M,'\N;\Gl:K 9:3C ;.J..:
COt-l'IRACT OR 11::.~ ~r'J~
SALES tvlAIII/\Gti{ 9:(,C -.~.!
S,\Lt.S MANA GER -. r. . "I
!.!.,:~~·~·-
-Creat-, a format A!>ov-,
1.
-,_
3.
TOTAL TIME
=IF(E,1>D4,E4-D4,E4+ 1-
D4)*2"1
OVERTIME =IF(F.;>$F$2,F4-SF$2,0)
SALARY =50*(4
/
=IF(TIME OUT>TIME IN.~-!i\1t: e,;_, ;-·i-!l-.-'.[ :~1,m.,~E
OUT+l· TIME IN)"'24 .
=IF(TOTAL TIME>'v'/ORKI:% "i :.1r:.,1·crAt TIME·
WORKING TIME,0)
=TOTAL TIME* SC, Rs.
tt n · r - rue~
1
1ns :n•·t~~-"9!1.i~;~!~~-'J~'..f: ~~~ ·•~~~~~:~~J~~~~-J.l'!.~-~• ,..~~::1:-:•.·-~~----~·-.. ·· Lli ..:-_-...:.:-,•_,~.:.•· -.._~-n~ , ~1.~"!K.~· -:i~~~'v;-;,; ~-.. ~~f.!~\~ -;r~:-._,_:
1
•
OM SAi COMPUTER INSTJTUTE, Sindhora B asantpur road, Varana!.i, Pl:,.,,1e: 914-;h,'J96 t::!
. Over Time Calculadon
;. ·. ,,. . •· . ,
. , I .. , . "
·:. · -------. -· --l ......... ~: . .. •, , . o _ _ "
~ ..
. ].
.!..
~-12/19/2020 A~Btt~iiiMillilWi~:pl:~~~~~~.:...j~.:.i.!;:.:,;._~_,:.~~~~~
S 12/19/2020 RAJAT
' ~6 l2/1S/202,;otv::::,s::H7Al:------+-.::..:_~.:_-----i._:.:=.:.::.:..i-_:_...:......~i-----::-t---:~;t-; -::;~
7l-;:;12;;;,,;;;9/;:;2:;::02=o±s:-:A-:-N-JA--Y---i.===--l..._:_:_=-=-:.--i. ___ +---"-"'.'+---:-:-:±:-;-:~;;1
ASSli/\NT 10:00 /\M
MANACt;M IJ:OOl'M
6:CO Pl.~ a ~ •!~ t 4C~.00
..
GH~• .
~c.c.o
8:00 :· ·.~ C t
CONTR/\ClOM lC.00 l'M 9:0C /,M
p ';H-1 ..
~ =~.OC
12/19/2020 AKASH
S,\~lS MANAOUl 9:J0 /\M 3:0C PM 0 ·~ -!~ t :cc.oi:
.•. 9 . 12/19/2020 V1,<AS
S/,Ll:S M/\:-lllC"•!,'R 11:C:1 l'M 8:0C /1\1 :1 'i-H 't 4SCa:;
Ml\!-~Gt.K S CG t-iv1 10:CC ~. '
1 -
I• ; -
.1-: ! 5 ~:;o.CC)
J\SSi l i\j,j 1 ':.l:OC;.\•I
M,'\N;\Gl:K 9:3C ;.J..:
COt-l'IRACT OR 11::.~ ~r'J~
SALES tvlAIII/\Gti{ 9:(,C -.~.!
S,\Lt.S MANA GER -. r. . "I
!.!.,:~~·~·-
-Creat-, a format A!>ov-,
1.
-,_
3.
TOTAL TIME
=IF(E,1>D4,E4-D4,E4+ 1-
D4)*2"1
OVERTIME =IF(F.;>$F$2,F4-SF$2,0)
SALARY =50*(4
/
=IF(TIME OUT>TIME IN.~-!i\1t: e,;_, ;-·i-!l-.-'.[ :~1,m.,~E
OUT+l· TIME IN)"'24 .
=IF(TOTAL TIME>'v'/ORKI:% "i :.1r:.,1·crAt TIME·
WORKING TIME,0)
=TOTAL TIME* SC, Rs.
tt n · r - rue~
1
1ns :n•·t~~-"9!1.i~;~!~~-'J~'..f: ~~~ ·•~~~~~:~~J~~~~-J.l'!.~-~• ,..~~::1:-:•.·-~~----~·-.. ·· Lli ..:-_-...:.:-,•_,~.:.•· -.._~-n~ , ~1.~"!K.~· -:i~~~'v;-;,; ~-.. ~~f.!~\~ -;r~:-._,_:
1
•
OM SAi COMPUTER INSTJTUTE, Sindhora B asantpur road, Varana!.i, Pl:,.,,1e: 914-;h,'J96 t::!
I
j l-Jon-7021 ?c
JANUARY J~iITIT~J- "iI:if.1;·r:~---11 i~,·: .. .if';T
---· . . -~':J&L;/-~~~~. ~;µ.· ~. l ... ~-;.-'=J:,~ ;,L!~;~
~ ~.l~~~~~-f ~'-f~t-";;,, .... ...; : ~-~~~-4 _B.i.l:L.•~.-.:.~•.: f:-
:'P-t'.' ~~~ttt~~tff~jfJ!f,:H~}~frFH _( _,; ·, .a..~--;.l:..._-+.r•. ~.::i:._.•_:• .... ""' .. _...
0
..,
.,.
j l-Jon-7021 ?c
JANUARY J~iITIT~J- "iI:if.1;·r:~---11 i~,·: .. .if';T
---· . . -~':J&L;/-~~~~. ~;µ.· ~. l ... ~-;.-'=J:,~ ;,L!~;~
~ ~.l~~~~~-f ~'-f~t-";;,, .... ...; : ~-~~~-4 _B.i.l:L.•~.-.:.~•.: f:-
:'P-t'.' ~~~ttt~~tff~jfJ!f,:H~}~frFH _( _,; ·, .a..~--;.l:..._-+.r•. ~.::i:._.•_:• .... ""' .. _...
0
..,
.,.
n
! l!l j
11.1
112:
In;
.,
-.:-
j 1
:
I 2
I
r:, _J
!
4
I
:,
l
<,
7
i 8
I 9 1
' -1
110
. ..
111
I_ 12;
13 i
14 i
15 I
I 16:
A
I. I
ash
tr.~-·-·-+--+--
G •ltP
P rn ---+"'--
4
Day Book
[ Porm~2J
~---· -,-.-y-~:;,~~-~~:;,~-------· 7
l
Apr•ZOZO to Mar-ZOZI
-----------·-·-----·-·" -----------
4N./i0J9 1t-nt .>i l•uirimg
--·-.... __ J~t~~~~P.!I!, Bill
B
. · ... · ... ,.
"-· "':..'} ~)9 ;':ldlt1r\'
G
Orn Sai Computer Pvt Ltd
Rec-.~i;,t P.. , :~
Apr-2020 to Ma:-... 02 ..
4/"i /2G.19 ll,:•rlf J: ~h,1p
\J t{) I_. U...3y
(,or,,~.~· ~·:}v
(,,r cl
--~----··---.-... -·'
,··----________ ,, _____ ]
L
Forn1at-: !
·------·-----~
[ f-
Day Book Repo, t
~•• er rnmreramnr-• a.w..•-·.;:.i1~.ff.!f.'!k!~"tb-~•wi~~~"-,,···~!.-M~~,•, ···"·f:·\J"~ ..... ;_~-.:• :..:.t;!~-.... -.-~~1-:•.:1•.~.~'!'-.\J.~~,~.,_ ... ~ :#:, •· .. ,, • ! ... _ .. • ....
OMSPJ COMPUTERINSllTUTE, Sindh,.:;·J r:,·,.:,::itpt,r r .-:-i,id, 'v\1rai ,> (·;1;1u~·
:.;1,,•i:,!~1::,1 !.
! l!l j
11.1
112:
In;
.,
-.:-
j 1
:
I 2
I
r:, _J
!
4
I
:,
l
<,
7
i 8
I 9 1
' -1
110
. ..
111
I_ 12;
13 i
14 i
15 I
I 16:
A
I. I
ash
tr.~-·-·-+--+--
G •ltP
P rn ---+"'--
4
Day Book
[ Porm~2J
~---· -,-.-y-~:;,~~-~~:;,~-------· 7
l
Apr•ZOZO to Mar-ZOZI
-----------·-·-----·-·" -----------
4N./i0J9 1t-nt .>i l•uirimg
--·-.... __ J~t~~~~P.!I!, Bill
B
. · ... · ... ,.
"-· "':..'} ~)9 ;':ldlt1r\'
G
Orn Sai Computer Pvt Ltd
Rec-.~i;,t P.. , :~
Apr-2020 to Ma:-... 02 ..
4/"i /2G.19 ll,:•rlf J: ~h,1p
\J t{) I_. U...3y
(,or,,~.~· ~·:}v
(,,r cl
--~----··---.-... -·'
,··----________ ,, _____ ]
L
Forn1at-: !
·------·-----~
[ f-
Day Book Repo, t
~•• er rnmreramnr-• a.w..•-·.;:.i1~.ff.!f.'!k!~"tb-~•wi~~~"-,,···~!.-M~~,•, ···"·f:·\J"~ ..... ;_~-.:• :..:.t;!~-.... -.-~~1-:•.:1•.~.~'!'-.\J.~~,~.,_ ... ~ :#:, •· .. ,, • ! ... _ .. • ....
OMSPJ COMPUTERINSllTUTE, Sindh,.:;·J r:,·,.:,::itpt,r r .-:-i,id, 'v\1rai ,> (·;1;1u~·
:.;1,,•i:,!~1::,1 !.
_,Iha
Create •fl •bov. Fonnat
ForRecefpt
=IF(C@>DavJ•"" "" .. nW(l
• ,., . :1))
=fF(C@'OateJ:'·" "" ,-.
• • I II;.,' T(l (@D:.tf!J, "ddd"))
Amount
Receipt Method
Cash
C.,rd
Google Pav
P.tytm
Total Recipt J'n-:t:.
=SUMIF!!.eled of receipt method all ren1e,seled crlterla,select all amount ranpJ
=SUMIF(Select of receipt method all rer,ge,select crlterfa,select all
amount ranpJ
-==SUMIF(Selec~ of receipt method all renge,seled crlterla,select alf amount range)
:SUMIF(Selert of rect!ipt method all renge,seled crlterla,select all amount rang!")
=sumf all recr!!pt metttod range)
For Payment
=IF([@OayJ="", "",RQ\A.f(l:l))
=I F([email protected] J ="", ""• TEXT([@Date J, "ddd"))
Payment IV:c-rhcd Amount
Cash =SUMIF(Sefect
:,f Payment method all renge,select <.riteria,select all P-=~-ment amount range)
Card =SUMIF{:;efect
of Payment methcd all renge,~elect criteria,sel"ct zll
Payment .1mount range)
Google Pay =SUMJF(Select
of Payment methoci all renge,select criterla,se!c:ct all Pay.nent amount range)
Payti.; =SUMIF(Select of Payment method oll renge,se::?ct criteria,select all
Payment .:imount range)
Total Payment =rnm('311 Pi'ymer;t method range)
Amt.
Day Boo'<
F,:,r Receipt
=SUMIF(Sclect Receipt date rc1nge,Dc1vbook datE:,Select all Receipt
amou:,t range)
For r~ymer,t
=SU'.f/F(Sefer:t P;~rn~:.H ~atp r.:inge,Dc1ybook date 5.~lect all Payment .im-,unt ranp.e)
B.rfance:: of 0.1y
Bafancr
-~n1-r11
=Hll +E 12-F12
== Paa, ·li!P.-'Vl.. Re ct: i µt -p '-"t r-te~ d -
=Balance+Rcceipt Amt-Payment Amt
-
Create •fl •bov. Fonnat
ForRecefpt
=IF(C@>DavJ•"" "" .. nW(l
• ,., . :1))
=fF(C@'OateJ:'·" "" ,-.
• • I II;.,' T(l (@D:.tf!J, "ddd"))
Amount
Receipt Method
Cash
C.,rd
Google Pav
P.tytm
Total Recipt J'n-:t:.
=SUMIF!!.eled of receipt method all ren1e,seled crlterla,select all amount ranpJ
=SUMIF(Select of receipt method all rer,ge,select crlterfa,select all
amount ranpJ
-==SUMIF(Selec~ of receipt method all renge,seled crlterla,select alf amount range)
:SUMIF(Selert of rect!ipt method all renge,seled crlterla,select all amount rang!")
=sumf all recr!!pt metttod range)
For Payment
=IF([@OayJ="", "",RQ\A.f(l:l))
=I F([email protected] J ="", ""• TEXT([@Date J, "ddd"))
Payment IV:c-rhcd Amount
Cash =SUMIF(Sefect
:,f Payment method all renge,select <.riteria,select all P-=~-ment amount range)
Card =SUMIF{:;efect
of Payment methcd all renge,~elect criteria,sel"ct zll
Payment .1mount range)
Google Pay =SUMJF(Select
of Payment methoci all renge,select criterla,se!c:ct all Pay.nent amount range)
Payti.; =SUMIF(Select of Payment method oll renge,se::?ct criteria,select all
Payment .:imount range)
Total Payment =rnm('311 Pi'ymer;t method range)
Amt.
Day Boo'<
F,:,r Receipt
=SUMIF(Sclect Receipt date rc1nge,Dc1vbook datE:,Select all Receipt
amou:,t range)
For r~ymer,t
=SU'.f/F(Sefer:t P;~rn~:.H ~atp r.:inge,Dc1ybook date 5.~lect all Payment .im-,unt ranp.e)
B.rfance:: of 0.1y
Bafancr
-~n1-r11
=Hll +E 12-F12
== Paa, ·li!P.-'Vl.. Re ct: i µt -p '-"t r-te~ d -
=Balance+Rcceipt Amt-Payment Amt
-
··~ ... t . l • ...... s...
llarl ........ s.nti s 1,011
llarl
----~
s l.11?0 ..,. T..._ ...,..
s UN ..... __
~ loultl s 1,2'7
llarS
---
........ s um
• ..... ....... QICwal $ l,&11
•
..,,
T.._ta
Soutfl $ &.29$
• oar• ....... ~·
$ 1,300
~oar•
Tallllcs Ncw1II $ 2,207
1,0.,:0 ~ centrer .s 2,7)8
-~ 0.,11 .... South $ 2.976
}!JO., 12 _. _ Mcb11et Ce:-itrel s 2.::01
.:M~0.,,13 Uplops ~orth s 2.U3
-~0.,1, Mublles central s 2..:.S2
JIIS!0..,15 _'l..aptql5 South s 1,652
D'o.,:s T~ Nomi
~ 3,~l
:j:;·:;
: Tabll!ls Central $ 1,342
Mows North s 1.r.22
JI0:0-.,19 i..ptops SOUttl s 3,462
.w~,20 1'.tllelS -South s :1,898
t
-';f ....
s 111
s :Ml
•
162
s •u
$ 171
s Ul
s 168
s ~6'
s ;17
s 3l,'!1
$ ~7
$ ~86
s 316
$ =~
$ :'lS
$ 450
s 1;"4
$ .H7
s ~50
$ 507
Set: 15
Llmltadons
of Excel
0
"
I
' ...... 111111
"'°""''
Plollt
'Dir.lo
l?"I
tAt"~( pc ~•1,;1
, .. "' 1•708 t'.'u-.s l:•'!16 •
c...a,111 l<l()II:" r.., .• :, 1~.57
Pruf• ~ bv Pr<M!Jt • ~
l.'J4,i
l,';iJh r~,
~ti~
b'',:,•,
·~ t:~:
-.q~
E,~~-
~
~--1
~
~ - <;
'
~'.,
L.prop~ ,.·1cl:'!e, 1 at?!et$
•.": ., ...
'}•'
llarl ........ s.nti s 1,011
llarl
----~
s l.11?0 ..,. T..._ ...,..
s UN ..... __
~ loultl s 1,2'7
llarS
---
........ s um
• ..... ....... QICwal $ l,&11
•
..,,
T.._ta
Soutfl $ &.29$
• oar• ....... ~·
$ 1,300
~oar•
Tallllcs Ncw1II $ 2,207
1,0.,:0 ~ centrer .s 2,7)8
-~ 0.,11 .... South $ 2.976
}!JO., 12 _. _ Mcb11et Ce:-itrel s 2.::01
.:M~0.,,13 Uplops ~orth s 2.U3
-~0.,1, Mublles central s 2..:.S2
JIIS!0..,15 _'l..aptql5 South s 1,652
D'o.,:s T~ Nomi
~ 3,~l
:j:;·:;
: Tabll!ls Central $ 1,342
Mows North s 1.r.22
JI0:0-.,19 i..ptops SOUttl s 3,462
.w~,20 1'.tllelS -South s :1,898
t
-';f ....
s 111
s :Ml
•
162
s •u
$ 171
s Ul
s 168
s ~6'
s ;17
s 3l,'!1
$ ~7
$ ~86
s 316
$ =~
$ :'lS
$ 450
s 1;"4
$ .H7
s ~50
$ 507
Set: 15
Llmltadons
of Excel
0
"
I
' ...... 111111
"'°""''
Plollt
'Dir.lo
l?"I
tAt"~( pc ~•1,;1
, .. "' 1•708 t'.'u-.s l:•'!16 •
c...a,111 l<l()II:" r.., .• :, 1~.57
Pruf• ~ bv Pr<M!Jt • ~
l.'J4,i
l,';iJh r~,
~ti~
b'',:,•,
·~ t:~:
-.q~
E,~~-
~
~--1
~
~ - <;
'
~'.,
L.prop~ ,.·1cl:'!e, 1 at?!et$
•.": ., ...
'}•'
l
J•,
t
;l:
r
r.
..
. ,
:i
i :
Using Scenar1 . .
:
0 Manaaer
Set: 16
1
2
·4
s
6
.7
8
a
J
1
2
5
6
7
8
10
1 ~
J. l
12
13
A
8
·. t ' .
. .
Mouse Prl\duction
fi>;rt~~ ·1~-~-...:· ..
~ :_,__ _Cost
--
,c·r -. -B .40
i-:; cu1t O?.rd .
iV✓ire ---!--GO
~b ---L 25
,la cur C
:---- 22
~otal_s:ost -- ---·-1
4
..,1
---------~
g
C
• t
• • I
E F
1
·✓::i'. ·es : ·:~u:-rP.nt V;;IL.!es column reprss~nts values of changir,g cells at
~irn:-.S-:tn2rio Surirn.:iry Report V• .'a) created. Changing cells for each
,.,. ·• ,r·I(' ~ ra l).1'11• i;,·"1t,:,.J
0
1" 1Jray
"'> ... "·1 :n .... \.-C .:-:,1 '• ,:,1 1._ ·..1 , I c, ,
· ---G · ~i
J•,
t
;l:
r
r.
..
. ,
:i
i :
Using Scenar1 . .
:
0 Manaaer
Set: 16
1
2
·4
s
6
.7
8
a
J
1
2
5
6
7
8
10
1 ~
J. l
12
13
A
8
·. t ' .
. .
Mouse Prl\duction
fi>;rt~~ ·1~-~-...:· ..
~ :_,__ _Cost
--
,c·r -. -B .40
i-:; cu1t O?.rd .
iV✓ire ---!--GO
~b ---L 25
,la cur C
:---- 22
~otal_s:ost -- ---·-1
4
..,1
---------~
g
C
• t
• • I
E F
1
·✓::i'. ·es : ·:~u:-rP.nt V;;IL.!es column reprss~nts values of changir,g cells at
~irn:-.S-:tn2rio Surirn.:iry Report V• .'a) created. Changing cells for each
,.,. ·• ,r·I(' ~ ra l).1'11• i;,·"1t,:,.J
0
1" 1Jray
"'> ... "·1 :n .... \.-C .:-:,1 '• ,:,1 1._ ·..1 , I c, ,
· ---G · ~i
f:
~
~
~
i,
t
.,
,
~
t
,
►
r
t
I
OM SAi COMPUTER INSTI,!E,!E_ ............ __ dtiiaf---.• M . _,
Set: 17
Calculate EMI Using P1"1T,PP1\1T,IP.l\1T
I
--+----------.... --
,._~~~•:~111 .
i -:·4
'
' ---·
~
~
~
i,
t
.,
,
~
t
,
►
r
t
I
OM SAi COMPUTER INSTI,!E,!E_ ............ __ dtiiaf---.• M . _,
Set: 17
Calculate EMI Using P1"1T,PP1\1T,IP.l\1T
I
--+----------.... --
,._~~~•:~111 .
i -:·4
'
' ---·
---~~----~.!?.~SAi COMPUTER iNSTITUTE
L
J Set: 18
Monthlv RD
.. arnount calculation with future Value
6
F .•
',•
-·--- c.---•
:: --
'- 0
E
I
r
F
G H
l
-. --·
1~~NTHL;~
----·----·
NMCJPAL ' :.~ ... ,o i.•.:..,;: :· c,e
O?l!NIHO, ,1!1C:IPAL IPfffllnf
AMOUNTwmt _ ·.-:.~. r
CA~.lloNCr .l'H-0-0Nf 1'#.0UNT ltATe
INTllll!lf
1
JAN
0.00 lOC0.00 1.33 1008.33 1000.00
2
cEs
1:XS.33 1000.00 2003.33 16.74 2025.07
i 3 ,,.."i.l_t
2G2S.Oi 1000.00 3025.07 25.21 3050.28
-I
:.o~
305!;.~8 !COO.DO 4050.28 33.75 4084..03
5
VAY
d0!!4 03 1000.o:> 5084.03 42.37 5126.40
c ..:~.
5126AC IC.JO.Ou 6U6.40 51.05 6177A5
7
:t.:i.
6177.-15 1000.00 nn.45 59.81 7237.26
[ 1l
A.;G
nn.26 !OC-C.OC. 8237.26 69.64 8305.91
L
9
5::>
8305.91 lCOC.00 9305.91 77.55 9383.46 .. ~
OCT 938~.46 1000.CO 10383.46 86.53 10469..98
!l
!-~0 --✓
lG<:~9.31! 10c,:.co 11469.98 95.58 11565.57
,___
.
104.71 U670.28
-1.::
:.:-=c. 11565.57 . lOC0.00 1.2!'65. 57
J
,.
=.FV (A.rmual fotcrc•~t rat-e/Nurnber of payments in months, Loan period in years*Number of payments in
month!;, -RD (Rerurdng DcptJs;t) A.\'TOUNT, l) -...
L
J Set: 18
Monthlv RD
.. arnount calculation with future Value
6
F .•
',•
-·--- c.---•
:: --
'- 0
E
I
r
F
G H
l
-. --·
1~~NTHL;~
----·----·
NMCJPAL ' :.~ ... ,o i.•.:..,;: :· c,e
O?l!NIHO, ,1!1C:IPAL IPfffllnf
AMOUNTwmt _ ·.-:.~. r
CA~.lloNCr .l'H-0-0Nf 1'#.0UNT ltATe
INTllll!lf
1
JAN
0.00 lOC0.00 1.33 1008.33 1000.00
2
cEs
1:XS.33 1000.00 2003.33 16.74 2025.07
i 3 ,,.."i.l_t
2G2S.Oi 1000.00 3025.07 25.21 3050.28
-I
:.o~
305!;.~8 !COO.DO 4050.28 33.75 4084..03
5
VAY
d0!!4 03 1000.o:> 5084.03 42.37 5126.40
c ..:~.
5126AC IC.JO.Ou 6U6.40 51.05 6177A5
7
:t.:i.
6177.-15 1000.00 nn.45 59.81 7237.26
[ 1l
A.;G
nn.26 !OC-C.OC. 8237.26 69.64 8305.91
L
9
5::>
8305.91 lCOC.00 9305.91 77.55 9383.46 .. ~
OCT 938~.46 1000.CO 10383.46 86.53 10469..98
!l
!-~0 --✓
lG<:~9.31! 10c,:.co 11469.98 95.58 11565.57
,___
.
104.71 U670.28
-1.::
:.:-=c. 11565.57 . lOC0.00 1.2!'65. 57
J
,.
=.FV (A.rmual fotcrc•~t rat-e/Nurnber of payments in months, Loan period in years*Number of payments in
month!;, -RD (Rerurdng DcptJs;t) A.\'TOUNT, l) -...
-
OM SAi COMPUTER INfflTUTE
Set: 19
Goal Seek
-~ARGET TO GET 80%
,PERCENTA
CHE·, ·J, ,, PHY
MARKS GE
88 500. 80;
--------~---~
--= er·
OM SAi COMPUTER INfflTUTE
Set: 19
Goal Seek
-~ARGET TO GET 80%
,PERCENTA
CHE·, ·J, ,, PHY
MARKS GE
88 500. 80;
--------~---~
--= er·
I
• . . .
•
l
f
!
OMMI
· Set: 20 :
h ,vise bl tbe
A ndrnont
company rttords the details of total sales (In Rs.) sector ,vise •
foDowfng format '
Jan
Feb
March
Sector 30
12000
17000 14000
Sector 22
14000 18000 15000
1 Sector 23
15000 19000 16000
! Sector 15
16000
12000 17000
'
(a) Enter the d:ita in-a worksheet and save it as r.ector.xls
(b) Using appropriate formula, ·calculate total sale for each sector · ·-(c) Create a 3-D column chart to show sector wise data for all four mon
th
s
•
p"
• • •
(d) Cr-eate a 3-D pie «;hart to show sales in Jan in all sectors
April
1sooo
16000
17000
18000
• . . .
•
l
f
!
OMMI
· Set: 20 :
h ,vise bl tbe
A ndrnont
company rttords the details of total sales (In Rs.) sector ,vise •
foDowfng format '
Jan
Feb
March
Sector 30
12000
17000 14000
Sector 22
14000 18000 15000
1 Sector 23
15000 19000 16000
! Sector 15
16000
12000 17000
'
(a) Enter the d:ita in-a worksheet and save it as r.ector.xls
(b) Using appropriate formula, ·calculate total sale for each sector · ·-(c) Create a 3-D column chart to show sector wise data for all four mon
th
s
•
p"
• • •
(d) Cr-eate a 3-D pie «;hart to show sales in Jan in all sectors
April
1sooo
16000
17000
18000
Tags
Categories
GeneralDownload
Download Slideshow Get the original presentation fileQuick Actions
Statistics
- Views 161
- Slides 24
- Age 576 days
Related Slideshows
22
Pray For The Peace Of Jerusalem and You Will Prosper
RodolfoMoralesMarcuc
30 views
26
Don_t_Waste_Your_Life_God.....powerpoint
chalobrido8
32 views
31
VILLASUR_FACTORS_TO_CONSIDER_IN_PLATING_SALAD_10-13.pdf
JaiJai148317
30 views
14
Fertility awareness methods for women in the society
Isaiah47
29 views
35
Chapter 5 Arithmetic Functions Computer Organisation and Architecture
RitikSharma297999
26 views
5
syakira bhasa inggris (1) (1).pptx.......
ourcommunity56
28 views