How can you get in Microsoft Excel?
wKfv‡e
Avcwb gvB‡µvmdU G‡·‡j †h‡Z cv‡ib?
Use Mouse
Click Start
Click Programs
Click Microsoft Excel.
Use Keyboard
Control + Esc
Press Up arrow key
Select Programs
Press Up/Down arrow key
Select
Microsoft Excel
Press Enter.
File – bw_cÎ
How can you get in new work
sheet?
wKfv‡e
GKwU bZzb IqvK©kxU ˆZix Kiv nq?
Click file
Click new
Click blank workbook.
How can you open a file?
Click file
Click open
Type the file name
Click open.
How can you close a file?
wKfv‡e
GKwU dvBj eÜ Kiv hvq?
Click file
Click close
Click no.
How can you save a file?
wKfv‡e
GKwU dvBj msiÿb Kiv hvq?
Click file
Clicks save
Type the file name
Clicks save.
How can you save as a file?
msiwÿZ
dvBj‡K wKfv‡e bvg cwieZ©b Kiv hvq?
Click file
Clicks save as
Type the file name
Clicks save.
How to set print Area?
wKfv‡e
wcÖ›U Gwiqv †mU Kiv hvq?
Type anything
Block the text
Click file, Click print area
Select set print area.
How to delete set print Area?
wKfv‡e
wcÖ›U Gwiqv gy‡Q †djv hvq?
Block the text
Click file
Click print area
Click clear print area.
How can you exit from
Microsoft Excel?
wKfv‡e
gvB‡µvmd&U G‡·j †_‡K †ei nIq hvq?
Click file
Click close
Click no
Click file
Click exit.
Edit – m¤úv`b
How to cut a text?
wKfv‡e
GKwU †U·U KvUv hvq?
Type anything
Block the text
Click edit
Click cut.
How to copy a text?
wKfv‡e
ûeû ‡U·U bKj Kiv hvq?
Type anything
Block the text
Click edit
Click copy
Please the cursor put where
you want a past
Click edit
Click past.
How to set series?
wKfv‡e wmwiqvj bv¤^vi †mU Kiv hvq?
Please type 1 and block 1-20
Click edit
Click fill
Click series
Please type stop value 20
Click ok.
View – `„k¨
How to create header &
footer?
wKfv‡e gviwR‡bi Dc‡i Ges wb‡P †jLv
hvq?
Click
View
Click header & footer
Click custom header
Type your header
Click custom footer
Type your footer
Click ok
To see it
Click file
Click print preview
Click Close.
How to delete header &
footer?
wKfv‡e
gviwR‡bi Dc‡i Ges wb‡P †jLv gyQv hvq?
Click
View
Click header & footer
Click custom header
Delete your header
Click custom footer
Delete your footer
Click ok
To see it
Click file
Click print preview
Click Close.
How to create zoom?
Click View
Click zoom
Select any Percent
Click ok.
Insert – ms‡hvRb
How to insert cells?
wKfv‡e
GKwU †mj evov‡bv hvq?
Please the cursor where you
want to insert cells.
Click insert
Click cells
Select shift cells down
Click ok.
How to delete insert cells?
wKfv‡e
GKwU evov‡bv ‡mj gyQv hvq?
Click edit
Click delete
Select shift cells up
Click ok.
How to insert Columns or row?
wKfv‡e
GKwU Kjvg/iæ evov‡bv hvq?
Block
your column or row
Click insert
Click column or row
Click ok.
How to insert function?
wKfv‡e
MvwYwZK mgm¨v mgvavb Kiv hvq?
Type your value
Click insert
Click function
Select function name
Min, max, sum as you need
Click ok.
How to insert worksheet
wKfv‡e
G‡·‡j bZzb GKwU mxU ˆZix Kiv nq?
Click insert
Click worksheet.
How to insert comment?
‡Kvb
†Mvcb Z_¨ wKfv‡e †mU Kiv hvq?
Click insert
Click comment
Type your comment
Click View
Click comment
How to delete comment?
‡Kvb
†Mvcb Z_¨ †mU wKfv‡e gy‡Q †djv hvq?
Click view
Click comment
Click delete.
Format- MVb
How to create conditional
formatting?
wKfv‡e
†Kvb kZ© †mU Kiv hvq?
Type your value
Block the text
Click format
Click conditional formatting
Click between
Select lass then/gather than
Type your value
Click format
Select strikethrough
Click ok
Click again ok.
How can you delete
conditional formatting?
g~jZ
†Kvb WvUvi Dci kZ© †`Iqvi Rb¨ KwÛkbvj di‡gwUs Kiv nq| (e„nËi/ÿz`ªZi)
Block your text
Click format
Click conditional formatting
Click delete
Select Condition 1
Click ok.
Tools – hš¿ we‡kl
How can you protect your
sheet?
wKfv‡e
Avcbvi WKz‡g‡›Ui Dci cvmIqvW© †`qv hvq?
Click tools
Click protection
Click protection sheet
Type your password
Click ok
Again type your password
Click ok.
How can you unprotect sheet?
wKfv‡e
Avcbvi WKz‡g‡›Ui Dci cvmIqvW© gyQv hvq?
Click tools
Click protection
Click unprotect sheet
Type your password
Click ok.
How to create macro?
wKfv‡e
gvB‡µv †iKW© Kiv hvq?
Click tools
Click macro
Click record new macro
Click ok
Now type anything
Click tools.
Goal Speck
g‡b K‡ib iZœv Kw¤úDUvim cÖvt wjt †_‡K wWwR‡UK
eªvÛ Gi GKwU Kw¤úDUvi K…w¯Í‡Z wKb‡eb| †hLv‡b Ab¨Zg kZ©¸‡jv n‡”Q-
1) e‡Kqv UvKvi Dci 10% my`,
2) †gvU g~‡j¨i 40% bM` cwi‡kva,
3) cÖwZgv‡m Avcwb w`‡Z cvi‡eb 5000 UvKv,
4) m‡eŸ©v”P wKw¯Í 12 wU|
GLb Goal Specking Gi mvnv‡h¨ mn‡R †ei Kiv hv‡e KZ
g~‡j¨i Kw¤úDUvi Avcwb wKb‡Z cvi‡eb| GRb¨ wb‡¤§v³ wb‡`©kbv Ae‡jvKb Kiæb|
1. cv‡k¦v©³ wb‡`©kbv ûeû
UvBc Kiæb|
2. c‡q›Uvi ¯’vcb Kiæb
E4 †m‡j|
3. UvBc
Kiæb = D4*0.6
4.
c‡q›Uvi ¯’vcb Kiæb
F4 †m‡j|
5. UvBc
Kiæb = D4*0.4
6.
c‡q›Uvi ¯’vcb Kiæb D8 †m‡j|
7. UvBc
Kiæb = PMT
( B4/12, C4, -E4)
8. Gici G›Uvi w`b|
9. D8 †m‡j c‡q›Uvi ¯’vcb Kiæb Gici
†gby Ack‡b hvb
Click
Tools
Click
Goal Speck
G mg‡q Goal Shake WvqvjM e·wU c`v©q Avm‡e| AZtci
cvk¦©iƒ‡c c~iY Kiæb-
To
value G wjLyb 5000
By
changing cell wjLyb
D4
Gici OK w`b|
Result Sheet
G wm‡U Avcwb ïaygvÎ hviv cvm K‡i‡Q Zv‡`i gvK©¸‡jv
ms‡hvRb Kiæb Gici Zv‡`i djvdj †MÖW/wWwfk‡b †ei Kiæb Avcbvi cixÿv_x©‡`i bvg Ges
welq mg~n wb‡gœiƒ‡c UvBc Kiæb|
 |
djvdj ‡ei Kivi Av‡M me©‡gvU †ei Ki‡Z n‡e ZvB H3 †m‡j c‡q›Uvi ¯’vcb K‡i UvBc Kiæb = SUM(C3:H3) Gici
G›Uvi w`b| d‡j Dc‡ii djvdjwU †`Lv‡e|
djvdj
†ei Kivi Rb¨ Result Gi wb‡Pi N‡i Kvimi ivLyb AZtci
UvBc Kiæb = IF(H3>320,”A”, IF(H3>300,”A-“,
IF(H3>280,”B”, IF(H3<250 span="">
No comments:
Post a Comment