KEMBAR78
Excel 2007 Guide: Open, Save, Print | PDF | Hyperlink | Microsoft Excel
0% found this document useful (0 votes)
35 views34 pages

Excel 2007 Guide: Open, Save, Print

This document provides instructions for opening and using basic functions in Microsoft Excel 2007. It describes how to open a new or existing workbook, save files, cut/copy/paste cells, change font and alignment, and other common Excel tasks. The steps are outlined over 11 pages with screenshots and detailed explanations of functions like formatting, printing, and using the ribbon tabs for home, insert, page layout and more.

Uploaded by

api-731912668
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
35 views34 pages

Excel 2007 Guide: Open, Save, Print

This document provides instructions for opening and using basic functions in Microsoft Excel 2007. It describes how to open a new or existing workbook, save files, cut/copy/paste cells, change font and alignment, and other common Excel tasks. The steps are outlined over 11 pages with screenshots and detailed explanations of functions like formatting, printing, and using the ribbon tabs for home, insert, page layout and more.

Uploaded by

api-731912668
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 34

1 MS OFFICE 2007

EXT NAME - .XLSX

MS EXCEL Open :=>


I) START - ALL PROGRAME - MICROSOFT OFFICE -
MICROSOFT
OFFICE EXCEL 2007
II) START MANU - MICROSOFT OFFICE 2007
III) DOUBLE CLICK ON MICROSOFT EXCEL 2007 IN THE
DESKTOP ICON.

ea¥e Page Open Ll¡l fl Sheet 1, Sheet 2,


Excel 2007
Sheet 3 HC i¡­h ¢ae¢V Sheet ¢e­u open quz HC ¢ae¢V Sheet
­L Bm¡c¡ Bm¡c¡ i¡­h H­LL¢V work Sheet h¡ Tab hm¡ quz
New tab Option Hl j¡dÉ­j B­l¡ Tab h¡ Sheet h¡s¡­e¡ k¡uz
Bh¡l A­eL…¢m Work Sheet ¢e­u HL¢V Work book °al£ quz

Bh¡l HL¢V Work Sheet H 16384 ¢V Columns, 1048576 ¢V


Rows J 17179869184 ¢V Cell B­Rz Columns …¢m A, B, C Hhw
Rows …¢m 1, 2, 3 HC i¡­h e¡j¡¢ˆa b¡­Lz Columns J Rows Hl
e¡j Be¤p¡­l Cell …¢ml e¡j qu ­kje - A1, A2, B1, B2 z

h¤¢Üj¡­el¡ ­L¡e¢LR¥ fËb­j A¿¹l ¢c­u Ae¤ih L­l,


a¡lfl ­p pj­å j¿¹hÉ L­lz Bl ¢e­hÑ¡­dl¡
fËb­jC j¿¹hÉ L­l h­p Hhw f­l ¢Q¿¹¡ L­lz
qkla Bm£ (l¡x)

7797575838 Page - 1 Turn Over


2 MS OFFICE 2007

7797575838 Page - 2 Turn Over


3 MS OFFICE 2007
OFFICE BUTTON
New:-
Screen H ea¥e ­fS h¡ Work Book Be­a q­m
Office Button - New - Blank Work Book.
Short cut key=> Ctrl+N

Open:-
­L¡e ­fS h¡ Written page h¡ Save Ll¡ file Work Book M¤m­a
q­m
Office Button - Open -a¡lfl HLV¡ dialog box Bp­h ­pM¡­e
Navigation Pan ­b­L ­kM¡e ­b­L Open Ll­a Q¡C¢R (Desktop,
Computer Drive, My document) ­p¢V select L­l - Open H Click
Ll­a q­hz
Short cut key=> Ctrl+O

Save:-

7797575838 Page - 3 Turn Over


4 MS OFFICE 2007
­L¡e EXCEL Page h¡ Work Book Save Ll­a q­m
save option H ­k­a q­hz
Office Button - Save - a¡lfl HLV¡ dialog box Bp­h ­pM¡­e
Navigation Pan ­b­L ­kM¡­e Save Ll­a Q¡C¢R (Desktop,
Computer Drive, My document) ­p¢V select L­l e£­Q FileName
Hl Box H ­k e¡­j Save Ll­a Q¡C¢R ­pC e¡j¢V ¢m­M Save H
Click Ll­a q­hz
Short cut key=> Ctrl+S

Save As:-
Save Ll¡ ¢hou¢V­L Edit Ll¡l fl f¤Zl¡u AeÉ ­L¡e e¡­j Save
Ll­a q­m Save As Ll­a q­hz
Office Button - Save As - a¡lfl HLV¡ dialog box Bp­h ­pM¡­e
Navigation Pan ­b­L ­kM¡­e Save Ll­a Q¡C¢R (Desktop,
Computer Drive, My document) ­p¢V select L­l e£­Q FileName
Hl Box H ­k e¡­j Save Ll­a Q¡C¢R ­pC e¡j¢V ¢m­M Save H
Click Ll­a q­hz
Short cut key=> F12

Close :-
haÑj¡­e ­k ­fS h¡ Work Book ¢e­u L¡S Ll¢R a¡
hå Ll¡l SeÉ Close option H ­k­a q­hz
7797575838 Page - 4 Turn Over
5 MS OFFICE 2007
Office Button - Close
Print Preview:-
Print Ll¡l B­N, page Hl ¢eiѨma¡ k¡Q¡C Ll¡l SeÉ
print Preview Ll¡ quz
Office Button – Print - Print Previw.
Print:-
­L¡­e¡ Page Type Ll¡l fl a¡­L print out ­hl Ll¡l SeÉ Print
Option H ­k­a q­hz
Office Button - Print
a¡lfl HLV¡ Dialog Box Bp­h ­pM¡­e Printer Name Select
Ll­a q­hz
Properties H ¢N­u ­fS Select Ll­a q­h (A4)z Orientation
(Portrait
& Landscape) Choose L­l Page Range H ¢N­u All, Current
Abh¡ Pages¢p­mƒ Ll­a q­h Number of Copy Select L­l Ok
Click Ll­a q­hz

7797575838 Page - 5 Turn Over


6 MS OFFICE 2007
HOME

Cut:-
­L¡e wordh¡ object ­L L¡V Ll­a Q¡C­m h¡ h¡c ¢c­a Q¡C­m
cut option H ­k­a q­hz fËb­j ­k AwnV¡ h¡ cell ¢V cut Ll­a
Q¡C¢R ­pC AwnV¡ h¡ cell ¢V Select Ll­a q­hz
Home - Cut H Click Ll­a q­hz
Short cut key=> Ctrl+X
Copy:-
­L¡e word h¡ object ­L Copy Ll­a Q¡C­m h¡ f¤el¡u ¢mM­a
Q¡C­m Copy option H ­k­a q­hz fËb­j ­k AwnV¡ h¡ cell ¢V
Copy Ll­a Q¡C¢R ­pC AwnV¡ h¡ cell ¢V Select Ll­a q­hz
Home - Copy H Click Ll­a q­hz
Short cut key=> Ctrl+C

