Insert Menu Microsoft Excel XP

Insert Menu

1. Cells (bZzb CELL, ROW I COLUMN ‡hvM Kiv) t

NB t Spreadsheet Analysis Software (Microsoft Excel) Gi g‡a¨ KvR Kivi mgq A‡bK mgqB bZzb

K‡i Cell, Row I Column ‡hvM Kivi cÖ‡qvRb nq| †h †Kvb Kvi‡b †jLvi g‡a¨ bZzb K‡i Cell, Row I

Column ‡hvM Ki‡Z PvB‡j GB KgvÛ Gi mvnv‡h¨ Zv Kiv m¤¢e| †Kvb wKQy †jLv _vK‡j †mme Cell Gi g‡a¨ bZzb

K‡i Cell, Row I Column ‡hvM Ki‡j KvRwU n‡q‡Q wKbv Zv Lye mn‡RB †evSv hvq| Aciw`‡K K‡qKwU Lvwj

Cell Gi g‡a¨ KvRwU Ki‡j cwieZ©b¸‡jv †evSv hvq bv| ZvB K‡qKwU Row (†iv) Ges Column (Kjvg) Gi g‡a¨

wKQy wj‡L wb‡Pi KvR¸‡jv Kwi|

_ evg cv‡k Cell (†mj) ms‡hvM Kiv t-

_ ‡h Cell wUi evg cv‡k GKwU Cell (†mj) ms‡hvM Kiv cÖ‡qvRb †mB Cell wU Select K‡i

_ Insert Click

_ Cells Click

_ Shift Cell Right Click

_ Ok Click Ki‡jB Cursor ‡h Cell Gi g‡a¨ wQj †mB Cell wU GK Cell Wv‡b P‡j hv‡e Ges evg

cv‡k GKwU Cell ms‡hvM n‡e| GKvwaK Cell Ki‡Z PvB‡j Block/Select Ki‡Z n‡e|

_ Dc‡i Cell (†mj) ms‡hvM Kiv t-

_ ‡h Cell wUi Dc‡ii w`‡K GKwU Cell (†mj) ms‡hvM Kiv cÖ‡qvRb †mB Cell wU Select K‡i

_ Insert Click

_ Cells Click

_ Shift Cell Down Click

_ Ok Click Ki‡jB Cursor ‡h Cell Gi g‡a¨ wQj †mB Cell wU GK Cell wb‡P P‡j hv‡e Ges

Dc‡ii w`‡K GKwU Cell ms‡hvM n‡e| GKvwaK Cell Ki‡Z PvB‡j Block/Select Ki‡Z n‡e|

_ Dc‡ii w`‡K GKwU Row (‡iuv) ms‡hvM Kiv t-

_ ‡h Row wUi Dc‡ii w`‡K GKwU Row (‡iuv) ms‡hvM Kiv cÖ‡qvRb †mB Row (‡iuv) wU‡Z Cursor ‡i‡L

_ Insert Click

_ Cells Click

_ Entire Row Click

_ Ok Click Ki‡jB Cursor ‡h Row (‡iuv) Gi g‡a¨ wQj †mB Row (‡iuv) wU wb‡Pi Row (‡iuv) †Z

P‡j hv‡e Ges Dc‡ii w`‡K GKwU Row (‡iuv) ms‡hvM n‡e| GKvwaK Row (‡iuv) Ki‡Z PvB‡j

Block/Select Ki‡Z n‡e|

_ evg w`‡K GKwU Column (Kjvg) ms‡hvM Kiv t-

_ ‡h Column wUi evg w`‡K GKwU Column (Kjvg) ms‡hvM Kiv cÖ‡qvRb †mB Column (Kjvg)

wU‡Z Cursor ‡i‡L

_ Insert Click

_ Cells Click

_ Entire Column Click

_ Ok Click Ki‡jB Cursor ‡h Column (Kjvg) Gi g‡a¨ wQj †mB Column (Kjvg) wU Wv‡bi

