part4
MicroSoft
Excel (2003)
MicroSoft Excel esa tksM+] ?kVk] xq.kk] Hkkx o xf.kfr; dk;Z djrs
gSaA M.S Excel (2003) dh sheet esa
256 Columns
rFkk 65536 Rows gksrh
gSaA
vkSj
2007 dh sheet esa 16384 Columns rFkk
1048576 Rows gksrh gSaA
Sum ds }kjk la[;kvksa dks
tksM+rs gSaA
=Sum(Start Cells: Last Cells)
Average ds }kjk vkSlr dks fudkyk tkrk gSA
=Average(Start Cells: Last Cells)
Count ds }kjk fy[ks gq;s cells dh la[;k;sa dks
fxuk tkrk gSaA
= Count(Start Cells : Last Cells)
Min ds }kjk lcls NksVh la[;k dks ns[kk tkrk gSA
=Min(Start Cells : Last Cells)
Max ds }kjk lcls cM+h la[;k dks ns[kk tkrk gSA
=Max(Start Cells : Last Cells) Countblank
ds }kjk [kkyh cells dh la[;k dks fxuk tkrk gSA
=Countblank(Start Cells: Last Cells)
sumif ds }kjk fdlh Hkh la[;k ls NksVh@cM+h la[;kvksa dks
tksM+rs gSaA
=Sumif(Start Cells : Last Cells,”>=la[;k fy[ksaxs”) cM+h la[;k ds fy;s
=Sumif(Start Cells : Last Cells,”<=la[;k fy[ksaxs”) NksVh la[;k ds fy;s
Countif ds }kjk fdlh Hkh la[;k ls NksVh@cM+h la[;kvksa dks
fxurs gSa fd ml la[;k ls NksVh@cM+h la[;k;sa fdruh ckj fy[kh gq;h gSaA =Countif(Start Cells : Last Cells,”>=la[;k fy[k saxs”) cM+h la[;k ds
fy;s
=Countif(Start Cells : Last Cells,”<=la[;k fy[ksaxs”) NksVh la[;k ds fy;s
Division :- Division Presentage (%) ds vuqlkj fudkyh tkrh gSA
=if(%
>=60,”I”,if(%>=45,”II”,if(%>=33,”III”,if(%<=33,”fail”,))))
Note:-Start cell dk vFkZ gS fd tgk¡ ls lysDV djuk pkyw djrs gSaA
Last Cells dk vFkZ gS tgk¡
rd lysDV djrs gSA Divison esa % dh txg Áfr”kr
(presentage) dks lysDV djrs gSA Enterkey( )gSA
1.Salary of
the Employers table
bl Tabble esa Total dks fudkyuk gS \
blesa Salary, Room, rFkk F.A dks sum }kjk
tksM+ ds Total fudkrs gSaA
|
Sr No
|
Name
|
Salary
|
Room Rent
|
F.A
|
Total
|
|
Ans.
|
|
|
|
|
9120
|
|
1
|
Mohan
|
9000
|
100
|
20
|
=sum(Salary Room
F.A)
|
|
2
|
Sohan
|
8000
|
200
|
300
|
|
|
3
|
Abrar
|
7000
|
450
|
340
|
|
|
4
|
Raul
|
1000
|
350
|
250
|
|
|
5
|
Suresh
|
1000
|
300
|
150
|
|
|
6
|
Rakesh
|
1500
|
250
|
190
|
|
|
7
|
veenit
|
2000
|
400
|
210
|
|
|
8
|
Amit
|
3000
|
300
|
220
|
2:- Perday rFkk Day Table
bl table ds vUnj perday
rFkk total dks
fudkyuk gS \
bl table ds
vUnj perday fudkyus
ds fy;s Salary
dks Month ls Hkkx
(/)
djsaxs vkSj
total fudkyus
fy;s perday dh
Day ls
xq.kk djsaxsA
|
Sr No
|
Name
|
Salary
|
Month
|
Per day
|
Day
|
Total
|
|
Ans.
|
|
|
|
15
|
|
315
|
|
1
|
Hariom
|
450
|
30
|
 =Salary / Month |
21
|
 =Day * Per day |
|
2
|
Ram
|
480
|
30
|
20
|
||
|
3
|
Shyam
|
4000
|
30
|
25
|
||
|
4
|
Rohit
|
3600
|
30
|
30
|
||
|
5
|
Mohit
|
5000
|
30
|
24
|
||
|
6
|
Raju
|
6000
|
30
|
15
|
||
|
7
|
pankaj
|
6500
|
30
|
18
|
||
|
8
|
suresh
|
7000
|
30
|
26
|
3.T.A rFkk D.A Table
bl Table esa T.A, D.A, T.A+D.A, Total dks fudkyuk gS \
T.A (Traveler Alowence) fudkyus ds fy;s Salary esa 2% ls xq.kk djsaxs] D.A
(Dinner Alowence) fudkyus ds fy;s salary esa 3% ls xq.kk djsaxsAT.A+ D.A fudkyus ds fy;s T.A rFkk D.A dks tksM+rs gSaA
Total fudkyus ds fy;s Salary rFkk T.A+D.A dks tksM+rs gSaA
|
Sr No
|
Name
|
salary
|
T.A 2%
|
D.A 3%
|
T.A+D.A
|
Total
|
|
Ans.
|
|
|
160
|
240
|
400
|
 8400 |
|
1
|
Ranu
|
8000
|
=Salary * 2%
|
=Salary * 3%
|
 =TA+D.A |
=Salary + T.A+DA
|
|
2
|
Mohan
|
10000
|
||||
|
3
|
Shyamu
|
15000
|
||||
|
4
|
Ram
|
4500
|
||||
|
5
|
Sonu
|
9000
|
||||
|
6
|
Abrar
|
9500
|
||||
|
7
|
Rohit
|
11000
|
||||
|
8
|
Shyam
|
3200
|
4. Interest Table
bl Table esa Interest ¼C;kt½ rFkk Total dks fudkyuk gS \
Intrest fudkyus ds fy;s salary rFkk Rate vkSj Time ls xq.kk rFkk 100 ls Hkkx
djsaxs]Total fudkyus ds fy;s intrest rFkk Salary dks tksM+rs gSaA
|
Sr. No
|
Name
|
Salary
|
Rate%
|
Time / year
|
100
|
Interest
|
Total
|
|
Ans.
|
|
|
|
|
|
200
|
10200
|
|
1
|
Ramu
|
10000
|
2
|
1
|
100
|
 =salary*rate*time/100 |
 =salary+interest |
|
2
|
Ranu
|
20000
|
3
|
2
|
100
|
||
|
3
|
Neha
|
30000
|
4
|
4
|
100
|
||
|
4
|
Salu
|
4000
|
1
|
3
|
100
|
||
|
5
|
Sonu
|
4500
|
2
|
4
|
100
|
||
|
6
|
Monu
|
5000
|
2
|
5
|
100
|
||
|
7
|
Shiv
|
4500
|
3
|
2
|
100
|
||
|
8
|
Vans
|
6000
|
4
|
4
|
100
|
5. Purchase Table
bl Table esa Purchase Amount, Total
Fright rFkk Tota Amount dks fudkyuk gS \
blesa Purchase
Amount fudkyus ds fy;s Purchase (K.g) dks R/P ls xq.kk djsaxs vkSj Total Freight fudkyus ds fy;s Purchase (K.g) dks Freight ls xq.kk djsaxs vkSj Total Amount fudkyus ds fy;s Purchase Amount vkSj Total
Freight
dks tksM+
nsaxsA
|
Sr No
|
Quality
|
Purchase (kg)
|
R/p
|
Purchase Amount
|
Freight
|
Total Freight
|
Total Amount
|
|
|
Ans.
|
|
|
4500
|
|
1800
|
6300
|
|
1
|
Wheat
|
90
|
50
|
 =Purchase (kg) * R/p |
20
|
 =Purchase (kg) * Freight |
=Purchase Amount +Total
 Freight |
|
2
|
Rice
|
40
|
30
|
15
|
|||
|
3
|
Biscuit
|
50
|
80
|
17
|
|||
|
4
|
Potato
|
60
|
20
|
19
|
|||
|
5
|
Bread
|
20
|
60
|
25
|
|||
|
6
|
Apple
|
30
|
90
|
30
|
|||
|
7
|
Mango
|
35
|
70
|
10
|
|||
|
8
|
|
50
|
65
|
10
|
6. Sales Table
bl Table esa Sales Amount, Stoke Item rFkk Tota Amount dks fudkyuk gS \
blesa Sales Amount
dks fudkyus ds fy;s Sales (kg) dks
R/P
ls xq.kk djsaxs] Stoke Item
dks fudkyus ds fy;s purchase esa ls Sales
dks ?kVk;saxs vkSj Total Amount dks fudkyus ds fy;s Stoke Item rFkk R/P
dh xq.kk djsaxsA
|
Sr No
|
Quality
|
Purchase (kg)
|
Sales (kg)
|
R/p
|
Sales Amount
|
Stock
Item
|
Total Amount
|
|
|
Ans.
|
|
|
|
2000
|
10
|
250
|
|
1
|
Wheat
|
90
|
80
|
25
|
 =Sales * R/p |
 =Purchase(kg) – Sales (kg) |
 =R/p*Stock Item |
|
2
|
Rice
|
40
|
40
|
20
|
|||
|
3
|
Biscuit
|
50
|
49
|
60
|
|||
|
4
|
Potato
|
60
|
55
|
45
|
|||
|
5
|
Bread
|
20
|
19
|
65
|
|||
|
6
|
Apple
|
30
|
30
|
60
|
7. Subtotal Table
bl Table
esa vyx&vyx
Category ds ,d gh
Product
dk Amount rFkk
lHkh Category ds Products dk Grand Total dks
fudkyuk gS \
blesa lkjh Table dks select djrs gSaA select djds Data Menubar esa tkdj subtotal ij click djrs gSaA Table ds vuqlkj product, category rFkk Total amount dks Select djsaxsA
 |
|||
|
|||
|
Sr. No
|
Product
|
Category
|
Total Amount
|
|
|
Ans.
|
|
|
2991500
|
|
|
1
|
Car
|
Maruti
|
500000
|
|
|
2
|
Car
|
Alto Car
|
700000
|
 Data Menu
Subtotal |
|
3
|
Car
|
Van
|
600000
|
|
|
4
|
Car
|
Tata
Indca
|
400000
|
|
|
5
|
Cycle
|
Atlas
|
3500
|
|
|
6
|
Cycle
|
Hero
|
3000
|
|
|
7
|
Motor
Cycle
|
Honda
|
50000
|
|
|
8
|
Motor
Cycle
|
Bajaj
|
45000
|
|
|
9
|
Motor
Cycle
|
TVS
|
40000
|
|
|
10
|
Bus
|
Abrar
|
150000
|
|
|
11
|
Bus
|
Vishal
|
200000
|
|
|
12
|
Bus
|
Hasmuddin
|
300000
|
|
8. T.A, D.A rFkk H.A Table
bl Table esa T.A, D.A vkSj H.A rFkk Gross Salary dks fudkyuk gS \
bl Table esa T.A, D.A
RkFkk
H.A
dks If ds Formula ls Salary dks Select djds fudkyrs gSaA Gross salary fudkyus ds fy;s
T.A, D.A
RkFkk
H.A
dks tksM+rs gSaA
 |
|
|
1.
Salary>= 50000, 2. Salary >=
20000, 3. Salary = 10000, 4.Salary <=
10000
T.A= 9.5 T.A= 4.7 T.A= 2.6 T.A= 1.5
D.A= 5.3 D.A= 4.8 D.A= 3.6 D.A= 2.5
H.A= 5.5 H.A= 3.0 H.A= 3.9 H.A= 3.5
Goss Salary? Goss Salary? Goss
Salary? Goss Salary?
=IF(E3>=50000,”9.5”,IF(D2>=20000,”4.7”,IF(D2>=10000,”2.6”,IF(D2<=10000,”1.5”,))))
(T.A)
=IF(E3>=50000,”5.3”,IF(D2>=20000,”4.8”,IF(D2>=10000,”3.6”,IF(D2<=10000,”2.5”,)))) (D.A)
=IF(E3>=50000,”5.5”,IF(D2>=20000,”3.0”,IF(D2>=10000,”3.9”,IF(D2<=10000,”3.5”,))))
(H.A)
Note- E3 dh
txg table
esa fy[kh salary dks select
djrs gSaA
|
Sr. No
|
Customer
Name
|
Customer
Code
|
Salary
|
T.A
|
D.A
|
H.A
|
Gross salary
|
|
Ans.
|
|
|
|
2.6
|
3.6
|
3.9
|
11010.1
|
|
1
|
Ramu
|
101
|
11000
|
=If(salary>=
|
=If(salary>=
|
=If(salary>=
|
=Slary +TA +
 D.A + H.A |
|
2
|
Ranu
|
102
|
50000
|
||||
|
3
|
Neha
|
103
|
40000
|
||||
|
4
|
Salu
|
104
|
20000
|
||||
|
5
|
Sonu
|
105
|
30000
|
||||
|
6
|
Monu
|
106
|
35000
|
||||
|
7
|
Shiv
|
107
|
45000
|
||||
|
8
|
Vans
|
108
|
35000
|
|
|
|
|
9. Subject Table
bl Table esa Total vkSj %age (Persantage) rFkk Division dks fudkyuk gS \
blesa igys sum ds }kjk Total
fudkyrs gSa] fQj
%age dks
fudkyus ds fy;s
Total dks subject
dh la[;k ls Divide djrs gSa vkSj Division fudkyus
ds fy;s
%age
dks select fd;k
tkrk gSA
Division Formula:-
|
Roll
No.
|
Student Name
|
Subject
|
Total
Marks
|
%age
|
Division
|
|||||
|
Hindi
|
Math
|
Eng
|
Scie
|
Drawing
|
S.scie
|
|||||
|
Ans.
|
|
|
|
|
|
|
|
312
|
52 |
Secound
|
|
1
|
Ranu
|
56
|
45
|
56
|
45
|
60
|
50
|
 =sum( lHkh subject dks Select djsa) |
=Total
Marks /6
|
=If(%age>=
|
|
2
|
Mohan
|
40
|
60
|
40
|
60
|
65
|
35
|
|||
|
3
|
Shyamu
|
20
|
50
|
20
|
50
|
67
|
34
|
|||
|
4
|
Ram
|
25
|
55
|
25
|
55
|
70
|
62
|
|||
|
5
|
Sonu
|
24
|
61
|
24
|
61
|
7 5
|
65
|
|||
|
6
|
Abrar
|
30
|
26
|
30
|
26
|
80
|
70
|
|||
|
7
|
Rohit
|
36
|
50
|
36
|
50
|
85
|
58
|
|||
|
8
|
Shyam
|
32
|
65
|
32
|
65
|
79
|
60
|
|||
=IF(%age>=60,”First”,IF(%age>=45,”Secound”,IF(%age>=33,”Third”,IF(%age<=33,”Fail”,))))
10. Discount table
bl Table esa Amount vkSj Discount
20% rFkk Total Amount dks fudkyuk gS \
blesa Amount
fudkyus ds fy;s Qty (Quantity)
dks R/p
(Rupee per Pecies) ls
xq.kk djsaxsA
20% Discount fudkyus ds fy;s Amount dks 20% ls xq.kk djsxsA Total fudkyus ds fy;s Amount
esa ls Discount dks ?kVk nsrs gSA
|
Sr No
|
Items
Name
|
Items
code
|
Quantity
(Qty)
|
R/P
|
Amount
|
Discount
20%
|
Total
Amount
|
|
Ans.
|
|
|
|
|
1000
|
200
|
800
|
|
1
|
V.C.D
|
123
|
10
|
100
|
=Qty* R/p |
 =Amount*20% |
 =Amount- discount |
|
2
|
D.V.D
|
234
|
12
|
150
|
|||
|
3
|
T.V
|
123
|
10
|
1000
|
|||
|
4
|
Computer
|
123
|
15
|
2500
|
|||
|
5
|
A.C
|
125
|
20
|
3000
|
|||
|
6
|
Copy
|
126
|
18
|
20
|
|||
|
7
|
Pen
|
124
|
25
|
10
|
|||
|
8
|
Keyboard
|
320
|
30
|
250
|
11. Profit Table
bl Table
esa Purchase Amount vkSj Sales Amount rFkk Profit R/p o Profit Amt (Amount) dks fudkyuk gS \
bl Table esa Purchase Amount (AMT) fudkyus ds fy;s Purchase Qty (Qauntity) dks R/p ls xq.kk djsaxsA Sales Amount fudkyus ds fy;s Sales Qty dks R/p ls
xq.kk djsxsA vkSj Profit R/p esa ,d cLrq ij ykHk
fudkyrs gSaA vFkkZr
Sales R/p esa ls Purchase R/p dks ?kVkrs gSaA vkSj Profit AMT fudkyus ds fy;s Salses Amount esa ls Purchase Amount dks ?kVk;saxsA
|
|
|
Purchase
|
Sales
|
Profit
|
|||||
|
Sr No
|
Item
Name
|
Purchase
Quantity
|
R/p
|
Purchase
Amount
|
Sales
Quantity
|
R/p
|
Sales
Amount
|
Profit
R/p
|
Profit
Amount
|
|
|
Ans.
|
|
|
3000
|
|
|
3190
|
 10 |
190
|
|
1
|
V.C.D
|
30
|
100
|
 =Purchase
Quantity * R/p |
29
|
110
|
 =Sales
Quantity * R/p |
=Sales R/p – Purchase R/p
|
=Sales Amount – Purchase
Amount |
|
2
|
D.V.D
|
40
|
130
|
35
|
150
|
||||
|
3
|
T.V
|
50
|
150
|
45
|
155
|
||||
|
4
|
Computer
|
10
|
100
|
8
|
100
|
||||
|
5
|
A.C
|
10
|
200
|
10
|
210
|
||||
|
6
|
Copy
|
50
|
10
|
49
|
15
|
||||
Table -12:- Reject Table
bl Table
esa Purchase Amount vkSj Sales Amount rFkk Reject Qty o Reject R/p
vkSj Reject Amount) dks
fudkyuk gS \
bl Table esa Purchase Amount (AMT) fudkyus ds fy;s Purchase Qty (Qauntity) dks R/p ls xq.kk djsaxsA Sales Amount fudkyus ds fy;s Sales Qty dks R/p ls
xq.kk djsxsA vkSj Reject Qty fudkyus ds fy;s Purchase
Qty esa ls Sales Qty dks
?kVkrs gSaA
rFkk Reject R/p esa Purchase Amount dks fy[krs gSa] rFkk Reject
Amount dks fudkyus ds fy;s Reject Qty dks Reject R/p ls xq.kk djrs gSaA
12. Reject Table
|
|
Purchase
|
Sales
|
Reject
|
|||||||
|
Sr
No
|
Item
Name
|
Qty
|
R/p
|
Purchase
Amount
|
Qty
|
R/p
|
Sales
Amount
|
Qty
|
R/p
|
Reject
Amount
|
|
|
Ans.
|
|
|
 8000 |
|
|
7790
|
 5 |
80
|
400 |
|
1
|
Book
|
100
|
80
|
=Purchase Qty *
R/p
|
95
|
82
|
 = |
=Purchase Qty - Sales Qty
|
 =Purchase R/p |
=Reject Qty * Reject R/p
|
|
2
|
Pen
|
150
|
10
|
100
|
12
|
|||||
|
3
|
Copy
|
120
|
15
|
100
|
16
|
|||||
|
4
|
Schell
|
200
|
10
|
180
|
13
|
|||||
|
5
|
File
|
150
|
20
|
120
|
25
|
|||||
|
6
|
Lock
|
100
|
60
|
80
|
60
|
|||||
|
7
|
chair
|
50
|
200
|
40
|
220
|
|||||
|
8
|
Table
|
60
|
250
|
45
|
260
|
|||||
13. Commission vkSj
Bonus
Table
bl Table esa Commision vkSj Commision Amount rFkk Bonus o Total Amount dks fudkyuk gS \
bl Table esa Commision fudkyus ds fy;s Salary dks Select
djrs gSaA Commision Amount fudkyus
ds fy;s Salary dks Commision ls xq.kk vkSj 100 ls Hkkx djrs gSaA Bonus dks fudkyus ds fy;s Hkh Salary dks Select djrs
gSaaA rFkk Total dks fudkyus ds fy;s Salary rFkk Commision Amount vkSj Bonus dks tksM+rs gSaA
Salary Commision Bonus Commision Amt
(1)
150000 6 6000
(2)
100000 5.5 5000
100000 5.5 5000
(3)
50000 5 2000
(4)
10000 2 1000
(5)
10000 1 0
Cammision vkSj Bous dks fudkyus ds Formula:-
=IF(D2>=150000,"6",IF(D2>=100000,"5.5",IF(D2>=50000,"5",IF(D2>=10000,"2",IF(D2<=10000,"1"))))) (Commision)
=IF(D2>=150000,"6000",IF(D2>=100000,"5000",IF(D2>=50000,"2000",IF(D2>=10000,"1000",IF(D2<=10000,"0"))))) (Bouns)
Note - D2 dh txg table esa fy[kh salary dks select djrs gSaA
|
Sr.
No
|
Customer
Name
|
Customer
Code
|
Salary
|
Commission
|
Commission
Amount
|
Bonus
|
Total
|
|
|
Ans.
|
|
|
5
|
2750
|
2000
|
59750
|
|
1
|
Ram
|
123
|
55000
|
=If(Salar>=
|
=Salary*Commission
 100 |
=If(Salar>=
|
 =Salary+
Commission Amount+ Bonus |
|
2
|
Sita
|
125
|
10000
|
||||
|
3
|
Rani
|
124
|
20000
|
||||
|
4
|
Raja
|
127
|
30000
|
||||
|
5
|
Mohan
|
129
|
3500
|
||||
|
6
|
Shyam
|
120
|
25000
|
||||
|
7
|
Radha
|
415
|
15000
|
||||
|
8
|
Pankaj
|
420
|
20000
|
uksV
%& vf/kdka”krk lHkh formulas dks
yxkus ds fy;s fdlh Hkh “kCn ;k vad dks cell esa gh fy[kdj select djsaxsA
Formula Introudction:-
1. Addition A1+B5
tksM+
2. Subtraction A1-B5 ?kVkuk 3. Multiplication A1*B5 xq.kk 4. Division A1/B5 Hkkx 5. Persentage 500*2% Áfr”kr
Comparison Operaters:-
blds }kjk ge nks ekuksa dh rqyuk djrs gSaaA mlds
ifj.kke ds vuqlkj dk;Z djrs gSaA
= Equel to cjkcj
> Grater then cM+k
< Less then NksVk
>= Grater then Or Equalt to cM+k
;k cjkcj
<> Not Equalt to cjkcj ugha
Month ds }kjk fdlh rkjhd esa
eghuk ns[krss gSaA
tSls =Month(19/07/2012) 07Now ls orZeku le; rFkk rkjh[k
ns[krs gSaA
tSls =Now() 19/07/2012,2:17pm
Today ls vkt dh rkjh[k ns[krss
gSaA
tSls =Today() 19/07/2012
Year ls fdlh rkjh[k esa o’kZ ns[krs gSaA
tSls =Year(20/07/2012) 2012
Abs ls fdlh l[a;k dk fu’is{k eku ns[krs gSaA
tSls =Abs(45) 45
Exp ls fdlh l[a;k dk
,Dliksusfl;y (Exponational) eku ns[krs gSaA
tSls =Exp(45) 3.49343E+19
Fact ls fdlh l[a;k dk QSDVsfj;y(Factorial) eku ns[krs gSaA
tSls =Fact(45) 1.19622E+56
log ls fdlh l[a;k dk fn;s gq,
vk/kkj ij y?kqx.kd ns[krs gSaA
tSls =Log(10,[5]) 1.430677
log10 ls fdlh l[a;k ds vk/kkj 10 dk y?kqx.kd ns[krs gSaA
tSls =Log10(50) 1.698970004
Mod ls fdlh l[a;k ds “ks’kQy dks ns[krs gSaA
tSls =MOD(125,10) 5
PI ls ikbZ dk eku ns[krs
gSaA
tSls =pi() 3.141593
Power ls fdlh l[a;k dh ?kkr ns[krs
gSaA
tSls =Power(2,3) 8 tSls =
Round ls fn;s x;s n”keyo vadksa
rd ds fudVre Hkkx dks ns[krs gSaA
tSls =Round(3.3456,3) 3.345
SQRT ls fdlh la[;k dk oxZewy ns[krs
gSaA
tSls =SQRT(16) 4
STDEV ls ekud fopyu ns[krs gSaA
tSls =STDEV(2,4) 1.414214
TEXT FUNCTION
CODE ls fdlh text dk dksM ns[krs gSaA
tSls =Code(leeladhar) 76
CHAR ls fdlh fn;s x;s dksM dk
o.kZ ns[krs gSaA
tSls =Char(76) L
Exact ls nks ikB~;ksa dh rqyuk ns[krs
gSaA
tSls =Exact(abrar,leeladhar) False
Left ls fdlh ikB;@text ds ck;kWa Hkkx ds v{kj dks ns[krs gSaA
tSls =Left (Leeladhar) L
Right ls fdlh ikB;@text ds nk;kWa Hkkx ds v{kj dks ns[krs gSaA
tSls =Right(Leeldhar) R
Len ls fdlh ikB~; esa o.kkasZ
dh laq[;k dks fxurs gSaA
tSls =Len(leeladhar) 9
Lower ls fdlh ikB~; dks NksVs
v{kjksa esa cnyrs gSaA
tSls =Lower(LEELADHAR) leeladhar
=Upper ls fdlh ikB~; dks cM+s
v{kjksa esa cnyrss gSaA
tSls =Upper(leeladhar) LEELADHAR
=Mid ls fdlh ikB~; ds chp dk
Hkkx ns[krs gSaA
tSls =MID(Ahmad Abrar Ahmad,6,6) Abrar
File (Alt+F)
ü
New (Ctrl+N):- blds }kjk u;h
[kkyh Work
Sheet dks
fy;k tkrk gSA
ü
Open
(Ctrl+O):- bldk iz;ksx cuh Save File
dks [kksyus ds fy;s djrs gSaA
ü
Close (Ctrl+W):-blds }kjk M.S Excel esa [kqyh Work Sheet dks cUn fd;k
tkrk gSA
ü
Save
(Ctrl+S):- bldk iz;ksx igys ls cuh Save Work Sheet dks Open
djds dqN vkSj dk;Z dks fy[kdj Save fd;k tkrk gSA
ü
Save
As (Alt+F+A):- blds }kjk u;h “khV (work Sheet) dks save
fd;k tkrk gS] rFkk ,d “khV dks dbZ ukeksa ls save dj ldrs gSaA
ü
Save
As Web Page (Alt+F+G):-bldk
iz;ksx fdlh Hkh Sheet dks Web Page ij Save djus ds fy;s djrs gSaA
web Page og
file gksrh
gS] ftldk
Á;ksx ge baVjusV ij djrs gSaA
ü
Save WorkSpace (Alt+F+W):- blds }kjk File
dks Save
fd;k tkrk gSA
ü
File search (Alt+F+H):-blds }kjk M.S Excel
fdlh Hkh File dk uke Mky dj Right
side esa [kqyrk gSA
ü
Permission (Alt+F+M):- ;g Internet ls lEcfU/kr gksrk gSA
ü
Web Page Preview (Alt+F+B):- bldh lg;rk ls Web Page dh
fLFkfr dks ns[kk tk ldrk gSA
ü
Page Setup (Alt+F+U):- bldh lgk;rk ls Page ds pkjksa rjQ [kkyh LFkku dks Set fd;k
tkrk gSA
ftlesa Page dk Margen, Paper size, Portrait ¼yEckbZ½ rFkk Landscape ¼frjNk½
vkfn dks Set fd;k tkrk gSA
ü
Print Area (Alt+F+T):- blds }kjk fdlh Hkh Work sheet ij fd;s x;s dk;Z esa ls dqN dk;Z dk fÁaV fudkyus ds fy;s Print Area dks Set
djrs gSaA Print
fudkyus ij Print Area }kjk Select {ks+= dk gh Print
fudysxkA
ü
Print Preview (Alt+F+V):- bldk Á;ksx ”khV ij fd;s x;s dk;Z dk Print fudkyus ls igys “khV dh fLFkfr vkSj fd;s x;Z dk;Z
dks ns[kk tkrk gSA
ü
Print (Ctrl+P):- bldh lgk;rk ls printer dks computer ls tksM+ dj fd;s x;s dk;Z dk Page ij Print ¼Nkik½ fd;k tkrk gSA
ü
Send (Alt+F+D):- bldh
lgk;rk ls fdlh Hkh Work Sheet dks Email fd;k tkrk gS]
ü
Properties (Alt+F+I):- Properties
esa fy[ks gq;s Docoment
dk Title, Subject, Author, Company Name, Category vkfn dks fy[kk tkrk gSA
ü
Exit
(Alt+F+X/Alt+F4):- Exit ds }kjk M.S Excel dks cUn fd;k tkrk gSA
Edit (Alt+E)
ü
Undo
(Ctrl+Z):- undo ds }kjk
Cut,
Delete gq;h text dks ckil ykus ds fy;s djrs
gSaA vFkkZr gq;h xyrh dks lq/kkjk Hkh tk
ldrk gSA
ü
Repeat (Ctrl+Y):- blds
}kjk Undo fd;s dk;Z dks
ckil yk;k tkrk gSA
ü
Cut
(Ctrl+X):- blds }kjk fdlh
Hkh vad] “kCn ;k
Picture dks Cut djds nwljh txg ij Paste
fd;k tkrk gSA Cut fd;k gqvk Hkkx igys LFkku
ls gV tkrk gSA
ü
Copy
(Ctrl+C) :- Copy ds }kjk fdlh Hkh vad] “kCn ;k Picture
dks dbZ Áfrfyfi;ksa esa ysrs gSa] Copy ds ckn Paste
fd;k tkrk gSA Copy fd;k gqvk Hkkx
igys LFkku Ikj Hkh jgrk gSA
ü
Office Clipboard (Ctrl+F1):- ;g Righ Side esa
[kqyrk gSA blds }kjk vusd Text
dh Copy dj ldrs gSa] vkSj vko”;d Text dks Paste dj ldrs gSaA
ü
Paste
(Ctrl+V):- blds }kjk Cut,
Copy fd;s gq;s Hkkx dks nksckjk izkIr fd;k tk ldrk gSA
rFkk ,d ls vf/kd ckj Hkh izkIr dj ldrs gSaA
ü
Past special (Alt+E+S):- blds }kjk ftl la[;k dh Copy fd tkrh gS] mldk Forumula, Values, Muliply rFkk Divide vkfn dks ns[kk tkrk gSA
ü
Past as Hyperlink (Alt+E+H):- blds }kjk fdlh Hkh Áksxzke esa TkSls & M.S Word, M.S Excel, M.S Powerpoint esa fy[kh gq;h fdlh Hkh QkbZy esa ls fdlh Hkh “kCn dks copy djds Past as Heyperlingk ij fDyd djrs gSa] rks cg “kCn vk tkrk gS
rFkk ml ij Mouse Pointer dks ctrl key ds lkFk nck dj j[kus ls gkFk tSlk
fpUg cusxk vkSj fDyd djus ls cg Flie [kqy tk;sxh ftl File ls ml “kCn dh Copy dh FkhA
ü
Fill (Alt+E+I):-blds }kjk fy[ks gq;s Text dks Down,
Right, Up, Left esa Select fd;s gq;s Column or Row esa fy[kk tkrk gSaA vkSj Series ds }kjk Select fd;s gq;s Columns ;k Rows esa Øekuqlkj vadksa dks
fy[k ldrs gSaA blds fy;s Series esa tkdj Stop Value esa vfUre vad fy[ksaxs] ftl vfUre vad rd gesa
la[;k;sa fy[kuh gSaA
ü
Clear
(Alt+E+A):- blds }kjk Delete dj ldrs
gSaA
ü
Delete
(Alt+E+D):- blds
}kjk Select djds
fdlh Hkh Cells / Row vFkok Columns dks Delete
dj
ldrs gSaA mlesa fy[kk gks ;k u gksA
ü
Delete
Sheet (Alt+E+L):-blds }kjk iwjh Work Sheet dks Delete
dj ldrs gSaA rFkk blls Delete gq;h Qkby ckil ugha vkrh gSA
ü
Move
or Copy Sheet (Alt+E+M):-blds }kjk Work Sheet ij gq;s dk;Z dh u;h Work Sheet dks
cuk;k tkrk gSA vFkkZr Sheet dh Copy gks tkrh gSA
ü
Find(Ctrl+F):-blds }kjk fdlh v{kj] vad ;k ”kCn dks ns[krs gSA
ü
Replace(Ctrl+H):-bldk Á;ksx fdlh
v{kj] vad ;k “kCn dh txg nwljk v{kj] vad ;k “kCn fy[kus ds fy;s fd;k tkrk gSA
ü
Go To (Ctrl+G):- Go
to esa tkdj Special ij fDyd djrs gSa] vkSj
mlesa fy[ks fdlh Hkh Comment, Formulas, Last Cells ij
fDyd djds mlh LFkku ij tk ldrs gSaA vkSj ;g
ml dks Select
ds :Ik esa fn[kk;sxkA
View (Alt+V)
ü
Normal
ü
Page Break Preview (Alt+V+P):- blds }kjk ist ij yxs Break dks gVk;k tkrk gSA vU;Fkk fd;s x;s
dk;Z dk vk/kk gh Print fudyrk
gSA
ü
Task
Pane (Ctrl+F1):- blds }kjk fdlh Hkh
File dks
[kksy ldrs gSaA vkSj New Work Book cuk
ldrs gSaA
ü
Toolbar (Alt+V+T):- blls vusd Ádkj
ds Toolbar
dks fy;k tkrk gSA
ü
Formula
Bar (Alt+V+F):- blds
}kjk Formula Bar
dks yxk;k o gVk;k tkrk gSA blesa fdlh Hkh la[;k esa yxs QkWewyk dks ns[kk tkrk
gSA
ü
Status
Bar (Alt+V+S):- blls
Status Bar dks yxk;k ;k
gVk;k tkrk gSA blesa la[;kvksa dks Select djds mudk Sum, Count, Max, Min, vkSj Average vkfn dks ns[k ldrs gSaA
ü
Header and Footer (Alt+V+H)
Header
esa ist ds Åijh Hkkx ij Page No, Date & time ;k dksbZ uke
vkfn dks fy[kk o
Insert djk;k tk ldrk
gSA ;k blesa ist ds Åijh Hkkx ij vko”;d uksV fy[kk tk ldrk gSA Footer
esa ist ds fupys Hkkx ij Page No, Date & time ;k dksbZ uke
vkfn dks fy[kk o Insert
djk;k tk ldrk gSA vFkok blesa esa ist ds fupys Hkkx ij vko”;d uksV fy[kk
tk ldrk gSA
ü
Comments
(Alf+V+C):- blds }kjk eq[; Metter
dks fy[kdj Nqik ldrs gSaA ftls ,d Point ls ns[k ldrs gSaA ;g Sheet ij cgk¡ gksrk gS] tgk¡ Comment
fy;k tkrk gSA
ü
Custom
Views (Alt+V+V):-
blds }kjk dlZj dks dgha Hkh] fdlh Hkh Cells esa j[kdj fdlh Hkh uke ls Add
dj nsrs gSaA Add Text dks
ns[kus ds fy;s nksckjk ls Custom Views esa tkdj Add uke
dks Select djds show ij fDyd djrs
gSaA
ü
Full
Screen (Alt+V+U):- blls Screen dk
full Size fd;k tkrk gSA
ü
Zoom (Alt+v+Z):- blds }kjk Cells ds lkbt dks
100%, 200%, 75%,
50% RkFkk
vius bPNkuqlkj Size cM+k&NksVk dj ldrs gSaA
Insert
(Alt+I)
ü
Cells (Alt+I+E):-blds }kjk Work Sheet ij fd;s x;s dk;Z ds chp esa [kkyh Cells dks c<+k;k tkrk gSA
blesa fdlh Hkh NqVs gq;s “kCn ;k vadks dks fy[k ldrs gSaA
ü
Rows (Alt+I+R):- blds }kjk Work Sheet ij fd;s x;s dk;Z ds chp esa [kkyh Rows
dks
c<+k;k tk ldrk gSA blesa fdlh Hkh NqVs gq;s “kCn ;k vadks dks fy[k ldrs gSaA
ü
Columns (Alt+I+C):- blds }kjk Work Sheet ij fd;s x;s dk;Z ds chp esa [kkyh Columes dks c<+k;k tkrk gSA blesa
fdlh Hkh NqVs gq;s “kCn ;k vadks dks fy[krs gSaA
ü
Work Sheet (Alt+I+W):- blds }kjk Work Sheet dks c<+k;k tkrk gSA blesa Hkh fdlh Hkh NqV
gq;s ;k cM+s dk;Z dks fy[krs gSaA
ü
Chart (Alt+I+C):-blds }kjk Chart ;k Graph
cuk ldrs
gSaA
ü
Symbal (Alt+I+S):- blds
}kjk fdlh Hkh ist ij dksbZ
word o vkd`fr dks
fy;k tkrk gSA
ü
Page Break (Alt+I+B):-bldh lgk;rk ls
ist dks dbZ Hkkxksa esa foHkkftr fd;k tk ldrk gSA ftl txg gekjk curser gksrk gS] mlh LFkku ls ist YkEckbZ rFkk PkkSM+kbZ
esa foHkkftr gks tkrk gSA
ü
Function (Alt+I+F):-bldk Á;ksx
fofHkUu Ádkj ds Formula ¼lw=ksa dks½ ds Á;ksx ds fy;s djrs gSaA
ü
Name (Alt+I+N):- blds }kjk Cell dk bPNkuqlkj uke fy[krs gSaA RkFkk bldks Formulabar ij Left Side esa ns[kk tkrk
gSA
ü
Comment (Alt+I+M):- blds }kjk eq[; Metter
dks fy[kdj Nqikus ds fy;s djrs gSaA ftls ml LFkku ij Pointer j[kdj ns[k ldrs gSaA ;g Sheet ij
cgk¡ gksrk gS] tgk¡ Comment fy;k tkrk gSA
ü
Picture (Alt+I+P)
Clip Art ds
}kjk Computer esa ls Natureral Picture dks
fy;k tkrk gSA
From File… blds
}kjk Hkh fdlh Hkh Ádkj ds
Walpaper dks
fy;k tkrk gSA tks gekjs dEI;wVj esa Save gksrs gSaA
From Scaner or Camera…ds
}kjk fÁaVj ;k dSejk vFkok Scanner Device dks
CPU ls
tksM+ dj fdlh Hkh Docoment dks Scan djds
Computer
esa Mky ldrs gSaA
Auto Shapes ds
}kjk Computer
esa Save
vkd`fr dks fy;k tkrk gSaA
WordArt …ds }kjk fdlh Hkh ”kCn ;k v{kj dks
fMtkbu esa fy[kk tk ldrk gSaA
Organization Chart ds }kjk fdlh Hkh Save Chart esa
dqN fy[kdj fMtkbZu dh dksbZ
File cuk ldrs gSaA
Chart ds }kjk xzkQ dks cuk;k tkrk gSA
ü
Diagram (Alt+I+G):- blds
}kjk blesa cuh vkd`fr;sa esa fy[kk tk
ldrk gSA
ü
Object (Alt+I+O):- blds }kjk vU; Program
dks Open
djk;k tk ldrk gSA M.S Excel
esa M.S Word, Excel Chart, M.S Powerpoint, Photoshop, Page Maker vkfn
dks Open
djds bu ij dk;Z Hkh dj ldrs gSaA
ü
Hyperlink(Ctrl+K):-blds }kjk fdlh Hkh file dks viuh Qkby esa
tksM+k tk ldrk gSA bl Ikj
Mouse Pointer j[krs
gS] rks gkFk ds tSlk fpUg cu tkrk gS rFkk
fDyd djus ls File [kqy tkrh gSaA
Format (Alt+O)
Cells (Ctrl+1)
§
Aligment:-blesa Marge
ds }kjk dbZ Cells
dks Select djds
,d Cell
esa cnyk tk ldrk gSA vkSj Text
ds }kjk fy[ks gq;s dks fdlh Hkh fMxzh ij ?kqek;k tkrk gSA tSl& 150]
300] 450] 500 ] ;k &150]
&300] &450 &500
§
Font (Alt+O+F / Ctrl+D):- bldk Á;ksx
Font style, Font Size, Colour, Under Line, Effects ,oa Size
pquus ds fy;s djrs gSA
§
Border:- bldk Á;ksx Select Cell esa
Border
ysus ds fy;s fd;k tkrk gSA
§ Patterns:- bldk Á;ksx Select Cell esa color
ysus ds fy;s djrs gSA
ü
Row (Alt+O+R):-
Heilght :- blds }kjk Row dh Å¡pkbZ bPNkuqlkj ys ldrs gSaA AutoFit :- blds }kjk Row dh igyh Å¡pkbZ vk tkrh gSA Hide :- blesa Row dks Nqik;k tkrk gSaA Unhide :- blds }kjk Hide fd;s (fNih) Row dks fn[kk;k tk ldrk gSA
ü
Column (Alt+O+C)
Width :- blds }kjk Column dh yEckbZ dks c<+k;k tkrk gSA Autofit Selection :- blds }kjk cM+h gq;h Column dh yEckbZ dks igys dh YkEckbZ esa yk;k tkrk gSA Hide :- blesa Column dks Nqik;k tkrk
gSA Unhide :- blds }kjk Hide fd;s (fNis) Column dks fn[kk;k tk ldrk
gSA Standard Width :- blds }kjk lHkh Coumn dh YkEckbZ ,d
lkFk c<+ tkrh gSA
ü
Sheet
(Alt+O+H)
Rename :-
blds }kjk Work
Sheet ij mifLFkr “khV Sheet 1, Sheet 2, Sheet
3, dk uke cnyk tkrk
gSA Hide :- blds }kjk
“khV dks Nqik;k tk tkrk gSA Unhide :- blds }kjk Hide (fNih) fd;s “khV dks fn[kk;k tk tkrk gSA Background :- blds
}kjk “khV ij Background vFkkZr “khV Ikj dksbZ Picture dks yxk;k tk tkrk gSA Tab :- blds
}kjk Work
Sheet ij mifLFkr “khV Sheet 1, Sheet 2, Sheet
3, dk Tab Color fd;k tkrk gSA
ü
Auto Formate...(Alt+O+A) :- bldk Á;ksx dbZ dyj
o fMtkbZu okyh Table ysus ds fy;s
djrs gSaA
ü
Conditional Formating (Alt+O+D):-bldk Á;ksx Select fd;s x;s Cell esa Select
word rFkk Number dk color vkSj Font
Style dks ysrs gSaA
ü
Style (Alt+S):- blds }kjk Modify ij fDyd djds Number, Aligment, Font, Border, Patterns,
Protection vkfn dks Select djds Add ds }kjk Worksheet ij ysrs gSaA
Tools (Alt+T)
ü
Spelling (F7):- bldh
lgk;rk ls fdlh spelling vkSj grammar dh xyrh dks lq/kkjk tk ldrk gSA
ü
Research (Alt+Click):- blesa Internet dks Conect djds fdlh Hkh Hkk’kk esa fd;s x;s dk;Z dks fdlh vU;
Hkk’kk esa ifjofRkZr fd;k tk ldrk gSA
ü
Protection (Alt+T+P)
Protect
Sheet :- blds }kjk “khV Ikj iklcMZ
yxk;k tkrk gS fd dksbZ fd;s gq;s dk;Z esa xyrh ;k cnykc u dj nsA
ü
Goal Seek(Alt+T+G
) :- blds }kjk tksM+h x;h la[;k dks cnyk tkrk gSA Set Cell esa ml la[;k dks Selecte djsaxs ftls gesa tksM+uk ;k
?kVkuk gSA vkSj to value esa fy[kk tkuk gS fd ml la[;k fd txg fdruh la[;k ysuh gSA vkSj By Changing Cell esa ml Cell dks Select djrs gSa] ftl cell esa changing djuh gSA
ü
Formula Aditing (Alt+T+U)
Formula
Auditing Mode :- blds }kjk yxs gq;s Formula dks jksdk tkrk gSA
ü
Macro (Alt+T+M)
Record New
Macro :- blds }kjk ,d “khV ds
dk;Z dks nqljh “khV ij ys tkrs gSaA blesa lcls igys dksbZ Hkh “kCn fy[kdj Short key cukrs gSaA fQj “khV ij fdlh Column vkSj row esa dk;Z djrs gSaA blds
ckn nksckjk Macro
esa tkdj Stop djrs gSaA blds ckn nwljh “khV Ikj ctrl ds lkFk ml “kCn dks
nokrs gSa] rks cgh dk;Z nwljh “khV ij mlh Column vkSj mlh Row
esa vk tkrk gSA
ü AutoCorrect
Options (Alt+T+A):- blesa ,d v{kj ls “kCnksa dks tksM+k tkrk gSA rFkk ml
,d v{kj dks fy[k dj Space nsrs gS rks og iwjk “kCn fy[k tkrk gSA
ü
Customize (Alt+T+C):- blds }kjk Menubar dh lsfVax fd tkrh gSA tSls &
Toolbars
:- blds vUrZxr lHkh Vwyckjksa dks ,d&,d djds
,d ckj esa yxk ldrs gSaA vkSj ;gha ls Toolbar dks gVk ldrs gSaA Commands
:- blds }kjk Commands dks mBkdj Menubar ds cjkcj esa j[kk tk ldrk
gS] bu Commands ls menubar [kksys fcuk dk;Z dj ldrs gSaA Options :- blds }kjk Large Icon ds }kjk Icon
dks cM+k fd;k tkrk gSA
ü
Options
(Alt+T+O):- blesa Security }kjk Excel dh File esa Password Mkyk tkrk gSA fd dksbZ Hkh gekjh QkbZy dks u [kksy
ldsA
Data (Alt+D)
ü
Sort (Alt+D+S):- blds }kjk vyx&vyx fy[kh la[;kvksa dks Øe esa
fy[kk tk ldrk gSA vFkkZr fy[kh la[;kvksa dks ?kVrs Øe ;k c<+rs Øe esa lSV fd;k
tkrk gSA
ü
Filter (Alt+D+F):- blesa Autofilter ds }kjk Excel Work Sheet
esa fy[ks gq;s esa ls ,d gh uke ;k ,d gh
la[;k dks filter
fd;k tkrk gSA
ü
Form... (Alt+D+O):- blds }kjk “khV ij fd;s dk;Z dks find next ds
}kjk ,d&,d djds fn[kkrk gSA vkSj blesa New ds }kjk vkxs ds dk;Z dks Hkh
c<+k;k tk ldrk gSA
ü
Subtotal... (Alt+D+B):- blesa cgqr lh
dEiuh ds Proudct
dk Item by Item Amount rFkk Total Amount fudkyk tkrk gSA
ü
Validation (Alt+D+L):- blds }kjk “khV ij fd;s dk;Z dks Select djds le; vkSj fnukad lSV djrs gSaA Allow ls tks Hkh ysuk gS] mldks select
djrs gSA mlh ds vuqlkj vkxs ds minimum vkSj maximum fy[k nsrs gSaA
ü
Text
to Columns (Alt+D+E):-blds }kjk fdlh la[;kvksa esa yxs fpUg ;k fdlh la[;k
dks vyx fd;k tkrk gSA
ü
Group and Outline (Alt+D+G):-blesa Seleat
Column ;k Row dk
group cuk;k tkrk gSA
ü
Import Externat Data (Alt+D+D):- blesa New
web query ds }kjk bUVjusV ist [kqyrk gSA
ü
List (Alt+D+I):- blesa create
list ds }kjk fdlh Hkh Column esa filter
yxk;k tk ldrk gSA
Window (Alt+W)
ü
New Windos (Alt+W+N):- blds }kjk M.S Excel dh
dbZ lkjh
window [kksyh tk ldrh gSA
ü
Arrange (Alt+W+A):- blds }kjk M.S Excel dh
[kksyha lkjh
window ,d lkFk maximize
gks tkrh gSaA
ü
Hide (Alt+W+H):- blds }kjk ”khV dks Nqik;k tk ldrk gSA
ü
Unhide (Alt+W+U):- blds }kjk Nqih “khV dks fn[kk;k tk ldrk gSA
ü
Freeze Panes (Alt+W+F):- bldh lgk;rk ls fdlh Hkh Row o Column dks
,d txg jksdk tk ldrk gSA
|
Operation Shortcut
|
|
|
|
Multiselect
Cells Alt+Left Click
|
|
Del
Row/Col Ctrl+K
|
|
|
|
Go
to Corner Ctrl+.
|
|
Edit
Selected Ctrl+Enter
|
|
Fill
Down
Ctrl+D
|
|
Fill
Right
Ctrl+R
|
|
Copy
Prev Formula Ctrl+’
|
|
Copy
Above Val Ctrl+”
|
|
Sum
Alt+=
|
|
Go
to First Cell
Ctrl+Home Go to Last Cell
|
|
Ctrl+End
Start of
Row Home
|
|
Next
Sheet Ctrl+Page Down
|
|
Next
Workbook Ctrl+F6
|
|
Prev
Workbook Ctrl+Shift+F6
|
|
Prev
Sheet Ctrl+Page Up
|
|
Go
to F5
|
|
Set
Currency Shift+Ctrl+$
|
|
Set
Percent Shift+Ctrl+%
|
|
Set
Number Ctrl+Shift+~
|
|
Set
Date Ctrl+Shift+#
|
|
Insert
Line Br Alt+Enter
|
|
Repeat
Action F4
|
|
Format
Cell Ctrl+1
|
|
Insert
Date Ctrl+; Insert
Time Ctrl+:
|
|
Remove
Border Ctrl+Shift+_ Border
Cells Ctrl+Shift+&
|
|
Select
Cell Group Shift+Cursors
|
Comments
Post a Comment