PASTE: -
­L¡­e¡ CELL h¡ A­eL CELL HL p­‰ COPY h¡ CUT Ll¡l fl
­p¢V­L AeÉ ­L¡e ÙÛ¡­e l¡M¡l SeÉ PASTE H CLICK Ll­a
q­hz
fËb­j ­k CELL h¡ CELL …¢m­L COPY h¡ CUT Ll­a Q¡C¢R ­pC
CELL h¡ CELL …¢m­L SELECT L­l HOME RIBON Hl
CLIPBOARD COMMAND GROUP Hl j­dÉ COPY h¡ CUT
OPTION H CLICK Ll­a q­hz Hlfl ­kM¡­e
PASTE Ll­a Q¡C¢R ­pM¡­e CORSOR
­l­M HOME RIBON Hl CLIPBOARD
COMMAND GROUP Hl j­dÉ PASTE
OPTION H CLICK Ll­a q­hz
HOME - PASTE
Short cut key=> Ctrl+V

7797575838 Page - 6 Turn Over


7 MS OFFICE 2007
EXCEL H PASTE Hl L­uL¢V i¡N B­R ­kje
FORMULAS, PASTE VALUE, TRANSPOSE, PASTE
LINK, PASTE SPACIAL, PASTE AS PICTURE CaÉ¡¢cz

FORMULAS :-
­L¡­e¡ CELL COPY Ll¡l fl ­p¢Vl öd¤ FORMULA PASTE
Ll­a Q¡C a¡q­m HC OPTION H ­k­a q­hz
fËb­j ­k CELL ¢V­L COPY Ll­a Q¡C¢R ­pC CELL ¢V­L
SELECT L­l HOME RIBON Hl CLIPBOARD COMMAND
GROUP Hl j­dÉ COPY OPTION H CLICK Ll­a q­hz Hlfl
­kM¡­e PASTE Ll­a Q¡C¢R ­pM¡­e CORSOR ­l­M HOME
RIBON Hl CLIPBOARD COMMAND GROUP Hl j­dÉ PASTE
OPTION Hl DROP DOWN ARROW ­a CLICK Ll­m HL¢V
LIST ­hl q­h ­pM¡e ­b­L FORMULAS H­a CLICK Ll­a q­hz
PASTE VALUES :-
­L¡­e¡ CELL COPY Ll¡l fl ­p¢Vl
öd¤ VALUE PASTE Ll­a Q¡C a¡q­m
HC OPTION H ­k­a q­hz
COPY Ll¡l fl ­kM¡­e PASTE Ll­a
Q¡C¢R ­pM¡­e CORSOR ­l­M HOME
RIBON Hl CLIPBOARD COMMAND
GROUP Hl j­dÉ PASTE OPTION Hl
DROP DOWN ARROW ­a CLICK Ll­m
HL¢V LIST ­hl q­h ­pM¡e ­b­L PASTE
VALUES H­a CLICK Ll­a q­hz

7797575838 Page - 7 Turn Over


8 MS OFFICE 2007
TRANSPOSE :-
­L¡­e¡ CELL ­L¡­e¡ FORMULA ¢e­cÑn k¢c ROW
hl¡hl b¡­L ­p¢V­L CPOY L­l PASTE Ll¡l pju
COLUMN hl¡hl Ll­a Q¡C a¡q­m HC OPTION H
­k­a q­hz
COPY Ll¡l fl ­kM¡­e PASTE Ll­a Q¡C¢R ­pM¡­e CORSOR
­l­M HOME RIBON Hl CLIPBOARD COMMAND GROUP Hl
j­dÉ PASTE OPTION Hl DROP DOWN ARROW ­a CLICK
Ll­m HL¢V LIST ­hl q­h ­pM¡e ­b­L TRANSPOSE H­a
CLICK Ll­a q­hz
PASTE LINK :-
­L¡­e¡ CELL COPYLl¡l fl k¢c COPY Ll¡ CELL Hl p­‰
LINK L­l PASTE Ll­a Q¡C a¡q­m HC OPTION H ­k­a q­hz
LINK L­l PASTE Ll­m COPY Ll¡ CELL ¢Vl k¡ f¢lhaÑe Ll¡
q­h PASTE Ll¡ CELL ¢Vl a¡ f¢lhaÑe q­hz
COPY Ll¡l fl ­kM¡­e PASTE Ll­a Q¡C¢R ­pM¡­e CORSOR
­l­M HOME RIBON Hl CLIPBOARD COMMAND GROUP Hl
j­dÉ PASTE OPTION Hl DROP DOWN ARROW ­a CLICK
Ll­m HL¢V LIST ­hl q­h ­pM¡e ­b­L PASTE LINK H­a
CLICK Ll­a q­hz
PASTE SPACIAL:-
Hl j¡dÉ­j HLV¡ word Hl p­‰ Link L­l
Paste Ll¡ k¡uz
Home - Paste - Paste Special – Select
any Option – Ok.

7797575838 Page - 8 Turn Over


9 MS OFFICE 2007

AS PICTURE:-
­L¡e CELL Hl ­mM¡­L R¢h BL¡­l COPY h¡ PASTE Ll­a
Q¡C­m HC OPTION H ­k­a q­hz
COPY Ll¡l fl ­kM¡­e PASTE Ll­a Q¡C¢R ­pM¡­e CORSOR
­l­M HOME RIBON Hl CLIPBOARD COMMAND GROUP Hl
j­dÉ PASTE OPTION Hl DROP DOWN ARROW ­a CLICK
Ll­m HL¢V LIST ­hl q­h ­pM¡e ­b­L AS PICTURE Hl SUB
OPTION PASTE AS PICTURE h¡ PASTE PICTURE LINK H­a
CLICK Ll­a q­hz PASTE AS PICTURE SUB OPTION H
CLICK Ll­m öd¤ R¢h BL¡­l PASTE q­h, ­k CELL ¢V COPY
L­l¢R ­p¢Vl ­L¡e ¢LR¥ f¢lhÑae Ll­m PASTE Ll¡ CELL Hl
­L¡e f¢lhÑae q­h e¡z Bl k¢c PASTE PICTURE LINK H
CLICK Ll­m LINK q­u PASTE q­h, ­k CELL ¢V COPY L­l¢R
­p¢Vl ­L¡e ¢LR¥
f¢lhÑae Ll­m PASTE Ll¡ CELL HJ
f¢lhÑae q­hz

Format Painter :-

7797575838 Page - 9 Turn Over


10 MS OFFICE 2007
­L¡e ­mM¡l h¡ cell H ­k ­k style B­R HLC Style
AeÉ ­mM¡u h¡ cell H ¢c­a ­N­m HC Option H ­k­a
q­hz
fËb­j ­k ­mM¡l h¡ cell Hl Style V¡ ¢e­a Q¡C¢R ­pM¡­e h¡ ­pC
cell H Cursor ­l­M Home - Format Painter Click a¡l fl ­kM¡­e
h¡ ­k cell H Style V¡ ¢c­a Q¡C¢R ­pM¡­e ­pC cell H Cursor V¡
Click L­l­a q­hz

Font :-
HC option ­b­L ­mM¡l Style ,Size, Color, Change Ll¡ k¡uz
­k ­L¡e Text ¢m­M Select L­l Home ¢N­u Bold, Italic, Under line,
Strikethrough, Font Size, Style Change Ll­a f¡l¡ k¡uz

7797575838 P a g e - 10 Turn Over


11 MS OFFICE 2007