Column (Kjvg) Gi g‡a¨ P‡j hv‡e Ges evg w`‡K GKwU Column (Kjvg) ms‡hvM n‡e| GKvwaK

Column (Kjvg) Ki‡Z PvB‡j Block/Select Ki‡Z n‡e|

2. Rows (GK ev GKvwaK †iv ms‡hvM Kiv) t-

NB t K‡qKwU Row (‡iv) Gi g‡a¨ wKQy †jLv _vK‡j †mme Row (‡iv) †Z bZzb K‡i Row (‡iv) ms‡hvM Ki‡j KvRwU n‡q‡Q wKbv

Zv Lye mn‡RB ‡evSv hvq| Aciw`‡K K‡qKwU Lvwj Row (‡iv) Gi g‡a¨ hw` bZzb K‡i Row (‡iv) ms‡hvM Kiv hvq Zvn‡j †Kvb

cwieZ©b j¶ Kiv hvq bv| ZvB K‡qKwU Row (†iv) Gi g‡a¨ wKQy wj‡L wb‡Pi KvR¸‡jv Kwi|

_ GK ev GKvwaK †h KqwU Row (†iv) ms‡hvM Ki‡Z PvB †mB KqwU Block/Select K‡i

_ Insert Click

_ Row Click Ki‡jB bZzb Row (†iv) ms‡hvM n‡e|

g‡b ivL‡eb, †h KqwU Row (†iv) Block/Select Kiv _vK‡e Zvi wVK Dc‡ii w`‡K wVK ZZwU bZzb Row (†iv)

ms‡hvM n‡e|

3. Columns (GK ev GKvwaK Kjvg ms‡hvM Kiv) t-

NB t K‡qKwU Columns (Kjvg) Gi g‡a¨ wKQy †jLv _vK‡j †mme Columns (Kjvg) Gi g‡a¨ bZzb K‡i Columns

(Kjvg) ms‡hvM Ki‡j KvRwU n‡q‡Q wKbv Zv Lye mn‡RB ‡evSv hvq| Aciw`‡K K‡qKwU Lvwj Columns (Kjvg) Gi

g‡a¨ hw` bZzb K‡i Columns (Kjvg) ms‡hvM Kiv hvq Zvn‡j †Kvb cwieZ©b j¶ Kiv hvq bv| ZvB K‡qKwU Columns

(Kjvg) Gi g‡a¨ wKQy wj‡L wb‡Pi KvR¸‡jv Kwi|

_ GK ev GKvwaK †h KqwU Columns (Kjvg) ms‡hvM Ki‡Z PvB †mB KqwU Block/Select K‡i

_ Insert Click

_ Columns Click Ki‡jB bZzb Columns (Kjvg) ms‡hvM n‡e|

g‡b ivL‡eb, †h KqwU Columns (Kjvg) Block/Select Kiv _vK‡e Zvi wVK evg w`‡K wVK ZZwU bZzb Columns

(Kjvg) ms‡hvM n‡e|

4. Worksheet (bZzb IqvK©kxU ˆZix Kiv) t-

†Lvc N‡ii b¨vq A‡bK Ni m¤^wjZ eo kxU‡K ejv nq Spread Sheet. Excel Gi mywekvj ‡¯cÖWkxUwU‡Z wewfboe

ai‡bi Z_¨ msi¶Y Ges MvwYZK cwiMYbv Kiv hvq|

3. Starting The Excel (G‡·j Pvjy Kiv) t

c~‡e©B Avgiv †R‡bwQ Microsoft EXCEL n‡jv GKwU Windows wfwËK Application Program myZivs

Microsoft EXCEL Gi g‡a¨ cÖ‡ek Kivi Rb¨ cÖ‡gB Operating System Windows Gi Screen

Open G †_‡K cÖ‡qvRbg‡Zv Chart Type Ges Chart Sub-Type Select Ki‡Z n‡e| A_ev GB Dialog

Box Gi g‡a¨B Custom Type Select K‡i Chart Type List ‡_‡K †h †Kvb GKwU Chart Type Gi g‡a¨

Click Ki‡j Wvb cv‡ki N‡i Symple ‡`Lv hv‡e ZLb cQ›`gZ Select K‡i Zvici

_ Next Click K‡i Pv‡U©i cÖ‡qvRbg‡Zv Series in ‡_‡K Row Or Column Select Ki‡Z n‡e| GLv‡b

Avgv‡`i Z_¨¸‡jvi †¶‡Î Rows Select Ki‡j cÖ‡Z¨KwU wel‡qi wfwˇZ wewfboe QvÎ-QvÎx‡`i b¤^i¸‡jv †`Lv

