=====================================================MS

word============================================================

Data processing-->can be consider as a row fact processing through the application

software like ms office
-----------------------

1-> Microsoft word largest font size -->1638 (ctn+sft+>) and min 1(ctrl+sft+>)
---->By default 11
---->dialect file min 8 and max 72

2->WPS->word presentation spreadsheet

3->spreesheet can be called as excel

------------------------------------versions of Microsoft office-------------------

1>MS office 1.0 (1990) from Microsoft corporation

>ms office 2.0(1991) ,v3.0(1992),office xp (1995), Ms office 1997, Ms office 2000,
Ms office 2003,Ms office 2007,Ms office 2010,Ms Office 2013,Office 2016,Office
2019,Office 2021(latest version of ms office is 2021)

-------------------------------Application of Microsoft Office

---------------------------

1> MS Word (word processing ) extension .doc (version 2003 ) then after its
extension is .docx(2007-2021)

---->executable file is winword.exe in run

-----> By default name is document-1.doc or docx

------>direct exist in application (alrt+f4)

-->System trey task bar right hissa jaha time date hota hai
-->title bar top p hoti hai

--> aapne kitne sabd likhe hai status bar p dikhai dete hai
--->by default Zoom 100% min Zoom 10% and Maximum Zoom 500%

==============================office button(in Microsoft word ) (File previously

known as)=============================================
Total menu's are 7 which are b=given below(it comes under the ribbon )
1->Home
2->Insert
3->layout
4->Reference
5->mailing
6->Review
7->View

QAT is known as (quick access toolbar)=>

ye comond title bar pr upathit hote hai isme ve tool upasthit hote hei

==>Office button->
--------------------
command are:
1->new (ctrl+N)-->it open a new MS word Document-1.docx
2->open (ctrl+O)->open old file
3->save (ctrl+S)-->save current document
4->save As (f12)-->save a file in more then one location or change the name of that
file or extention
5->print->(ctrl+p)->print the document
6->print preview->(ctrl+f2)->to check the document before the print
7->recent (recently use file)
8->exit--(alrt+f4) ->go to exit the current program

Home menu====>
1->clip board
---------------
ctrl+x->cut -->is also called move the data
ctrl+c->copy
ctrl+v->paste
----------------

2->Clip mode
--------------------
that is a store data and object when user paste data
--------------------

3->format painter
-------------------
pahle se kiye gye text ki formatting ither text per apply krne k liye use krte hai

================sort key========
1->undo (ctrl+z)
2->redo (ctrl+y)

Text selection proces========>

-------------------------
1->All select (ctrl+A)
2->shift+arraow key
3->mouse left + key

font ===>
=>page m like gye text font kahlate hai .normal font m badklaw ki prakriya font
formt kahlati hai
=>text editor program m by default font ka prakar clivri hota hai

Bold===>(ctrl+b)
=>akcharon ko bold krne k liye

italic==>(ctrl+i)
=>select kiye gye akcharon ko italic krne k liye
-----------------------------------------------------------
underline(ctrl+u)=>underline krne k liye
----------------------------------------------------------
font size=>
8 minimum font size
11 default font size
72 maximum font size

selected font ko (ctrl+shift+>) k dvara maximum font size 1638 ki ja skti hai
minimum (ctrl+shit+<)

-------------------------------------------------------------------------------

super Script=>(ctrl + shift+ +)

selected text ko power k roop p pradarshit krne k liye

sub Script=>(ctrl + =)

select text ko base line se niche likhne k liye

---------------------------------------------------------------------------------

strike through =>

select text k Madhya line drow krne k liye (discrpitated)

----------------------------------------------------------------------
grow font size=>selected font ka akar badhane k liye
sink font size=>selected font ka akar ghatane k liye

font color =>select text ka color change krne k liye

highlighter =>highlight the selected text arthat background ka color change krne k
liye

undo =>until nirdesh ko cancel krne k liye (ctrl+z)