Align:-
­L¡e Cell Hl ­mM¡ ­L p¡S¡­a ­N­m HC Option H ­k­a
q­hz
fËb­j ­k CELL h¡ CELL …¢m Align Ll­a Q¡C¢R ­p…¢m­L
SELECT L­l HOME RIBON Hl ALIGNMENT COMMAND
GROUP Hl j­dÉ Align Left, Align Right, Align Centre, Hl ­k
­L¡e HL¢V Top Align, Middle Align, Bottom Align Hl ­k ­L¡e
HL¢V Select Ll­a q­hz
WRAP TEXT :-
k¢c ­L¡e CELL Hl j­dÉ ­mM¡ COLUMN WIDTH Hl ­Q­u
­h¢n qu, ­mM¡ ¢V­L k¢c HL¡¢dL LINE H Ll­a Q¡C a¡q­m HC
OPTION H ­k­a q­hz
fËb­j ­k CELL h¡ CELL …¢m WRAP TEXT Ll­a Q¡C¢R
­p…¢m­L SELECT L­l HOME RIBON Hl ALIGNMENT
COMMAND GROUP Hl j­dÉ WRAP TEXT OPTION H CLICK
Ll­a q­hz

MERGE & CENTER :-


A­eL …¢m CELL ­L k¤š² L­l HL¢V
CELL Hhw CENTER ALIGN HL p­‰
Ll¡l SeÉ HC OPTION H ­k­a q­hz
fËb­j ­k CELL …¢m­L MERGE &
CENTER Ll­a Q¡C¢R ­pC …¢m­L
SELECT Ll­a q­hz Hlfl HOME
RIBON Hl ALIGNMENT COMMAND
GROUP Hl j­dÉ MERGE & CENTER
OPTION H CLICK Ll­a q­hz

7797575838 P a g e - 11 Turn Over


12 MS OFFICE 2007
MERGE ACROSS :-
A­eL …¢m CELL ­L öd¤ ROW hl¡hl k¤š² L­l
HL¢V CELL H Ll¡l SeÉ HC OPTION H ­k­a q­hz
fËb­j ­k CELL …¢m­L MERGE ACROSS Ll­a Q¡C¢R
­pC …¢m­L SELECT Ll­a q­hz Hlfl HOME RIBON Hl
ALIGNMENT COMMAND GROUP Hl j­dÉ MERGE & CENTER
OPTION Hl DROP DOWN ARROW ­a CLICK Ll­m HL¢V
LIST ­hl q­h ­pM¡­e MERGE ACROSS OPTION ¢V­a CLICK
Ll­a q­hz
MERGE CELLS :-
A­eL …¢m CELL ­L k¤š² L­l HL¢V CELL H Ll¡l SeÉ
HC OPTION H ­k­a q­hz
fËb­j ­k CELL …¢m­L MERGE CELLS Ll­a Q¡C¢R ­pC
…¢m­L SELECT Ll­a q­hz Hlfl HOME RIBON Hl
ALIGNMENT COMMAND GROUP Hl j­dÉ MERGE & CENTER
OPTION Hl DROP DOWN ARROW ­a CLICK Ll­m HL¢V
LIST ­hl q­h ­pM¡­e MERGE CELLS OPTION ¢V­a CLICK
Ll­a q­hz
UNMERGE CELLS :-
MERGE Ll¡ CELL …¢m­L f¤el¡C ­R¡V ­R¡V CEL H
f¢lZa Ll­a q­m HC OPTION H ­k­a q­hz
fËb­j ­k CELL ­L UNMERGE
Ll­a Q¡C¢R ­pC CELL ­L SELECT
Ll­a q­hz Hlfl HOME RIBON Hl
ALIGNMENT COMMAND GROUP Hl
j­dÉ MERGE & CENTER OPTION Hl
DROP DOWN ARROW ­a CLICK Ll­m
HL¢V LIST ­hl q­h ­pM¡­e UNMERGE
CELLS OPTION ¢V­a CLICK Ll­a q­hz

7797575838 P a g e - 12 Turn Over


13 MS OFFICE 2007
NUMBER :-
­L¡e CELL Hl VALUE ¢V ¢Li¡­h
­cM­a Q¡C¢R ( GENERAL, NUMBER,
CURRENCY, ACCOUNTING,
PERCENTAGE, DATE, TIME CaÉ¡¢c )
­pV¡ ¢WL Ll¡ k¡uz
fËb­j ­k CELL ­L VALUE VIEW CHANGE Ll­a Q¡C¢R
­pC CELL ­L SELECT Ll­a q­hz Hlfl HOME RIBON Hl
NUMBER COMMAND GROUP Hl j­dÉ Ef­ll DROP DOWN
ARROW ­a CLICK Ll­m HL¢V LIST ­hl q­h ­pM¡­e ­k ­L¡e
HL¢V OPTION H CLICK Ll­a q­hz
Style:-
Conditional Formating:-
­L¡e data table H data …¢m­L k¢c ¢h¢iæ j¡e Ae¤k¡u£
¢h¢iæ Color h¡ Formats ¢c­a Q¡C a¡q­m HC Option H ­k­a
q­hz
fËb­j ­k Data Table H Conditional Formating Ll­a Q¡C¢R
­pC Data Table ¢V­L Select Ll­a q­h, a¡lfl Home Ribon
Hl Style Command Group Hl Conditional Formating Sub Option
Hl Drop Down Arrow ­a Click Ll­m HL¢V List ­hl q­h, ­pM¡e
­b­L ­k ­L¡e Condition Select L­l Ok Ll­a q­hz

7797575838 P a g e - 13 Turn Over


14 MS OFFICE 2007
Format as Table:-
­V¢h­ml ¢LR¥ Format HC Option H l­u­Rz ­L¡e
­V¢h­m Auto Format ¢c­a ­N­m HC Option H ­k­a q­hz
fËb­j ­V¢hm¢V­L Select Ll­a q­h a¡lfl Home Ribon
Hl Style Command Group Hl Format as Table Sub Option Hl
Drop Down Arrow ­a Click Ll­m HL¢V List ­hl q­h, ­pM¡e
­b­L ­k ­L¡e HL¢V Style Select L­l Ok Ll­a q­hz
Cell Style:-
CellHl ¢LR¥ Format HC Option H l­u­Rz ­L¡e Cell
Auto Format ¢c­a ­N­m HC Option H ­k­a q­hz
fËb­j Cell ­L Select Ll­a q­h a¡lfl Home Ribon Hl
Style Command Group Hl Cell Style Sub Option Hl Drop Down
Arrow ­a Click Ll­m HL¢V List ­hl q­h, ­pM¡e ­b­L ­k ­L¡e
HL¢V Style Select L­l Ok Ll­a q­hz
Cells:-

Insert:-
Insert Cells:-
­L¡e Work Sheet H HL¢V Cell fË­u¡Se q­m HC Option
H ­k­a q­hz
fËb­j ­kM¡­e Cell Insert Ll­a
Q¡C¢R ­pC Cell ¢V Select L­l Home
Ribon Hl Cells Command Group Hl
j­dÉ Insert Option Hl Sub Option Insert
Cells H Click Ll­m HL¢V Dialog Box
Bp­h ­pM¡­e Shift Cells Right h¡ Shift
Cells Down H Click Ll­a q­hzk¢c
Select Ll¡ Cell ¢V X¡e ¢c­L pl¡­a Q¡C
a¡q­m Shift Cells Right Option H Click
Ll­a q­hz k¢c Select Ll¡ Cell ¢V e£­Ql