hv‡e| Aciw`‡K Columns Select Ki‡j QvÎ-QvÎxiv cÖ‡Z¨‡K wewfboe wel‡q †h b¤^i †c‡q‡Q Zv GKmv‡_

†`Lv hv‡e| Row Or Column Select Kivi ci

_ Next Click K‡i Chart Title Box G Click K‡i Chart Gi Rb¨ †Kvb bvg w`‡Z PvB‡j Zv wjL‡Z n‡e|

(Avgv‡`i QK Abymv‡i bvg n‡e Student Performance)| wb‡Pi w`‡K Catagory (X) Axis Box Gi

g‡a¨ Click K‡i (X) A¶ eivei †Kvb Z_¨ w`‡Z PvB‡j Zv wjL‡Z n‡e Ges Value (Y) Axis Box Gi

g‡a¨ Click K‡i (Y) A¶ eivei †Kvb Z_¨ w`‡Z PvB‡j Zv wjL‡Z n‡e| (Avgv‡`i QK Abymv‡i GB `yB

A‡¶ †jLv n‡e Subject & Marks)| cieZ©x‡Z

_ Next Click K‡i As New Sheet Select Ki‡j ˆZixK…Z PvU©wU m¤ú~b© bZzb GKwU Worksheet Gi g‡a¨

P‡j hv‡e| Ges QKwenxb ïay Chart wUB Print (wcÖ›U) n‡e| Aciw`‡K As Object in Select Ki‡j

ˆZixK…Z PvU©wU GKwU Object wnmv‡e Av‡Mi gZ Avm‡e| GB c×wZ‡Z ˆZix Ki‡j QKmn ev QKwenxb PvU©

Print (wcÖ›U) n‡e| D‡j−L¨ †h, Chart wU Select Kiv Ae¯’vq Print (wcÖ›U) Ki‡j ïaygvÎ Chart wU

QKwenxb Print (wcÖ›U) n‡e| QKmn Chart wU Print (wcÖ›U) Ki‡Z PvB‡j Q‡Ki Dci Cursor ‡i‡L Print

(wcÖ›U) Ki‡Z n‡e| Chart ‰Zix Kivi ci Design Kivi we¯—vwiZ c×wZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

6. Page Break (c„óv fv½v) t-

NB t Avgiv Rvwb GKwU Worksheet Gi g‡a¨ hLb ‡ekx ‡jLv nq ZLb avivevwnKfv‡e Page (c„óv) ˆZix n‡Z

_v‡K| KvR Kivi mgq A‡bK †¶‡ÎB GKB Page (c„óv) †K wewfboe Page (c„óv) Gi g‡a¨ cÖ‡qvRbg‡Zv Print

Kivi `iKvi nq ZLb †h †Kvb Page Gi ga¨eZ©x †h †Kvb RvqMvq Cursor ‡i‡L

_ Insert Click

_ Page Break Click Ki‡j D³ Page wU †f‡½ `yB fvM n‡q hv‡e Gfv‡e Cursor ivLvi gva¨‡g †h †Kvb