redo =>(ctrl+y)

extention=> pratyek application aapne naam ki pahchan dene k liye extention ka use
krta hai jyse .txt,.c,,class,doc,docx
many more .

paragraph=>
1->bullet and numbering
2->left alignment (ctrl+l)
3->right alignment (ctrl+ r)
3->central alignment (ctrl+e)
4->justify alignment (ctrl +j)

-----------------------------------------------------------------------------------
-----------

change case =>it can be a five type

1-> sentence case => Pahla akchar bada hoga
2-> lower case =>line ya document me upasthit sbhi sabdo ko lower krne k liye
3-> Upper Case => document m upasthith sabhhi sabdo ko capital m darsane k liye
4-> Capital Each Word => sabhi sabdo ka pahla ackhar bada baki sb chota
5->toggle case =>

-----------------------------------------
drop cap=>
--------:
->kisi bhi sabd k pahle akchar ko teen ya char line k barabar bada krne k liye drop
cap ka use krte hai
Typing Error:
------------
1-> spelling error ->red color line
2->grammar error ->red color line

f7->document me spelling or grammer ko check ya sahi krne k liye f7 ka use hota hai

f1->for help
--------------------------------------------------------------

Sorting:
---------
sorting can be done in text,date and number

1->Ascending
2->descending

-------------------------

Find & Replace