7797575838 P a g e - 14 Turn Over


15 MS OFFICE 2007
¢c­L pl¡­a Q¡C a¡q­m Shift Cells Down
Option H Click Ll­a q­hz
Insert Sheet Rows:-
­L¡e Data Type Ll¡l pju k¢c X¡V¡ V¡C­fl j¡­T ­L¡e Row
fË­u¡Se qu a¡q­m HC Option H ­k­a q­hz
fËb­j ­kM¡­e Row fË­u¡Se ­pC Row Hl e£­Ql Row Hl
­k ­L¡e HL¢V Cell Select L­l Home Ribon Hl Cells Command
Group Hl j­dÉ Insert Option Hl Sub Option Insert Sheet Rows
H Click Ll­a q­hz a¡q­mC Row Insert q­u k¡­hz
Insert Sheet Columns :-
­L¡e Data Type Ll¡l pju k¢c X¡V¡ V¡C­fl j¡­T ­L¡e Cloumn
fË­u¡Se qu a¡q­m HC Option H ­k­a q­hz
fËb­j ­kM¡­e Cloumn fË­u¡Se ­pC Column Hl X¡e ¢c­Ll
Cloumn Hl ­k ­L¡e HL¢V Cell Select L­l Home Ribon Hl
Cells Command Group Hl j­dÉ Insert Option Hl Sub Option
Insert Sheet Cloumns H Click Ll­a q­hz a¡q­mC Cloumn
Insert q­u k¡­hz
Insert Sheets :-
kMe fËbj Excel Sheet Open Ll¡ qu aMe ¢ae¢V Work
Sheet b¡­Lz a¡lfl ¢e­Sl fË­u¡Se j­a¡ Work Sheet Insert Ll¡
k¡uz k¢c ­L¡e Work Sheet Be­a Q¡C a¡q­m HC Option H
­k­a q­hz
Home Ribon Hl Cells Command Group Hl j­dÉ Insert
Option Hl Sub Option Insert Sheets H Click Ll­a q­hz
a¡q­mC Work Sheet Insert q­u k¡­hz Abh¡ e£­Ql ¢c­L Sheet1,
Sheet2, Sheet3 ­mM¡l L¡­R HC ¢Qq²­a Click Ll­mC ea¥e Work
Sheet Insert q­u k¡­hz

7797575838 P a g e - 15 Turn Over


16 MS OFFICE 2007
Delete:-
Delete Cells:-
­L¡e Work Sheet H HL¢V Cell Delete Ll­a q­m HC
Option H ­k­a q­hz
fËb­j ­k Cell ¢V Delete Ll­a Q¡C¢R ­pC Cell ¢V Select
L­l Home Ribon Hl Cells Command Group Hl j­dÉ Delete
Option Hl Sub Option Delete Cells H Click Ll­m HL¢V Dialog
Box Bp­h ­pM¡­e Shift Cells Left h¡ Shift Cells Up H Click
Ll­a q­hz k¢c Select Ll¡ Cell ¢V Delete Ll¡l fl ­pC ÙÛ¡­e
X¡e ¢c­Ll Cell ¢V Be­a Q¡C a¡q­m Shift Cells Left Option H
Click Ll­a q­hz k¢c Select Ll¡ Cell ¢V Delete Ll¡l fl ­pC
ÙÛ¡­e e£­Ql ¢c­Ll Cell ¢V Be­a Q¡C a¡q­m Shift Cells Up
Option H Click Ll­a q­hz
Delete Sheet Rows:-
­L¡e Data Type Ll¡l pju k¢c X¡V¡ V¡C­fl j¡­T ­L¡e
Row Delete Ll¡l fË­u¡Se qu a¡q­m HC Option H ­k­a q­hz
fËb­j ­k Row Delete Ll¡ fË­u¡Se ­pC Row Hl ­k ­L¡e
HL¢V Cell Select L­l Home Ribon Hl Cells Command Group
Hl j­dÉ Delete Option Hl Sub Option Delete Sheet Rows H
Click Ll­a q­hz a¡q­mC Row Delete q­u k¡­hz
Delete Sheet Columns :-
­L¡e Data Type Ll¡l pju k¢c X¡V¡ V¡C­fl j¡­T ­L¡e
Cloumn Delete Ll¡l fË­u¡Se qu a¡q­m HC Option H ­k­a
q­hz
fËb­j ­k Cloumn Delete Ll¡
fË­u¡Se ­pC Cloumn Hl ­k ­L¡e HL¢V
Cell Select L­l Home Ribon Hl Cells
Command Group Hl j­dÉ Delete Option
Hl Sub Option Delete Sheet Cloumns H
Click Ll­a q­hz a¡q­mC Cloumn
Delete q­u k¡­hz

7797575838 P a g e - 16 Turn Over


17 MS OFFICE 2007
Delete Sheets :-
kMe fËbj Ll¡ qu aMe
Excel Sheet Open
¢ae¢V Work Sheet b¡­Lz a¡lfl ¢e­Sl fË­u¡Se
j­a¡ Work Sheet Delete Ll¡ k¡uz k¢c ­L¡e Work
Sheet Delete Ll­a Q¡C a¡q­m HC Option H ­k­a
q­hz
Home Ribon Hl Cells Command Group Hl j­dÉ Delete
Option Hl Sub Option Delete Sheets H Click Ll­a q­hz
a¡q­mC Work Sheet Delete q­u k¡­hz Abh¡ e£­Ql ¢c­L
Sheet1, Sheet2, Sheet3 ­mM¡l Jfs Right Click L­l Delete H
Click Ll­mC ea¥e Work Sheet ¢V Delete q­u k¡­hz

Format:-
Cell Size:-
Row Highth¡ Column Width h¡s¡­e¡ h¡ Lj¡­e¡l SeÉ HC
Option H ­k­a q­hz
Row Hight:-
fËb­j ­k Row h¡ Row …¢ml Hight h¡s¡­a h¡ Lj¡­a
Q¡C¢R ­p …¢m­L Select L­l, Home Ribon Hl Cells Command
Group Hl j­dÉ Format Option Hl Drop Down Arrow ­a Click
Ll­m HL¢V List ­hl q­h, ­pM¡e ­b­L Row Hight h¡s¡­e¡ h¡
Lj¡­e¡l SeÉ Row Hight H Click Ll­m HL¢V Dialog Box Bp­h
­pM¡­e LaV¡ Lj¡­a h¡ h¡s¡­a Q¡C¢R a¡ ¢m­M ¢c­u Ok H­a
Click Ll­a q­hz Bh¡l k¢c Row Hight ­mM¡ Ae¤k¡u£ Auto Fit
Ll­a Q¡C a¡q­m Auto Fit Row Hight H Click Ll­a q­hz Abh¡
Row Heading H Dobule Click Ll­a q­hz

Column Width:-

7797575838 P a g e - 17 Turn Over