Page ‡K A‡bK¸‡jv As‡k fvM Kiv hvq| cieZ©x‡Z Page Break ‡Zv‡j †`Iqv ev Av‡Mi Ae¯’vq wd‡i

hvIqvi Rb¨ †h Cell Gi g‡a¨ Cursor ‡i‡L Page Break K‡iwQjvg †mB Cell Gi g‡a¨ Cursor ‡i‡L

_ Insert Click

_ Remove Page Break Click Ki‡jB c~e©ve¯’vq wd‡i hv‡e|

7. Function (wnmve Kiv) t-

NB t Spreadsheet Analysis Software (Microsoft Excel) Gi g~j cÖ‡qvMB n‡”Q wewfboe cÖKvi wnmve Kiv|

Function e¨envi K‡i †hvM, we‡qvM, ¸b, fvM BZ¨vw` wewfboe iKg wnmve Lye mn‡RB Kiv hvq| Function e¨envi

K‡i Avgiv †h KvR¸‡jv Ki‡Z cvwi wVK †mB KvR¸‡jvB KeyBoard e¨envi K‡i Kiv hvq| GB `yB c×wZi g‡a¨

KeyBoard e¨envi K‡i KvR KivB DËg| Kvib Function e¨envi K‡i GB KvR¸‡jv Kivi g‡a¨ A‡bK

cÖwZeÜKZv Av‡Q| wnmve Kivi Rb¨ wKQy Z_¨ cÖ‡qvRb nq| wb‡æ ewb©Z Q‡Ki mvnv‡h¨ Avgiv Z_¨¸‡jv wjwce× Kwi|

AvkvKwi Dc‡ii Z_¨¸‡jv wVKg‡Zv w`‡q‡Qb| Avgiv Gevi KeyBoard e¨envi K‡i wewfboe iKg wnmve wkLe|

 

‡hvM t D2 Cell G Cursor ‡i‡L wjL‡Z n‡e =SUM(Start Cell.End Cell)_

Mo t E2 Cell G Cursor ‡i‡L wjL‡Z n‡e =Average(Start Cell.End Cell)_

eo msL¨v t F2 Cell G Cursor ‡i‡L wjL‡Z n‡e =MAX(Start Cell.End Cell)_

‡QvU msL¨vt G2 Cell G Cursor ‡i‡L wjL‡Z n‡e =MIN(Start Cell.End Cell)_

eM©g~j t H2 Cell G Cursor ‡i‡L wjL‡Z n‡e =SQRT(Any One Cell)_

¸b t I2 Cell G Cursor ‡i‡L wjL‡Z n‡e =Cell*Cell*Cell_

fvM t J2 Cell G Cursor ‡i‡L wjL‡Z n‡e =+Cell/Cell_

‡hvM we‡qvM t K2 Cell G Cursor ‡i‡L wjL‡Z n‡e =+Cell+Cell-Cell_

NB t g‡b ivL‡eb wnmve Kivi mgq dzjóc (.) ej‡Z †_‡K Ges Kgv (,) ej‡Z Ges wnmv‡e a‡i †bIqv nq|

_To Copy The Formula (dg©~jv Kwc Kiv) t

NB t Avgiv GZ¶b (A2, B2, C2) GB wZbwU Cell Gi Dci wfwË K‡i D2 Cell ‡_‡K ïi“

K‡i K2 Cell ch©š— AvU cÖKvi dvskb e¨envi K‡i wnmve Kiv wkLjvg| wKš‘ wb‡Pi w`‡K A_©vr (A3–C6) ch©š—

†h bv¤^vi¸‡jv †`Iqv Av‡Q ev Gi wb‡Pi w`‡K hw` AviI A‡bK bv¤^vi †`Iqv _v‡K Z‡e †m¸‡jvi wnmve †ei Kie

wKfv‡e ? wbðqB ej‡eb wb‡Pi¸‡jvI m~Î cÖ‡qvM K‡i †ei Ki‡Z n‡e| wKš‘ bv dg©~jv Kwc Kivi gva¨‡g Avgiv Lye

mn‡RB GB KvRwU Ki‡Z cvwi| GRb¨

D2 Cell ‡_‡K ïi“ K‡i K2 Cell ch©š— Block/Select K‡i Copy Comand cÖ‡qvM Kwi

Zvici D3 Cell ‡_‡K ïi“ K‡i K3 Cell ch©š— ev wb‡Pi w`‡K hw` AviI _v‡K Zvn‡j me¸‡jv GKmv‡_

Block/Select K‡i Paste Comand cÖ‡qvM Kwi| d‡j dg©~jv¸‡jv Copy (Kwc) n‡q me KvR GKmv‡_

m¤úv`b n‡q hv‡e|