find (ctrl + f )
replace (ctrl + h
go to (ctrl+g)

-------------------
note :-> MS word m window can be divided in two part parent window and child window

=================Important sort key in MS word ======

ctrl+A -> sb kuch selecgt krne k liye

ctrl + B -> bold krne k liye

ctrl + c -> copy krne k liye

ctrl + D -> open dialect font box

ctrl + E -> text ko center m krne k liye

ctrl +f ->find krne k liye

ctrl +g ->page number ya file m direct gane k liye

ctrl + H ->replace krne k liye

ctrl + I -> italic m krne k liye

ctrl + j -> justify alignment k liye

ctrl + k -> use for hyper link

ctrl + l -> alignment left krne k liye

ctrl + M ->new slide create krne k liye

ctrl + N ->new document create krne k liye

ctrl + O ->exixting file ko open krne k liye

ctrl + p -> print krne k liye

ctrl +f2 -> print preview k liye

ctrl + Q -> not available

ctrl + R ->right alignment

ctrl + S-> save krne k liye

ctrl + f12 -> use for save as

ctrl + T ->not avilable

ctrl + U -> under line

ctrl + V -> paste krne k liye
ctrl +W -> closed child window

alt + f4 kisi bhi application ko band krne k liye

ctrl + x --> cut krk paste krne k liye

ctrl +y --->redo krne k liye

ctrl +z --->undo krne k liye

alt + ctrl + c -> insert copy right symbol

ctrl + [ ->increases font one by one

ctrl + ] ->decrees font size one by one

f1 -> help
f2 ->exit
f5->return
f7->error detection and correction in ms word
f8 -> booting

Warm booting -> restart krne ki prakirya

cold booting -> shut down k baad on krne k prakriya

BIOS-> besic input output System

Post->power on self test

f11 ->full screen

f12 -> save as

alrt + f8 -> create marcos

=> marco ek asya program hai jisme document m baar baar ane wale sabdo ko ek bar
record kr unki ek specific key assign krli jati hai

ctrl + up arrow -> go to the cursor first page and first line
ctrl + down -> go to the cursor last page last line .

ctrl + f1-> show/hide the ribbon

alt + f5 -> window restore

==========================================Insert Menu
================================

user dvura text ko left click dura select krne pr mini toolbar swata hi pradrshit
hoti hai

=>is menu m page k Andar table clip art smart art word art doc cap hipper link
shapes image aadi insert k liye hota hai

kisi bhi table k prtham sell ka address A1 (first column then row)
.
active cell =>
vartam m user duara kiya gaya text active cell likha jata hai.
table ka nirman row and colomn k dura hota hai .
cell => table ki choti ekai cell hoti hai .pretek cell ka ek nischit cell hoyta hai
jisme pahle colomn number fir row number hot hai (f1 ,f2 ----etc.)

Split cell=>(right click on the cell )

->ek cell ko do ya do se adhik cell m batne ki prakriya split cell kahlti hai .

row------> horizontal hote hai

column--->vertical hote hai

--------------------------------------------------

chart:->
select kiye gye data ki value ko picture k roop m ya graph k roop m chart ka prayog
kiya jata hai

Type of chart:=>
1->problem chart
2->pai chart
3->bar chart

group of commond is called ribbon

Page:=>

cover page:-> word word page m file ka cover dene k liye use hota hai

blank page -> cursor position pr blank page lene k liye use hota hai

page break-> vartan page ko break kr cursor agle page pr p chala jayga

picture -> pic insert krne k liye use hota hai

clip art-> computer System m predefined picture hota hai usko insert krne k liye
use krte hai

predefined shapes and picture akriti insert krne k liye use hota hai
smart art=>
Kisi org m alg alg brancho ko define krne k liye use hota hai

header ->page k top m header diya jata hai jisme document sde sumbandhit title hota
hai

footer ->kisi bhi page ka number dene k liye bhi use hota hai last m footer diya
jata hai

text box-> text box ko insert krne k liye

word art-> kisi bhi sabd ko kalatamtk ya prabhavi dhang se prastut krne k liye

NOTE:->by default 5 colomn and 2 row hogi insert se smbhadhit (2003-2007 version
tk)

orientation -> 2 type k hote hai potrate and landscape

hypantion-> kisi sabd ka kuch hissa agr agli line m hota hai to use hypanization se
sahi krte hai

page size can be a A4,legal,latter,A6

===================================================================================
======================================

MS EXCEL OR Spreadsheets

===================================================================================
======================================

1->MS Excel ko hum spreadsheet program k naam se Jante hai iska Pratham version
vesical k naam se 1983 m jari hua

2->ye ek application s/w hai jiska uddesya jatil se jatil gaditiya gadnaow ko solw
krne k liye hota hai

3-> by default name book1 hota hai ise hum workbook k naam se jante hai

4-> 1 book m pahle se 3 sheet insert hoti hai status bar p hoti hai

5-> 1 sheet k andar 16384 column aur 1048576

Q1=> MS Excel sheet me last cell ka cell address : XFD 1048576

-------------------------------------------------------------------------
active cell ka cell address name

MS excel ko open krne k liye Executable file excel.exc hai

kisi cell m parivartn krne k liyue user cell pr jakr dabble click krta hai ya f2
krta hai
extension name =>.xls (2003 isme row 65536 thi aur column 256) and xlsx(from
2007)

MS Excel sheet(version 2003 ) me first aur last cell ka cell address : A1 aur
IV65536

Excel m sbse upper title bar hoti hai

jisme 1->file name
2->QAT
3->Control box hoti hai

Ms Excel m sbse niche task baar hoti hai

-----------------------------------------------------------------------------------
-----------------

Scroll bar:->
1-> horizontal
2->vertical

Maximum Zoom 400%

and minimum 10%

MS Excel m new sheet insert krne k liye shift + space bar and maximum 256 sheet le
skte hai

lekin gogle sheet m 1 hoti hai aur maximum 256 hoti hai

-----------------------------------------------------------------------------------
----
formula:->
1-> mathematical function
2->date and time function
3->text function

===================================================================================
========================================

file System
===================================================================================
========================================

Types of System S/w

1->System s/w
2->Application s/w
3->package s/w
4->utililty

1====System s/w
1-> Operating System
2-> language translator
3-> device derivers
Operating System k 2 interface hote hai (GUI ,CUI)

Q1-> kon sa Os mouse k dvara nhi kiya ja skta : unix and ms-dos