18 MS OFFICE 2007
fËb­j ­k Column h¡ Column …¢ml Width h¡s¡­a
h¡ Lj¡­a Q¡C¢R ­p …¢m­L Select L­l, Home Ribon
Hl Cells Command Group Hl j­dÉ Format Option Hl Drop
Down Arrow ­a Click Ll­m HL¢V List ­hl q­h, ­pM¡e ­b­L
Column Width h¡s¡­e¡ h¡ Lj¡­e¡l SeÉ Column Width H Click
Ll­m HL¢V Dialog Box Bp­h ­pM¡­e LaV¡ Lj¡­a h¡ h¡s¡­a
Q¡C¢R a¡ ¢m­M ¢c­u Ok H­a Click Ll­a q­hz Bh¡l k¢c
Column Width ­mM¡ Ae¤k¡u£ Auto Fit Ll­a Q¡C a¡q­m Auto Fit
Column Width H Click Ll­a q­hz Abh¡ Column Heading Hl
X¡e f¡­n Dobule Click Ll­a q­hz
Visibility:-
HC Option Hl p¡q¡­kÉ Row, Column, Work Sheet Hide h¡
Unhide Ll¡ k¡uz
fËb­j ­k Row, Column h¡ Work Sheet Hide Ll­a Q¡C ­p¢V
Select L­l, Home Ribon Hl Cells Command Group Hl j­dÉ
Format Option Hl Drop Down Arrow ­a Click Ll­m HL¢V List
­hl q­h, ­pM¡­e Visibility Hl j­dÉ Hide & Unhide Option H
Click Ll­m Bh¡l HL¢V List ­hl q­h, ­pM¡e ­b­L Hide Row,
Hide Column h¡ Hide Sheet Sub Opyion H Click Ll­a q­hz
Unhide Ll­a ­N­m a¡lC e£­Q Unhide Row, Unhide Column h¡
Unhide Sheet Sub Opyion H Click Ll­a q­hz
Abh¡ Short Cut H Row Heading, Column Heading h¡
Sheet Tab Hl Jfl Right Click L­lJ Hide h¡ Unhide Ll¡ k¡uz

Organize Sheets:-
HC Option Hl p¡q¡­kÉ Sheet Tab
Hl e¡j f¢lhÑae (Rename Sheet) Work
Sheet ­L Move h¡ Copy Ll¡ h¡ Sheet
Tab Color Ll¡ k¡uz

fËb­j ­k Work Sheet ¢Vl e¡j


f¢lhÑae h¡ Move h¡ Copy h¡ Sheet Tab
Color Ll­a Q¡C¢R ­pC Work Sheet ¢V

7797575838 P a g e - 18 Turn Over


19 MS OFFICE 2007
Select L­l, Home Ribon Hl Cells
Command Group Hl j­dÉ Format Option
Hl Drop Down Arrow ­a Click Ll­m
HL¢V List ­hl q­h, ­pM¡­e Organize
Sheets Hl j­dÉ ¢ae¢V Option B­R Rename Sheet, Move Or
Copy Sheet, Tab Color. k¢c Rename Ll­a Q¡C a¡q­m Rename
Sheet Option H Click L­l e¡j f¢lhÑae Ll­a q­hz k¢c Move
Or Copy Ll­a Q¡C a¡q­m Move Or Copy Sheet Option H Click
L­l Move Or Copy Ll­a q­hz k¢c Tab Color ¢c­a Q¡C
a¡q­m Tab Color Option H Click L­l ­k ­L¡e HL¢V Color H
Click Ll­a q­hz
Abh¡ Work Sheet Hl e£­Q Sheet Tab Jfl Right Click
L­lJ Rename Sheet, Move Or Copy Sheet, Tab Color Ll¡ k¡uz
Editing:-
Auto Sum:-
HC Option Hl p¡q¡­kÉ ­k¡N, Ns, jÉ¡¢„j¡j, ¢j¢ej¡j CaÉ¡¢c
¢qp¡h S¡a£u L¡S Ll¡ k¡uz
fËb­j ­k Cell …¢m ­k¡N, Ns, jÉ¡¢„j¡j, ¢j¢ej¡j CaÉ¡¢c
Calculate Ll­a Q¡C¢R ­pC Cell …¢ml X¡e h¡ e£­Ql Cell H
Corsur ­l­M, Home Ribon Hl Editing Command Group Hl Auto
Sum Option Hl Drop Down Arrow ­a Click L­l ­k Formula V¡
Calculate Ll­a Q¡C¢R ­p¢V Select Ll­m Cell H­a Formula V¡
Paste q­u k¡­h a¡lfl Enter ¢c­mC Calculate q­u k¡­hz

Fill:-
HL p­‰ A­eL …¢m Cell H ­L¡e
Data Fill Ll¡l SeÉ HC Option H ­k­a
q­hz

7797575838 P a g e - 19 Turn Over


20 MS OFFICE 2007
Down / Right / Up / Left :-
­L¡e HLC Data A­eL …¢m Cell H
¢gm Ll¡ k¡uz
fËb­j ­k ­L¡e HL¢V Cell H ¢LR¥ ¢m­M ­pC
Cell ¢V p­ja kaM¡e¡ ¢gm Ll­a Q¡C¢R aaV¡ Select L­l,
Home Ribon Hl Editing Command Group Hl Fill Option Hl
Drop Down Arrow ­a Click L­l Down, Right, Up, Left H…¢ml
j­dÉ ­k¢V fË­u¡Se ­p¢V­a Click Ll­a q­hz

Series:-
Serial Ae¤k¡u£ ­L¡e eð¡l ¢gm Ll¡l SeÉ HC Option H
­k­a q­hz
k¢c 1 ­b­L 100 ¢mM­a Q¡C a¡q­m fËb­j Work Sheet H
HL¢V Cell H 1 ¢m­M Cell ¢V­L Select L­l Home Ribon Hl
Editing Command Group Hl Fill Option Hl Drop Down Arrow ­a
Click L­l Series Sub Option H Click Ll­a q­h a¡q­m HL¢V
Dialog Box Bp­h ­pM¡­e Row hl¡hl e¡ Column hl¡hl Series
Ll­a Q¡C¢R ­p¢V Select Ll­a q­h a¡lfl e£­Q Step Value Hl
Box H 1 ¢m­M Hhw Stop value Hl Box H 100 ¢m­M Ok
Ll­a q­hz a¡q­mC 1 ­b­L 100 ­mM¡ q­u k¡­hz

Clear:-
Clear all:-
­L¡e Hl ­L¡e ­mM¡ J ­mM¡l Formats (Bold,
Cell Italik,
underline CaÉ¡¢c) ­j¡R¡l SeÉ HC Option H ­k­a q­hz
fËb­j ­k Cell ¢Vl h¡ Cell …¢ml
­mM¡ J ­mM¡l Formats Clear Ll­a
Q¡C¢R ­pC Cell ¢V Select L­l, Home
Ribon Hl Editing Command Group Hl
Clear Option Hl Drop Down Arrow ­a
Click Ll­m HL¢V List ­hl q­h ­pM¡­e
Clear All Sub Option H Click Ll­m ph
j¤­R k¡­hz
7797575838 P a g e - 20 Turn Over
21 MS OFFICE 2007
Clear Formats:-
­L¡e Hl öd¤ ­mM¡l Formats (Bold, Italik,
Cell
underline CaÉ¡¢c) ­j¡R¡l SeÉ HC Option H ­k­a q­hz
fËb­j ­k Cell ¢Vl h¡ Cell …¢ml ­mM¡l Formats Clear
Ll­a Q¡C¢R ­pC Cell ¢V Select L­l, Home Ribon Hl Editing
Command Group Hl Clear Option Hl Drop Down Arrow ­a
Click Ll­m HL¢V List ­hl q­h ­pM¡­e Clear Formats Sub Option
H Click Ll­m ­mM¡l Formats j¤­R k¡­hz
Clear Contents:-
­L¡e Cell Hl öd¤ ­mM¡ ­j¡R¡l SeÉ HC Option H ­k­a
q­hz
fËb­j ­k Cell ¢Vl h¡ Cell …¢ml ­mM¡ Clear Ll­a Q¡C¢R
­pC Cell ¢V Select L­l, Home Ribon Hl Editing Command
Group Hl Clear Option Hl Drop Down Arrow ­a Click Ll­m
HL¢V List ­hl q­h ­pM¡­e Clear Contents Sub Option H Click
Ll­m ph ­mM¡ j¤­R k¡­hz
Clear Comments:-
­L¡e Cell Hl Comments ­j¡R¡l SeÉ HC Option H ­k­a
q­hz
fËb­j ­k Cell ¢Vl h¡ Cell …¢ml Comments Clear Ll­a
Q¡C¢R ­pC Cell ¢V Select L­l, Home Ribon Hl Editing
Command Group Hl Clear Option Hl Drop Down Arrow ­a
Click Ll­m HL¢V List ­hl q­h ­pM¡­e Clear Comments Sub
Option H Click Ll­m Comments j¤­R k¡­hz