8. Name t

-> cÖ‡qvRb †bB|

9. Comment (gše— ¨ Kiv) t-

NB t Avgiv Comment (gš—e¨ Kiv) m¤ú‡K© we¯—vwiZ View Menu ‡Z Av‡jvPbv K‡iwQ| Gi mvnv‡h¨ †Kvb Cell Gi

g‡a¨ Cursor ‡i‡L †h †Kvb wel‡qi Dci gš—e¨ Kiv hvq| GB KvRwU Avgiv Insert Menu ‡_‡KI Ki‡Z cvwi| G wel‡q

GLv‡b Avi Av‡jvPbv Kiv n‡jv bv| hw` g‡b bv _v‡K Z‡e View Menu ‡Z wM‡q †`Lyb, bv cvi‡j wk¶‡Ki mvnvh¨ wbb|

10. To Insert Picture (Qwe Avbv) t

NB t Spreadsheet Analysis Software (Microsoft Excel) Program ïi“ Kivi Av‡M wbðqB Word

Processing Software (Microsoft Word) Program wU K‡i‡Qb| Zvn‡j wbðqB Microsoft Word Gi g‡a¨

Insert Picture (Qwe Avbv), Modify Picture (Qwe ms‡kvab), Movement Picture (Qwe ¯’vbvš—i), Ges Delete

Picture (Qwe †gvQv) BZ¨vw` wk‡L‡Qb e‡j Avgvi wek¦vm| Microsoft Word Gi g‡Zv Microsoft Excel Gi g‡a¨

wewfboe c×wZ‡Z Qwe Avbv hvq| †hgb t

1. Clip Art System 2. From File System 3. Auto Shape System 4. Organization Chart System

5. Word Art System 6. From Scanner Or, Camera System.

D³ c×wZ¸‡jvi mvnv‡h¨ Qwe Avbv hvq| †h c×wZ‡ZB Qwe Avbv †nvK bv †Kb me©`v g‡b ivL‡Z n‡e, †h †Kvb c×wZ‡Z Qwe

Avb‡j Qwe Avbvi ci Qwe‡K ms‡kvab, ¯’vbvš—i Ges †gvQvi c×wZ GKB iKg| hw` bv cv‡ib Z‡e wk¶‡Ki mvnvh¨ wbb|

11. Object (m¤úK© ¯’vcb) t-

_ Insert Click

_ Object Click Ki‡j Object Dialog Box Avm‡e ZLb Gi Aaxb¯’

_ Create New Tab Select K‡i Avgiv †h †Kvb GKwU Object Type Select Kivi gva¨‡g H Object ‡_‡K †Kvb

wKQy Import Ki‡Z cvwi| Gmgq Display As Icon Box G Click Kiv _vK‡j †h Object Type Select Kiv _vK‡e

‡mB Object Gi Icon wU Import n‡e| Aciw`‡K Dialog Box Avmvi ci

_ Create From File Tab Select K‡i Browse Gi gva¨‡g Avgiv Excel ev Ab¨vb¨ Program ‡_‡K ˆZix Kiv

wKQy Import Ki‡Z cvwi| Z‡e GB c×wZ‡Z hvnv Import Kie Zvnv Picture Mode G Import n‡e|

12. Hyperlink (nvBcviwj¼) t

 Bnv Internet (B›Uvi‡bU) Gi Kv‡R e¨envi Kiv nq|