Sort & Filter :-

­V¢h­m °al£ ¢hou hÙ¹¥ A ­b­L Z


h¡ Z ­b­L A Abh¡ 1 ­b­L 100 h¡ 100
­b­L 1 HC i¡­h ­L¡e e¡j h¡ e¡ð¡l
p¡S¡­a q­m Sort & Filter Option H ­k­a
q­hz
7797575838 P a g e - 21 Turn Over
22 MS OFFICE 2007
fËb­j HL¢V X¡V¡ ­V¢hm °al£ L­l ­V¢hm¢Vl ­k
Column H Short Ll­a Q¡C¢R ­pC Column Heading Cell
H Corsur ­l­M Home Ribon Hl Editing Command Group Hl
Sort & Filter Option Hl Drop Down Arrow ­a Click Ll­m HL¢V
List ­hl q­h ­pM¡­e Short A to Z Abh¡ Short Z to A Sub Option
H Click Ll­a q­hz
Bh¡l Filter ­L¡l­a ­N­m, fËb­j HL¢V X¡V¡ ­V¢hm °al£
L­l ­V¢hm¢Vl ­k ­L¡e Column Heading Cell H Corsur ­l­M
Home Ribon Hl Editing Command Group Hl Sort & Filter Option
Hl Drop Down Arrow ­a Click Ll­m HL¢V List ­hl q­h ­pM¡­e
Filter Sub Option H Click Ll­a q­hz a¡q­m fË¢a¢V Column
Heading Cell HL¢V L­l Drop Down Arrow °al£ q­h ­pC Drop
Down Arrow ­a Click L­l Short h¡ Filter Ll¡ k¡uz

INSERT

Picture :-
k¢c Page H ­L¡e Save Ll¡ Picture Be­a Q¡C a¡q­m
Picture Option H ­k­a q­hz

7797575838 P a g e - 22 Turn Over


23 MS OFFICE 2007

Hl Illustrations Command Group Hl Picture


Insert Ribon
Option H Click Ll­m HL¢V Dialog Box Bp­h ­pM¡­e
Navigation Pan H ­kM¡e ­b­L Picture Insert Ll­a Q¡C¢R
(Desktop, Computer Drive, My document) ­p¢V select L­l -
Insert H Click Ll­a q­hz

Picture Format :-
Picture insert Ll¡l fl Format e¡­j Tab H­p k¡­h a¡l
fl Picture Hl pjÙ¹ L¡S I Tab ­b­L q­hz

Adjust :-
HM¡e ­b­L Page H Be¡ Picture ¢Vl
Brightness, Contrast, Compress CaÉ¡¢c
Change Ll¡ k¡uz
Brightness :-
picture ¢Vl Brightness h¡s¡­e¡ h¡

7797575838 P a g e - 23 Turn Over


24 MS OFFICE 2007
Lj¡­e¡l SeÉ HC option H ­k­a q­hz

Contrast :-
¢Vl Contrast h¡s¡­e¡ h¡ Lj¡­e¡l SeÉ HC
picture
option H ­k­a q­hz
Recolor :-
picture ¢Vl Color Change Ll¡l SeÉ HC option H ­k­a
q­hz
Change Picture :-
Page ­a ­k R¢h¢V B­R a¡l f¢lh­aÑ AeÉ ­L¡e R¢h
Be­a q­m HC option H ­k­a q­hz
select the picture(R¢h ¢Vl Jfl Click Ll­mC Select q­u
k¡­hz)
Format - Adjust - Change Picture ­k ­L¡e HL¢V Picture
Select L­l Insert H Click.
Picture Style :-
­f­S Be¡ ­L¡e R¢hl Style Change Ll­a q­m HC
option H ­k­a q­hz
select the picture(R¢h¢Vl Jfl Click Ll­mC Select q­u
k¡­hz)
Format - Picture Style (HM¡­e ¢LR¥ Auto Style ­cJu¡ B­R
­k ­L¡e HL¢V­a Click Ll­a q­hz)
Picture Shape :-
HC option H ¢LR¥ Shape ­cJu¡
A¡­R ­pC Shape …¢ml Hl BL¡­l
Picture ¢Vl BL¡l ­cJu¡ k¡uz
select the picture(R¢h¢Vl Jfl Click
Ll­mC Select q­u k¡­hz)
Format - Picture Shape (HM¡­e ¢LR¥ Shape
­cJu¡ B­R ­k ­L¡e HL¢V­a Click Ll­a
q­hz)

7797575838 P a g e - 24 Turn Over


25 MS OFFICE 2007
Picture Border :-
­f­S Be¡ ­L¡e R¢h­a k¢c Hhw
OutSide Border
­pC Border Color, Border Width, Boarder Style ¢c­a Q¡C
a¡q­m HC Option H ­k­a q­hz
select the picture(R¢h¢Vl Jfl Click Ll­mC Select q­u
k¡­hz)
Format - Picture Border (­k ­L¡e Color, width, Dashes
Select Ll­a q­hz
Picture Effects :-
­f­S Be¡ ­L¡e R¢h­a k¢c ­L¡e Effects ¢c­a Q¡C a¡q­m
HC Option H ­k­a q­hz
select the picture(R¢h¢Vl Jfl Click Ll­mC Select q­u
k¡­hz)
Format - Choose Any Effects
Arrange :-
Rotate :-
k¢c ­f­S Be¡ ­L¡e R¢h­L ­O¡l¡­a (Rotate) Q¡C a¡q­m HC
Option H ­k­a q­hz
select the picture(R¢h¢Vl Jfl Click Ll­mC Select q­u k¡­hz)
Format - Rotate ­k ­L¡e Option Select L­l¡z
Crop :-
­L¡e R¢h­L k¢c ­L­V h¡c ¢c­u ­R¡V Ll­a Q¡C a¡q­m HC
Option H ­k­a q­hz
select the picture(R¢h¢Vl Jfl Click Ll­mC Select q­u k¡­hz)
Format - Crop R¢h¢Vl Jfl HL lL­jl ¢Qq² Bp­h ­pM¡­e Click
L­l ­V­e ­R¡V L­l kaV¥L¥ Awn L¡V­a Q¡C¢R aaV¡ ¢e­u Bphz
a¡q­mC Crop q­u k¡­hz
Hight & Width :-
R¢h¢Vl mð¡ J QJs¡ Lj¡­a J
h¡s¡­a Q¡C­m HC Option H ­k­a q­hz
select the picture(R¢h¢Vl Jfl Click
Ll­mC Select q­u k¡­hz)
Format - Height & Width kaV¡ mð¡ J
QJs¡ Lj¡­a h¡ h¡s¡­a Q¡C¢R aaV¡ Llhz

7797575838 P a g e - 25 Turn Over


26 MS OFFICE 2007
Clip Art:-
k¢c Page H ­L¡e Cartoon Picture Be­a Q¡C,
a¡q­m Clip Art option H ­k­a q­hz
Insert - Clip Art -Organize Clip - Doble Click to Office
Collection (Choose Clip Art ) - Right Click to Clip Art - Copy -
Minimize Right Click - Paste.
Clip art Picture Format :-
ClipArt Picture insert Ll¡l fl Format e¡­j Ribon H­p
k¡­h a¡l fl Clip Art PictureHl pjÙ¹ L¡S I Ribon ­b­L
q­hzHl ­r­œ picture Hl ja pjÙ¹ ¢LR¥C HLz

Shapes :-
­k ­L¡e lL­jl Shape Page H Be­a q­m Shapes Option
H ­k­a q­hz
Insert Ribon Hl Illustrations Command Group Hl Shapes
Option Hl Drop Down H Click Ll­m HL¢V List Bp­h ­pM¡­e
­k ­L¡e HL¢V (line. rectangal, oval, text box, arrow CaÉ¡¢c)
select L­l ­f­S­a Click L­l V¡e­a q­hz a¡q­m ­pC Shape
¢V ­f­S BLy¡ q­u k¡­hz
Shape Format :-
Shape insert Ll¡l fl Format e¡­j Ribon H­p k¡­h a¡l
fl Shape Hl pjÙ¹ L¡S I Ribon ­b­L q­hz
Hl ­r­œ picture Hl ja pjÙ¹ ¢LR¥C HL öd¤ j¡œ Group
& Ungroup option ¢ae¢V B­Rz a¡ ¢e­Q ­cJu¡ qmz
Change Shape :-
Hl j¡dÉ­j ­f­S ByL¡ ­L¡e Shape ­L
Change Ll¡ k¡uz
select the Shape (Shape ¢Vl Jfl
Click Ll­mC Select q­u k¡­hz) Change
Shape ­k ­L¡e HL¢V Shape - Choose
Llz
­kje ­L¡e Rectangal ­L Oval Ll­a
q­mz

7797575838 P a g e - 26 Turn Over


27 MS OFFICE 2007
Shape Fill :-
­L¡e ShapeHl j­dÉ Color, Picture, Gradient,
Texture, Partarn CaÉ¡¢c ­cJu¡l SeÉ H Option ­k­a q­hz
select the Shape (Shape ¢Vl Jfl Click Ll­mC Select
q­u k¡­hz)
Format - Shape Fill ­k ­L¡e HL¢V (Color, Picture, Gradient,
Texture, Partarn) Select Ll­a q­hz

Shadow Effects :-
­L¡e Shape Hl R¡u¡ f­s­R Hje Style ¢c­a q­m H
Option ­k­a q­hz
select the Shape (R¢h¢Vl Jfl Click Ll­mC Select q­u
k¡­hz)
Format - Shadow Effects ­k ­L¡e HL¢V Style Select Ll­a
q­hz
Shadow Effects H ¢c­a q­m Shadow Effect Hl
Color
¢e­Ql ¢c­L Shadow Effects Color Option B­R ­pM¡e ­b­L Color
Select Ll­a q­hz

3-D Effects :-
­L¡e ShapeHl 3-D Style ¢c­a q­m H Option ­k­a q­hz
select the Shape (R¢h¢Vl Jfl Click Ll­mC Select q­u k¡­hz)
Format - 3-D Effects ­k ­L¡e HL¢V Style Select Ll­a q­hz
3-D Effects H Color ¢c­a q­m 3-D Effects Hl ¢e­Ql ¢c­L 3-D
Effects Color Option B­R ­pM¡e ­b­L Color Select Ll­a q­hz

Smart Art :-
hwn f¢”L¡ h¡ ­L¡e ­L¡Çf¡¢el
Bä¡­l ­L¡e Branch Ll­a q­m Smart Art
Option H ­k­a q­hz
Insert Ribon Hl Illustrations Command
Group Hl Smart Arts Option H Click Ll­m
HL¢V Dialog Box Bp­h ­pM¡­e ­b­L HL¢V
Style select L­l - OK H Click Ll­a q­hz

7797575838 P a g e - 27 Turn Over


28 MS OFFICE 2007
Ll¡l fl Design & Format e¡­j
Smart Art Insert
c¤¢V Ribon H­p k¡­hz ­pM¡e ­b­L Hl pjÙ¹ L¡S q­hz
Design :-

Hl j­dÉ B­R Creat Graphic, Layouts, Smart Art Style CaÉ¡¢c


Ll¡ k¡uz
Creat Graphic:-
Add Shape :-
­k Style Hl L­l¢R a¡l SubShape Insert
Smart Art Insert
Ll¡l SeÉ HC Option ­k­a q­hz ­k Shape Hl Under H Sub
Shape ¢e­a Q¡C¢R a¡­a cursor ­l­M a¡l fl
Design - Add Shape a¡l fl ( Add Shape After,Before,
Above, Below, Asistance) ­k­L¡e HL¢V Select Ll­a q­hz
Layout :-
Hl j­dÉ ¢h¢iæ dl­el Design h¡ Shape B­R a¡ ­cJu¡
k¡uz
Design - Layouts - ­k ­L¡e HL¢V Layouts Choose Llz
Change Color :-
HC Option Hl j¡dÉ­j Bjl¡ Smart Art Hl Shape ¢h¢iæ
Color ¢c­a h¡ Change Ll­a f¡¢lz
Design - Change Color ­k ­L¡e HL¢V Color Select Llz
Smart Art Styles :-
HC Option H Smart Art Shape Hl ¢h¢iæ 3-D
Style B­Rz
Design - SmartArt Style ­k ­L¡e HL¢V Style Select Llz
Reset Graphic :-
HC option Hl p¡q¡­kÉ Design Hl ­k
pjÙ¹ Style, Color CaÉ¡¢c Change L­l¢R a¡
f¤Zl¡u B­Nl AhÙÛ¡C Q­m Bp­hz
Design - Reset Graphic.
Smart Art Format :-

7797575838 P a g e - 28 Turn Over


29 MS OFFICE 2007

Ll¡l fl Format e¡­j Ribon H­p k¡­h


Smart Art insert
a¡l fl Clip Art Picture Hl pjÙ¹ L¡S I Ribon ­b­L q­hz Hl
­r­œ picture Hl ja pjÙ¹ ¢LR¥C HL öd¤ j¡œ Word Art Style
option ¢V B­Rz a¡ ¢e­Q ­cJu¡ qmz

Word Art Style :-


HC Option Hl à¡l¡ Smart Art Hl Shape Hl j­dÉ
­mM¡…¢m­L Style, Color, Out Line Color, Text Effects CaÉ¡¢c
­cJu¡ k¡­hz
Text Fill :-
Smart Art Hl Hl j­dÉ ­mM¡…¢ml j­dÉ Color,
Shape
Picture, Gradient, Texture, Partarn CaÉ¡¢c ­cJu¡l SeÉ H Option
­k­a q­hz
Format – Text Fill ­k ­L¡e HL¢V (Color, Picture, Gradient,
Texture, Partarn) Select Ll­a q­hz

Text Out Line :-


Smart Art Hl Shape Hl j­dÉ ­mM¡…¢m­L k¢c Out Side
Border Hhw ­pC Border H Color, Border Width, Boarder Style
¢c­a Q¡C a¡q­m HC Option H ­k­a q­hz
Format – Text Out Line (­k ­L¡e
Color, width, Dashes Select Ll­a q­hz
Text Effects :-
Smart Hl Shape Hl j­dÉ
Art
­mM¡…¢m­L k¢c ­L¡e Effects ¢c­a Q¡C
a¡q­m HC Option H ­k­a q­hz
Format – Text Effects (Choose Any Effects)

7797575838 P a g e - 29 Turn Over


30 MS OFFICE 2007
Chart:-
k¢c Page H Graphics Hl j¡dÉ­j ­L¡e a¡¢mL¡
fËÙ¹¥a Ll­a Q¡C a¡q­m chart Option H ­k­a q­hz
fËb­j ­k X¡V¡ ­V¢hm¢V ¢e­u Chart Ll­a q­h ­pC
­V¢hm¢V­L Select Ll­a q­h, a¡lfl Insert Ribon Hl Charts
Command Group Hl j­dÉ ­k ­L¡e HL¢V Chart Style Choose
L­l Click Ll­m Work Sheet H Chart ¢V Insert q­u k¡­hz
Insert Ll¡l fl ¢ae¢V h¡l °al£ q­h, a¡lfl I Chart Hl
pjÙ¹ L¡S I h¡l ­b­L q­hz
Design :-

Type:-
Change Chart Type:-
­k Type Hl Chart insert L­l¢R a¡l Type Change Ll­a
Q¡C a¡q­m HC Option H ­k­a q­hz
Design - Type - Change Chart Type H Click Ll¡l fl
HL¢V Dialog Box Bp­h ­pM¡­e AeÉ ­k ­L¡e HL¢V Type
Select - Ok.

Chart Layout:-
HM¡­e A­eL Layout B­R k¡ Select Ll¡ k¡uz

Chart Style:-

HM¡­e A­eL Style B­R k¡ Select Ll¡ k¡uz

7797575838 P a g e - 30 Turn Over


31 MS OFFICE 2007
Layout:-

HC Option H Chart title, Axis Title, Length(Index), data


lebels, DataTable, Gridline CaÉ¡¢c Set Ll¡ k¡uz
Format:-

HC Option ¢Vl L¡S Smart Arts Hl


Format Hl jaz
Hyperlink:-
Hl j¡dÉ­j HLV¡ File Hl p­‰ AeÉ Bl HLV¡ File ­L
link L­l l¡M¡ k¡uz

Hl j­dÉ ­L¡e Cell ­L Select


File
L­l a¡lfl
Insert Ribon Hl Link Command Group
Hl Hyperlink Option H Click Ll­m HL¢V
Dialog Box Bp­h ­pM¡­e Navigation Pan H
Existing File or Web Page (­L¡e Save Ll¡

7797575838 P a g e - 31 Turn Over


32 MS OFFICE 2007
File Hl p­‰ h¡ ­L¡e Internet Page Hl
p­‰ Link Ll¡l SeÉ) h¡ Place in this
Document (k¢c K HLC Document Hl
HL¢V Sheet Hl p­‰ AeÉ Sheet Hl Link
Ll­a q­m) h¡ Create New Document
(­L¡e ea¥e File °al£ L­l a¡l p­‰ Link
Ll­a q­m) a¡lfl ­k ­L¡e File h¡ Sheet
Select L­l h¡ Web Page Hl p­‰ Ll­a
q­m Address Hl Box H Web Address ¢V
¢m­M Ok Ll­a q­hz
Short cut key=> Ctrl+K

Hyperlink ­cM¡l SeÉ :-


Link Ll¡ Cell Hl Efl Click Ll­a q­hz
Abh¡
Link Ll¡ Cell Hl Efl Right Click - Open Hyperlink.
Abh¡
a¥m­a q­m h¡ Remove Ll­a q­m Link Ll¡
Hyperlink Word
Hl Efl Right Click L­l Remove Hyperlink H Click.
Word Art:-
k¢c Page H ­a ­mM¡l Shape Be­a Q¡C a¡q­m Word Art
Option H ­k­a q­hz

Insert Ribon Hl Text Command Group


Hl Word Art Option Hl H Drop Down
Click Ll­m HL¢V List Bp­h ­pM¡­e
A­eL Word Art Style Bp­h ­k­L¡e HL¢V
7797575838 P a g e - 32 Turn Over
33 MS OFFICE 2007
Style H Click Ll­m Word Art Insert q­u
k¡­hz
Word Art insert Ll¡l fl Format e¡­j TAB H­p k¡­h a¡lfl
Word Art Hl pjÙ¹ L¡S I Tab ­b­L q­hz HC Format h¡­ll
L¡S Picture & Shapes Hl L¡S Format h¡­ll j­a¡z

Object:-
Hl j¡dÉ­j HL¢V Application H cy¡¢s­u AeÉ HL¢V Application
Hl abÉ Insert Ll¡ k¡uz
ea¥e File °al£ L­l ­f­S Be¡l SeÉz Create New.
­kje Excel Hl j­dÉ Paint Hl abÉ Insert Ll­a q­mz
Insert Ribon Hl Text Command Group Hl Object Option H
Click Ll­m HL¢V Dialog Box Bp­h ­pM¡­e Create new Hl
Bitmap Image H Click L­l Ok H­a Click Ll­a q­hz

B­Nl Ll¡ ­L¡e


save File ­f­S Be¡l SeÉ Create From File
Option H ­k­a q­hz

Insert Ribon Hl Text Command Group


Hl H Click Ll­m HL¢V
Object Option
Dialog Box Bp­h ­pM¡­e Create From File

7797575838 P a g e - 33 Turn Over


34 MS OFFICE 2007
Hl BrowseH Click Ll­m HL¢V Dialog
Box Bp­h ­pM¡­e Navigation Pan H ­kM¡e
­b­L File Insert Ll­a Q¡C¢R (Desktop,
Computer Drive, My document) ­p¢V select
L­l - Open H Click L­l Ok H­a Click
Ll­a q­hz
Object Hl j¡dÉ­j ­L¡e File Insert Ll­m a¡l k¡ha£u L¡S
Picture Hl ja quz Modify Ll­a q­m Picture Hl Efl
Double Click.

Symbol:-
k¢c ­L¡e fË¢aL ¢Qq² ¢c­a Q¡C a¡q­m Symbol Option H
­k­a q­h.

Insert Ribon Hl Text Command Group


Hl H Click Ll­m HL¢V
Symbol Option
Dialog Box Bp­h ­pM¡­e ­k­L¡e HL¢V
Symbol Choose L­l Insert H Click Ll­a
q­hz
7797575838 P a g e - 34 Turn Over

You might also like