SUCCESS COMPUTERS

WordPad
Assignment No.1
KalaIla majakUr Ta[-p k$na File saovh kra va %yaaKalaIla
p`Sna saaoDvaa.

1. Computer is an Electronic Device.

2. Data is Stored on Hard Disk.
3. Monitor is Output Device that Displays Information.
4. Keyboards, Mouse are the input Devices.
5. Del Key is used to Delete the letter of Right Side of the Cursor.
6. Backspace Key used for to remove the left side character of the cursor.
7. Caps Lock Key is used to write the words in capital Letters.
8. 53 , CO2.

Questions :
1) varIla majakuratIla p`%yaok maud\dyaalaa vaogavaogaLa

klar dyaa.

2)varIla majakuratIla dusaáyaa vaa@yaalaa laala klar

dovaUna %yaacaI saa[-ja 26 pa^[MT [tkI kra.

3)pihlyaa vaa@yaatIla 5 vyaa Sabdalaa Bold, Underline k$na

%yaacaI saa[-ja 29 pa^[MT [tkI kra.

4)6 vyaa vaa@yaacaa fa^nT Brush Script MT ha dovaUna

%yaalaa Bright Green klarnao hayalaa[-T kra.

5´ 8 vyaa vaa@yaatIla 53 yaa AMkacao $paMtr 53 yaa sva$pat

badlaa tsaoca CO2 cao $paMtr CO2Asao badlaa.

6´ 4 qyaa vaa@yaatIla 3 ra Sabd Strikethrough yaa kmaaMDcyaa

sahayyaanao KaoDa ( Rough ).

7´ Grow Font yaa baTnacyaa sahayyaanao 3 vaa@yaacaI saa[-

ja hvaI tovaZI vaaZvaa.

8´ 5 vyaa vaa@yaacaI saa[-ja Shrink Font yaa baTnacyaa

sahayyaanao kmaI k$na tI 10 pa^[MT evaZI kra.

 Lucky Computers Rawangaon
WordPad
Assignment No.2
KalaIla majakUr Ta[-p k$na Filesaovh kra va %yaaKalaIla
p`Sna saaoDvaa.

COMPUTER:
Computer is an electronic device that performs arithmetic and logical operations
fastly as well as accurately. It has storage capacity and also data may be changed
whenever necessary. Storage devices are used to store the large data on it
permanently.

Types of Keyboard:
Traditional Keyboard.
Ergonomic Keyboard.
Flexible Keyboard
Wireless Keyboard.
PDA’s Keyboard.
Types of Mouse :
Mechanical Mouse
Optical Mouse
Wireless Mouse.
Questions :
1) varIla majakuratIla COMPUTERha Sabd AaoLIcyaa maQyao
Gao}na %yaalaa Bold, Underline Asao pirNaama Va.
2)COMPUTER Sabdacyaa KalaIla maahItI permanently yaa
Sabdacyaa SaovaTI ksa-r zovaUna daonada Paste kra va
tI maaihtI Justify kmaaMD dovaUna Alaa [-na kra.
3)varIla maaihtIcao daona p^roga`af tyaar kra %yaasaazI Enter
va Tab baTnacaa vaapr kra.
4)Increase Indent yaa baTnacyaa sahayyaanao pihlaa p^roga`af
puZo Gyaa.
5´ laa[-na sposaIMga kmaaMDcyaa sahayyaanao pihlyaa
p^rga`afcao daona AaoLItIla AMtr 1.5 Point Asao kra tr
dusaáyaa p^rga`afcao daona AaoLItIla AMtr 2 Point Asao kra.
6´ Types of Keyboard cyaa KalaIla mauVaMnaa Bullets Va trTypes of
Mouse cyaa KalaIla mauVaMnaa
Numbers Va.
7´ Document cyaa savaa-t varIla baajaUsa ]javyaa kaopáyaat
AajacaI tarIK samaaivaYz kra.
8´ Types of Keyboardyaa mauVacyaa KalaaIla baajaUsa Paint Drawing
yaa kmaaMDcyaa sahayyaanao ek fulaJaaDkaZa
 Lucky Computers Rawangaon
WordPad
Assignment No.3
KalaIla majakUr Ta[-p k$na File saovh kra va %yaaKalaIla
p`Sna saaoDvaa.

1. Computer is an Electronic Device.

2. Data is Stored on Hard Disk.

3. Monitor is Output Device that Displays Information.

4. Keyboards, Mouse are the input Devices.

5. Del Key is used to Delete the letter of Right Side of the Cursor.

6. Backspace Key used for to remove the left side character of the cursor.

1´ varIla sava- mauVaMnaa baulaoT ikMvaa naMbar dyaa.

2´ KalaIla majakUr Ta[-p krtanaa AaoLIcyaa SaovaTI ENTER
baTna dabaU naka.
MS-CIT is an Information Technology (IT) literacy course started by MKCL in the year

2002. It has made more than 95 lakh learners IT literate till date. It is the most popular IT

Literacy course in Maharashtra.

3´ varIla majakUr ka^pI k$na majakuracyaa savaa-t

SaovaTIcyaa AaoLImaQyao ksa-r zovaUna daonada posT kra va
naMtr %yaacao daona
p^roga`af tyaar kra. ³pihlaI AaoL samaasaapasaUna 0.8
[Mca [tkI puZo Gyaa´.
4´ varIla majakUr daonhI baajauMnaI samaaMtr roYaot
GaoNyaasaazI Alaa[-namaoMT jasTIfaya vaapra.
 5´ varIla daonhI p^roga`afkirta daona AaoLItIla AMtr 1.5
saomaI [tko kra. ³ laa[-na sposaIga kmaaMD vaapra´
 Lucky Computers Rawangaon
WordPad
Assignment No.4
1.KalaIla maaihtITa[-p krNyaaAgaaodr puZIlap`maaNao Tab
saoT kra.

1  1", 2  2.5" & 3  3.5"

CPU : Central Processing Unit.

CD : Compact Disk
DVD : Digital Versatile Disk
E-Mail : Electronic Mail
WWW : World Wide Web
HTML : Hypertext Markup Language

2) varIlamauVaMcyaa AaoLItIla AMtr( Line Spacing) 1.5 pa^[MT

[tko kra va idlaolao T^ba saoTIMga kaZUna Taka.
3´Picture Sample Pictures maQaUna ek ica~ samaaivaYz kra va
%yaacaI saa[-ja Horizontal – 40% &
Vertical – 35% ASaI zovaa.
4´Insert Object yaa kmaaMDcyaa sahayyaanao KalaIlapOMkI
kaoNatahI ek AalaoK samaaivaYz kra.
Insert Object  Microsoft Excel Chart
Insert Object  Microsoft Graph Chart

5´ KalaIla majakur Ta[-p k$na %yaavar View – Word Wrap

maQaIla tInahI pyaa-ya caok k$na pha.

Output Devices are any Hardware used to provide or to create an output from the
Computer. The most widely used output devices are Monitor, Printers and Audio –
Output Devices. Monitor Standard indicate screen quality. CRTs are similar to
Televisions. Flat Panel Monitors are smaller. Other Monitors include e-books, data
projectors and HDTVs.
 Lucky Computers Rawangaon
Ms-Word 2013
Assignment No.1
Q.1) KalaIla sava- maud\do ilaha va %yaaKalaIla p`Sna
saaoDvaa.
1) What is computer?
2) Computer: It is an Electronic Device that performs arithmetic & logical operations.
3) Types of Computer:
a) Mainframe computers
b) Mini – Computer
c) Super Computer
d) Micro – Computer
4) Mostly used Computer devices:
a) Keyboard
b)Mouse
c) Monitor
d)Speaker
5) Keyboard is used to give data to the computer as a Input.

Questions :
1) varIla Da^@yaumaoMTmaQaIla dusaáyaa AaoLItIla
majakuracaa Font – Monotype Corsiva Asaa badlaUna tI maaihtI
Bold, Italic k$na %yaasa Double Underline dyaa.
2) 4 qyaa maudyaatIla Mouse yaa SabdacaI Size 48 pt k$na
%yaacaa Text Effect- Fill – None – Outline
Accent 2 Asaa kra.
3) “Types of Computer” ho hoiDMga Bright Green yaa klarnao
hayalaa[-T kra.
4) varIla majakuratIla 4 qyaa maudyaacaI saa[-Ja 39pt. k$na
%yaacaa Font Effect – Small Caps Asaa saoT kra.
5) pihlyaa vaa@yaatIla Computer yaa Sabdacao Scale 250 % [tko kra.
(Home : Font –> Advanced -> Scale ->250% )
6) 5 vyaa maudyaatIla pihlaa Sabd AaoLIpasaUna 10 pt nao
var ]calaa.
(Home :Font –>Advanced -> Position -> Raised –> 10)
7) varIla majakuratIla Monitor yaa Sabdacao Character spacing 10 pt
nao vaaZvaa.
(Home : Font –>Advanced ->Spacing –> Expanded –>10 pt)
8) varIla majakuracyaa savaa-t SaovaTI 102 va H2O Asao ilaha.
 Lucky Computers Rawangaon
Ms-Word 2013
Assignment No.2
KalaIla majakUr Ta[-p k$na Filesaovh kra va %yaaKalaIla
p`Sna saaoDvaa.
Welcome to MS-CIT
1. Reading and understanding a highly illustrated book

2. eLearning based self-learning sessions

3. Through MKCL's eLearning Revolution for All (ERA)

4. Providing hands-on practice sessions.

5. Learning facilitation by certified professionals

6. With academic interactions, assessments, and collaboration

Questions :
1) varIla majakuratIla p`%yaok maud\dyaalaa vaogavaogaLa
klar dyaa.
2) varIla majakuratIla pihlaI AaoL ka^pI k$na 5 va 6 yaa
daona AaoLIMcyaamaQyao tIna vaoLa posT kra.
1´ p`qama pihlaI AaoL isalao@T kra.2´ Home
T^bavarIla Copy baTnavar i@lak kra.
3´ naMtr 5 vyaa AaoLIcyaa SaovaTI ksa-r zovaUna
ekda Enter baTna dabaa mhNajao ek irkamaI AaoL
imaLola.
4´ SaovaTI Home T^bavarIla Paste baTnavar tIna vaoLa
i@lak kra.´
3) varIla majakuratIla sahavaI AaoL Aaho toqaUna kaZUna tI 3
áyaa va 4 qyaa AaoLIMcyaa maQyao Move³sqalaaMtrIt´ kra.
1´ p`qama sahavaI AaoL isalao@T kra. 2´ Home
T^bavarIla Cut baTnavar i@lak kra.
 3´ naMtr 3 áyaa AaoLIcyaa SaovaTI ksa-r zovaUna
ekda Enter baTna dabaa mhNajao ek irkamaI AaoL
imaLola.
4´ SaovaTI Home T^bavarIla Paste baTnavar i@lak kra.´
4) varIla majakuratIla and Sabd SaaoQaUna tao OR yaa
Savdanao badlaa.³Home Replace kmaaMD vaapra´
5´ varIla majakuratIla caaOqaI AaoL Aa^ifsa i@lapbaaoD-
cyaa sahayyaanao 6 vyaa AaoLIcyaa KalaI tInada posT kra.
6´ dusaáyaa AaoLIlaa laala klar dovaUna fa^nT saa[-ja 29
evaZI k$na tI Word Only yaa p`karanao AQaaoroiKt kra.
( Font Underline Style  Word Only Select )
7´ fa^rma^T poMTrcyaa sahayyaanao dusaáyaa AaoLIcao
fa^rma^TIMga 4 qyaa va 7 vyaa AaoLIlaa Va.
1´ p`qama dusarI AaoL isalao@T kra. 2´ ³Home  Format Painter
´ fa^rma^T poMTr baTnavar Dbala
i@lak kra.3´ 4 qyaa va 7 vyaa AaoLIMva$na fa^rma^T
poMTr AaoZa.´
8´ Change Case yaa kmaaMDcyaa sahayyaanao varIla
majakuratIla p`%yaok AaoLIlaa vaogavaogaLa pyaa-ya
dovaUna pha.
 Lucky Computers Rawangaon
Ms-Word 2013
Assignment No.3
KalaIla maaihtI salagapNao Ta[-p kra.( AaoLIcyaa SaovaTI Enter
baTna dabaU naka.)
Output Devices are any Hardware used to provide or to create an output from the
Computer. The most widely used output devices are Monitor, Printers and Audio –
Output Devices. Monitor Standard indicate screen quality. CRTs are similar to
Televisions. Flat Panel Monitors are smaller. Other Monitors include e-books, data
projectors and HDTVs.

1´varIla majakUr Copy-Paste kmaaMDcyaa sahayyaanao %yaaca

majakUracyaa SaovaTI (HDTVs.) ksa-r zovaUna daonada Gyaa.
2´varIla majakUracao daona p^roga`afmaQyao $paMtr kra.
%yaakrIta KalaIla p`maaNao kmaaMD vaapra.
Alignment: Justify, Indentation : Left = 0.3”, Right = 0.4”,Special : First Line = 0.7”.
3´pihlyaa p^roga`afkrIta daona AaoLImaQaIla AMtr Line spacing
=1.5 va dusaáyaa p^roga`afkrIta
Line Spacing = Double dyaa.
4´saMgaNakacao p`kar ilahUna %yaaMnaa ( Home Bullets and
Numbering) cyaa sahayyaanao naMbasa- dyaa.
Types of Computer:
Mainframe Computer.
Super computer.
Mini Computer.
Micro Computer.
Desktop Model.
Notebook Computer (Laptop Computer).
Tabletpc.
Handheld Computer.
5´saMgaNakamaQyao maaihtI saazivaNyaasaazI vaaprlaI
jaaNaarI saaQanao KalaIlap`maaNao Aahot¸%yaaMnaa hvyaa
%yaa baulaoT\sa dyaa.
( Home Bullets and Numbering Command )
Storage Devices :
Hard Disk.
Magnetic Tape.
Optical Disk.
Compact Disk (CD).
DVD.

6´ tumhI tyaar kolaolyaa saurvaatIcyaa daonhI p^roga`afnaa

p^roga`af baa^D-r (Pagelayout  Borders) dyaa.
tsaoca saMpUNa- Da^kyaumaoMTlaa poja baa^D-r ( Design
Page Borders )dyaa.
 Lucky Computers Rawangaon
Ms-Word 2013
Assignment No.4
WordArt, Shapes, SmartArt, Clipart, Picture
1) Word Art cyaa sahayyaanao svat:cao naava ilaha.
2) naavaacyaa KalaI Shapes maQaIla Cloud Callout Shape Insert k$na
%yaamaQyao MS-CIT Course at Asao ilaha.
3) varIla Shapes cyaa KalaI ek Flow Chart – Card Gao}na %yaamaQyao
OM - ComputerAsao ilaha.
[Shape maQyao ilaihNyaasaazI Shape var Right Click k$na Add
Text var Click kra.]
4) varIla daonhI Shape laa Format maonaUtUna klar dyaa va
%yaacaa Shape badlaUna pha.
[ Format Shape Fill  Texture – Pink Tissue Paper.]

[ FormatShape Outline  Weight  2 1/4 pt dovaUna Green klar dyaa.]

5) Insert  Smart Art Hierarchy Hierarchy SelectOk kra.

Design Promote - Demote va ADD – Shapes kmaaMD vaap$na

saMgaNakacyaa p`karaMcaI
 AakRtI tyaar kra.

Types of
Computer

Mainframe Super Mini Micro

Computer Computer Computer Computer

Desktop Notebook / Handheld PDA's

Computer Laptop Computer Computer

6) savaa-t SaovaTI Insert  Picture maQaUna kaoNatohI ek

ica~ pojacyaa SaovaTI [nsaT- kra va %yaavar Picture
Styles maQaUna Beveled Oval, Black Shape Gyaa.
 Lucky Computers Rawangaon
Ms-Word 2013
Assignment No.5

1) Document Windowcyaa BaaovatI Ruler baMd Asalaosa View

maonaUtIla Ruler ha pyaa-ya sau$ kra.
2) $larvarIla 2.5" va 3.5" yaa izkaNaI maa}sanao i@lak
k$na Tab saoT kra va KalaIlap`maaNao svat:caa
baayaaoDaTa tyaar kra.
BIO-DATA
A] Personal Information :
Name : svat:cao naava.
Address : svatacaa p%ta.
Contact No : maaobaa[-la naMbar.
Birth Date : janmatarIK.
Sex : Male/ Female
Marital Status : Married/ Unmarried
Nationality : Indian
Hobbies : Reading Books etc.
B] Educational Qualification:

Sr. No. Exam Board/ University Year of passing Percentage

1. S.S.C. Pune Feb. 2009 78.00%
2. H.S.C. Pune Mar.2009 79.00%
3.

3) Tobalacyaa sava- AaoLIMcaI }McaI 4 pa^n[T [tkI kra va

Alaa[-namaoMT saoMTr zovaa.
[p`qama sava- AaoLI isalao@T kra va naMtr Layout  Table
Row Height  0.4” k$na Alaa[-namaoMT saoMTr Gyaa´
4) Format Painter cyaa sahayyaanao Personal Information maQaIla
DavaIkDIla maud\do Bold kra.
 [Home Format Painter Double Click k$na p`%yaok mauVavar
AaoZa.]
5) saMpUNa- Da^kyaumaoMTlaa poja baa^D-r (Design  Page
Borders ) dyaa.
6´ Personal Information maQaIla sava- mauVaMcyaa AaoLItIla AMtr
Double Line Asao saoT kra.
[ Home Paragraph  Line Spacing  Double ]
7) Tobala hoDIMgacyaa AaoLImaQyao Yellow klar ifla kraÀ Bara.
³ Tobala hoDIMgacaI AaoL isalao@T k$na Design 
Shading Colour maQaUna Yellow klar inavaDa´
Lucky Computers Rawangaon
Ms-Word 2013
Assignment No.6
Header - Footer, Page Break, Blank Page, Cover Page.
Q.1) KalaIla maaihtI Ta[-p kra.

Input devices are used to give data to Computer.

Storage Devices are used to Store data permanently on it.
Output Devices are useful for display or print the information.
Mouse is used for drawing &gives the instructions to the computer.
Scanner is used to scan the Photo & documents on the paper.
Any Word File have name Document 1 and his extension is .docx
Any File is saved automatically in My Documents.

2) varIla majakUratIla p`%yaok AaoL Page Break kmaaMD

vaap$na vaogavaogaLyaa panaavar Gyaa.
³p`qama jaI AaoL dusaáyaa panaavar GyaayacaI Aaho
%yaa AaoLIcyaa sau$vaatIlaa ksa-r zovaa naMtr
Insert  Page Break yaa kmaaMDvar i@lak kra.´
 3) Insert  Header Blank Header cyaa sahayyaanao panaacyaavarIla
Baagaat KalaIla majakUr ilaha.
OM COMPUTERS
Behind Main Peth, infront of Anand Hospital, Bhigwan.

4) Insert  Footer  Grid cyaa sahayyaanao panaacyaa tLaSaI

pana ËmaaMk samaaivaYz kra.
5) Insert Blank Page kmaaMDcyaa sahayyaanao pana 3 va 4
maQyao ek irkamao pana Insert kra
va%yaamaQyaoInsert Symbol  More Symbol  Font Webdings
maQauna savaa-t SaovaTI
pxaacao ica~ () Insert kra va %yaacaa Aakar 150 pa^[MT
[tka k$na %yaalaa ihrvaa klar Va.

6) Insert  Cover Page  Motion Asao Cover Page Insert kra va

%yaamaQyao
“ASSIGNMENT ON HEADER AND FOOTER” Asao Text ilaha.
 Lucky Computers Rawangaon
Ms-Word 2013
Assignment No.7
Columns, Breaks, Watermark, Page Colour, Page Border.

1) File maQaIla New Command cyaa sahayyaanao ek naivana

document GaovaUna %yaamaQyao “Internet is the term made from
interconnection and Networking. Networking is the physical connection between
computer and other devices.” Asao To@sT Type kra va naMtr Section Break
kmaaMD vaap$na dusara sao@Snana sau$ kra.
( Page layout  Breaks  Section Break  Continuous)
2) Page Layout  Column kmaaMDcaa vaapr k$na document maQyao 3
Column Insert kra va KalaIlap`maaNao maaihtI ilaha.
Types of keyboard Types of Mouse Types of Printer
1) Traditional K/B 1) Mechanical Mouse 1) Ink- Jet
2) Flexible K/B 2) Optical Mouse 2) Laser Printer
3) Ergonomic K/B 3) Cordless/ Wireless| 3) Thermal Printer|
4) Wireless K/B Column Break Section Break
5) PDA K/B | ( Continuous )
Column Break

3) Page Layout Column maQyao jaa}na One column select k$na

itsaáyaa Section maQaIla Column
kaZa va KalaIla maaihtI Type kra.
“You Successfully Completed Assignment on Newsletter Columns”.

4) saMpuNa- Document laa hvaa tao Page Colour dyaa.

[ Design  Page Colour Fill Effects  Gradient / Texture / Pattern/

 Picture maQaUna vaogavaogaLo klar dovaUna
pha.]
5) tsaoca Document laa hvaI tI Page Border dyaa.

6) Design  Watermark kmaaMDd\vaaro Document cyaa pazImaagao

svat:cao naava ilaha.

Lucky Computers Rawangaon

Ms-Word 2013
Assignment No.8
Hyperlink, Bookmark, Footnote, Endnote, Caption.
1)KalaIla majakUr Ta[-p k$na p`%yaok maud\da
vaogavaogaLyaa panaavar Page break kmaaMD vaap$na dyaa.
Desktop : It is the first Screen of the O.S.
Network : It is the physical connection between many Computers.
Internet : It the term made from Interconnection + Networking.
Terms :
Short Forms Long Forms
HTML - Hyper Text Markup Language
e –mail - Electronic Mail
WWW - World Wide Web
RAM - Random Access Memory
2) dusaáyaa va itsaáyaa panaavar Picture maQauna ek – ek
ica~ samaaivaYT kra.%yaaMnaa Reference 
Insert Caption kmaaMDd\vaaro naavao dyaa. 1) School Girl, 2) Computer
Operator.
3) Page No. 2 varIla Computer yaa Sabdalaa “It is an Electronic Device” hI
Footnote dyaa.
[ Computer Sabdacyaa SaovaTI ksa-r zovaUna References 
Insert Footnote baTnavar i@lak kra
va SaovaTI panaacyaa tLaSaI 1 naMbarcyaa samaaor
varIla maihtI Ta[-p kra va naMtr dusaáyaa panaavarIla
Computer Sabdavar maa}sa zovaUna Footnote caok kra ]
 4) pihlyaa panaavarIla Screen yaa Sabdalaa “It is the front side of
Monitor” hI Endnote dyaa.
[p`qama ksa-r Screen yaa Sabdacyaa SaovaTI zovaa
naMtr Reference Endnote hI kmaaMD dyaa.td\naMtr ksa-r
Da^@yaumaMTcyaa savaa-t SaovaTcyaa panaavar
yao[-la toqao varIla majakUr Ta[-p kra.SaovaTI punha
Screen Sabdavar maa}sa pa^[-Tr AaNaUna Endnote caok
kra.]
5) SaovaTcyaa panaavarIla Terms yaa Sabdalaa Important Information
ASaI bookmark saoT kra.
[p`qama Term ha Sabd isalao@T kra va Insert  Link  Bookmark
kmaaMDvar i@lak kra va naMtr Add Name
yaa Text Box maQyao idlaolaI maaihtI Type kra va SaovaTI
Add baTna i@kla kra.]
6) Hyperlink kmaaMDcyaa sahayyaanao pUvaI- banaivalaolaI fa[-
la Desktop yaa Sabdalaa jaaoDa va ilaMk caok kra.
[ p`qama Desktop ha Sabd Select kra¸naMtr Insert  Link 
Hyperlink yaa kmaaMDvar i@lak k$na Aalaolyaa
Window maQaIla Browse baTnavar i@lak k$na File Select
kravaI.]
7) Networking yaa Sabdalaa It is the physical connection between two or many
computers hI ka^maoMT ( Insert  Comment) Va.
 Lucky Computers Rawangaon
Ms-Word 2013
Assignment No.9
Hyphenation,Page Setup, Themes, Zoom.
1) KalaIla maaihtI Type k$na tI maaihtI dha panao haotIla ASaa
pwtInao Copy – Paste kra.
The Internet was launched in 1969 when the united states funded a project that developed a
national computer network called Advanced Research Project Agency Network (ARPANET) .
The internet is a large network that connects together smaller networks all over the globe.
The Web was introduced in 1991 athe Center for European Nuclear Research (CERN) in
Switzerland. Prior to the Web, the Internet was all text - no graphics, animations, sound or
video. The Web made it possible to include these elements. It provided a multimedia
interface to resources available on the internet. From these early research beginnings, the
Internet and the Web have evolved into one of the most powerful tools of the 21 st century.

2) File Save k$na Hyphenation Command dyaa. ³ Page Layout  Hypenation´

3) Page layout Page setup Command dovaUna KalaIla iËyaa k$na pha.
a) Paper Size = Legal. (8.5” x 14”)
b) Page Orientation = Landscape
c) Margins:
Top – 0.8”, Bottom – 0.5”
Right – 0.7”, Left – 1.2”
Gutter Margin = 0.4”
d) Layout:
Header = 1.2”
Footer = 0.7”
4) Zoom Command kmaaMDcyaa sahayyaanao sava- Pages
ekacavaoLI idsatIla ASaI saoT kra.
³View  Zoom kmaaMDvar i@lak kra va Aalaolyaa JaUma
ivaMDaomaQaIla Many Computers KalaIla ica~avar i@lak kra
va %yaatIla 2 x 3 Pages yaa pyaa-yaavar i@lak kra. tsaoca
Da^@yaumaoMT puva-vat krNaosaazI View  100% yaa
baTnavar i@lak kra.´
5) Design Themes kmaaMDcyaa sahayyaanao vaogavaogaLyaa
Themes dovaUna haoNaaáyaa badlaaMcao inarIxaNa kra.
6) Print Command maQaIla kmaaMD\sa pha.
7)View maonautIla View badlaUna Document maQyao haoNaaáyaa
badlaaMcao inarIxaNa kra.
 Lucky Computers Rawangaon
Ms-Word 2013
Assignment No.10
Que. KalaIla p`maaNao Quotation tyaar kra.

AKSHAY AGENCIES
Pune Solapur Road, Bhigwan.
Tal – Indapur, Dist –Pune.
Prop :svat:cao naava Mob :
Date:
To,
The Manager,
Ballarpur Industries Ltd,
Bhadalwadi – Pondhawadi,
Unit – Bhigwan.

Sub: Quotation for Providing Vehicles to Company on a Rental Basis.

R/Sir,
As per the company requirement I am Interesting to provide the vehicle with
following best rates.

Sr. No. Vehicle Name Rates for 8 hrs. Monthly Basis

1 BOLERO 1000 30000

2 SCORPIO 900 27000

3 TATA SUMO 800 24000

Total Amount ? ?

Thanking you,

Yours faithfully

FOR AKSHAY AGENCIES

 Lucky Computers Rawangaon
Ms-Word
PRACTICE ASSIGNMENT NO.1

KalaIla majakUr Ta[-p k$na File saovh kra va %yaaKalaIla

p`Sna saaoDvaa.

Operating System are programs that coordinate computer resources, provide an

interface between user and the computer, and run applications. Windows 7 and
Windows Vista are two of the best-known operatings for today’s microcomputer
users.

Utilities perform specific tasks related to managing computer resourses. For

Example, the Windows utility called Disk Defragmenter lacotes and eliminates
unneccesary file fragment and rearrange files and unused disk space to optimize
computer operation.

Device drivers are speacialized programs designed to allow particulars input or

output devices to communicate with the rest of the computer system.

Alignment

Left Center Right

Alignment Alignment Justify
Alignment
Alignment

1) Alignment yaa baa^@samaQyao hvaa tao klar Bara va

%yaaKalaIla baaNaaMcaI laa[-nacaI jaaDI vaogavaogaLI do}na
%yaaMnaa klar Va.
2´ p`%yaok gaaolamaQyao vaogavaogaLa klar Bara va
%yaatIla sava- maaihtI saoMTrlaa Alaa[-na kra.
 3´ Picture maQaUna ek ica~ Gyaa va to ica~ varIla AakRtIcyaa
eka baajaUlaa ]calaUna zovaa.
4´ saMpuNa- pojalaa hvaI tSaI baa^D-r do}na poja
ba^ga`a}MD klar Va.

SUCCESS COMPUTERS VARVAND

MS – Excel 2013
Assignment No.1

PAYROLL SYSTEM
EMP. TOTAL TOT NET
EMP.NAME Salary HRA DA PF LIC PTAX
NO. EARN DED PAY
1 AMRUTA POL 10000 =c3*4% ? ? ? ? ? ? ?
2 SACHIN MULANI 12500 ? ? ? ? ? ? ? ?
3 RAVINDRA MORE 6200 ? ? ? ? ? ? ? ?
4 SANJAY KALE 13000 ? ? ? ? ? ? ? ?
5 RANI PAWAR 9000 ? ? ? ? ? ? ? ?
6 BALAJI SHIRKE 15000 ? ? ? ? ? ? ? ?
7 UMESH CHAVAN 14500 ? ? ? ? ? ? ? ?

KalaIla sau~aMcyaa AaQaaro p`SnaicanhaMcyaa jaagaI ]

%tro kaZa.
HRA = 4% of Salary. DA = 1.5% of Salary PF = 3.5% of Salary
LIC = 8% of Salary PTAX = 1.5% of Salary TOT EARN = Salary + HRA +DA
TOT DED = LIC + PF + PTAX NET PAY = TOT EARN – TOT DED
Questions :
1. File maQaIla ip`MT kmaaMDcyaa sahayyaanao poja
laoAa}T pha va %yaa pojavar na basaNaarI maaihtI
ka^lamacaI $MdI kmaI k$na saoT kra ikMvaa Page Setup
kmaaMDcyaa sahayyaanao poja AaDvao kra.
(File Print  Page Setup  Orientation  Landscape´
2. PAYROLL SYSTEMho hoDIMga maja- A^nD saoMTr (Home Tab Merge
& Center) baTnavar i@lak k$na Tobalacyaa saa[-janausaar
maQyaBaagaI Gyaa.
3. puNa- Tobalalaa hvaI tSaI baa^D-r dovaUna AxaraMnaa
klar dyaa.
( Select Data Home Format  Format Cell  Border  Outline & Inside Option Select)
4. p`%yaok AaoLIcaI ]McaI 25 Pt evaZI vaaZvaa. ( Select Rows 
Format  Row Height  25)
5. Home Alignment yaa kmaaMDcaa vaapr k$na sava-
saolamaQaIla maaihtI saolacyaa maQyaBaagaI Gyaa.
6. Emp. Name yaa rkanyaatIla sava- naavao punha Horizontally
Center k$na Indent kmaaMD vaap$na 2 pa^[-Tnao puZo Gyaa.(
Home  Alignment  Indent  2 pt )
7. Tobalacyaa ka^lama hoDIMgalaa 12.5 % Gray ha p^Tna- klar Va.
(Home  Format Format Cell Fill Pattern Style)
8. HRA to NET PAY yaa sava- rkanyaaMtIla saM#yaa 2 dSaaMSa
sqaLapya-Mt saoT kra.
(Home  Format Format Cell  Number  Number)
9. PAYROLL STSTEMyaa hoDIMgacaI saa[-ja – 22,sTa[-la ¹ baaolD¸ klar
¹ roD va AMDrlaa[-na ¹ Dbala ASaI saoT kra.
 SUCCESS COMPUTERS VARVAND
MS – Excel 2019
Assignment No.2
RESULT ANALYSIS
A B C D E F G H I J
Seat Social
3 Student Name Marathi Hindi English Science Maths Total Percentage
No. Science
4 1 Raju Shinde 65 74 60 87 74 80 =SUM(C4:H4) ?
5 2 Mahesh Kale
6 3 Sunita Shahane
7 4 Manisha Pawar
8 5 Sanjay Kajale
9 6 Ravi Kumbhar
10 7 Amol Shirke
11 8 Smita Parkale

Questions :
1.p`%yaok ivadyaaqyaa-cao sava- ivaYayaacao ekUNa
gauNa Total rkanyaat yaaogya fM@Sanacaa vaapr k$na kaZa.
SUM (C4 : H4)
2.sava- ivadyaaqyaa-cao [Mga`jaI ivaYayaacao ekuNa F12
saolamaQyao kaZa. ³F12= SUM( E4:E9)´
3.p`%yaok ivadyaaqyaa-caI T@kovaarI ³sarasarI´ yaaogya
fM@Sanacaa vaapr k$na Percentage rkanyaat daKvaa.
[ J4 = AVERAGE(C4:H4) ]
4.maak-ilasTcyaa ka^lama hoDIMgamaQyao paSva-BaUmaI
klar (Background Color) Yellow Asaa Bara.
[idloalyaa TobamaQaIla ka^lama hoDIMgacaI AaoL
isala@T kra va KalaIlap`maaNao iËyaa kra :
Home  Fill Colour  Yellow klarvar Clik kra]
5.Name rkanyaatIla sava- ivadyaaqyaa-cyaa naavaaMnaa Red
klar dyaa.
6.RESULT ANALYSIS yaa hoiDMgalaa Double Underline dovaUna klar
laala va saa[-ja 20 zovaa.
7.Name yaa rkanyaatIla ivadyaaqyaa-McaI naavao
AlfabaoTIklaI ³ A-Z´ laavaa.
³ p`qama varIla TobalamaQaIla Name yaa
ka^lamamaQaIla sava- naavao isalao@T kra.Home
T^bavarIla Sort & Filter cyaa icanhavar i@lak kra va
%yaatIla A – Z yaa Aa^PSanavar i@lak kra.´
8.sava- AaoLIcaI ]McaI 28 pa^[-MT [tkI vaaZvaa va puNa-
Tobalalaa hvaI tI baa^D-r dyaa.
³ varIla Tobala maQaIla AaoL Ë.3 to 11 yaa AaoLI
isalao@T kra va Home  Format Row Height
yaa kmaaMDvar i@lak k$na Aalaolyaa
baa^@samaQyao 28 Asao ilaha AaiNa OK baTNavar
i@lak kra.´
9.Percentage yaa rkanyaatIla sava- saM#yaa daona dSaaMSa
sqaLapya-Mt daKvaa.
³ p`qama Percentage yaa rkaNyaatIla sava- AMk isalao@T
kra va Home  Number  Number )
LUCKY COMPUTERS RAWANGAON
MS – Excel 2013 Assignment No.3

REGIONWISE EXAM RESULT

PERCENTAGE
TOTAL APPEARED PASS FAIL ABSEND
REGION OF PASS
STUDENTS STUDENTS STUDENTS STUDENTS STUDENTS
STUDENT
=400*100/46
INDAPUR 500 460 400 =460-400 =500-460
0
DAUND 400 387 360 ? ? ?
BARAMATI 600 540 470 ? ? ?
KARMALA 450 300 276 ? ? ?
HAVELI 300 280 240 ? ? ?
PURANDAR 450 410 400 ? ? ?
QUESTIONS:
1) p`%yaok ivaBaagaatIla Anau%tINa- ivadyaaqyaa-caI
saM#yaa FAIL rkanyaat kaZa.
2) p`%yaok ivaBaagaasaazI Anaupisqat ivadyaaqyaa-caI
saM#yaa ABSENT rkanyaat kaZa.
3) sava- ivaBaagaatIla sava- ka^lamacaI ekUNa ivadyaaqaI-
saM#yaa jyaa–%yaa rkanyaaKalaI ek AaoL saaoDUna
kaZa.
³SUM fM@Sanacaa vaapr kra´
4) baaramatI ivaBaagaatIla ]%tINa- ivadyaaqyaa-caI
T@kovaarI F20 saolamaQyao dSa-vaa.
³baaramatI ivaBaagaatIla ]%tINa- iva.saM#yaa X

100À prIxaolaa basalaolaI ivadyaaqaI- saM#yaa ´

5) PASS va FAIL ivadyaaqyaa-caI sarasarI AnauËmao D20, E20

saolamaQyao kaZa.³AVERAGE ( ) yaa fM@Sanacaa vaapr kra´

6) savaa-t jaast ]%tINa- ivadyaaqaI- saM#yaa AsaNaaáyaa
ivaBaagaamaQyao Yellow Color Bara.
7) pirxaolaa basalaolyaa sava- ivadyaaqyaa-caI T@kovaarI
kaZUna D15 saolamaQyao dSa-vaa.
³ prIxaolaa basalaolyaa sava- iva.saM#yaa X 100À
p`vaoSa Gaolaolyaa ivadyaaqyaa-McaI ekUNa
saM#yaa ´
8) ]%tINa- ivadyaaqyaa-caI pirxaolaa basalaolyaa ekUNa
ivadyaaqyaa-cyaa tulanaot T@kovaarI D18 saolamaQyao

kaZa.
 ³ Paasa iva.Sao.inakala= ekUNa pasa ivadyaaqaI-
saM#yaa x 100Àpirxaolaa basalaolyaa ivadyaaqyaa-caI
ekUNa saM#yaa ´
9) INDAPUR saolacyaa AaoLIcaI ]McaI 24.75 kra.( Format  Row Height )

10) ) APPEARED STUDENTS yaa rkanyaacaI $MdI 14.5 kra.

11) Sheet cao naava “Mark List” Asao dyaa.(Format Rename Sheet)

12) SaovaTI Tobalalaa hvao tsao Formatting kra.

LUCKY COMPUTERS RAWANGAON

MS – Excel 2013
Assignment No.4
LIBRARY DETAILS
Sr. Quantity Issued Price in Available Bill
Book Name Author
No. in Stock Quantity Rs/copy Quantity Amount
1 INTERNET M. H. DIXIT 20 8 80 ? ?
2 WINDOWS 7 B. K. SAVANT 15 10 58 ? ?
3 MS-OFFICE 2013 S. N. JOSHI 22 16 110 ? ?
4 MULTI MEDIA A. S. KALE 32 15 255 ? ?
5 VISUAL BASIC S. G. MOGHE 28 8 157 ? ?
6 ORACLE M. L. SHAH 25 18 190 ? ?
7 MS-CIT J. O’LEARY 30 28 140 ? ?

Question:
1. TobalamaQaIla sava- AaoLIcaI ]McaI 30 pa^[-T [tkI kra.
2. Avaliable Quantity yaa rkanyaat laayab`arImaQaIla ]plabQa p`tIcaI
saM#yaa kaZa.
(Quantity Avaliable = Quantity in Stock – Issued Quantity )
3. Bill Amount yaa rkanyaat p`%yaok pustkacaI ikMmat kaZa.[ Issued
Quantity X Price per Copy ]
4. yaaogya fM@Sanacaa vaapr k$na savaa-t kmaI Stock AsaNaaáyaa
pustkaMcaI saM#yaa va pustkacao naava AnauËmao D15 va B15
saolamaQyao kaZa.³MIN ( ) yaa fM@Sanacaa vaapr k$na savaa-t
kmaI AsaNaaáyaa Stock maQaIla p`tIMcaI saM#yaa D15
saolamaQyao AaNaa.tr Copy va Paste cyaa sahayyaanao
pustkacao naava C14 saolamaQyao AaNaa´.
5. Available Quantity yaa rkanyaatIla savaa-t jaast AsaNaaáyaa ]plabQa
p`tIMcaI saM#yaa va pustkacao naava AnauËmao G14 va C14
saolamaQyao dSa-vaa.³MAX ( ) yaa fM@Sanacaa vaapr k$na jaast
AsaNaaáyaa ]plabQa p`tIMcaI saM#yaa G14 saolamaQyao
AaNaa tr Copy va Paste cyaa sahayyaanao pustkacao naava C14
saolamaQyao AaNaa´
6. yaaogya fM@Sanacaa vaapr k$na ivadyaaqyaa-naa idlaolaI
pustkMacaI ekUNa saM#yaa (Issued Quantity) E14 saolamaQyao kaZa.
7. yaaogya fM@Sanacaa vaapr k$na H15 saolamaQyao sava-
pustkaMcaI ekUNa ikmaMt kaZa.³ SUM yaa fM@Sanacaa vaapr kra´
8. ga`Mqaalaya saMga`hacaa saMpUNa- tpiSala ]plabQa p`tIMcaI
saM#yaa (Available Quantity) yaa inakYaavar caZ%yaa Ëmaanao
(Ascending Order ) tr pustkacao naava (Book Name) yaa inakYaavar ]tr
%yaa Ëmaanao (Descending Order ) laavaa.
9. Amount yaa rkanyaatIla sava- saM#yaa daona dSaaMSa sqaLapya-t
Gyaa.(Home  Number  Decimal Places - 2)
10. iSaTcao naava Library Derails Asao dyaa. (FormatSheet Rename)
11. SaovaTI Tobalalaa hvao tsao Formating kra.
12. tyaar kolaolaa Tobala panaacyaa ]Byaa va AaDvyaa sva$pat
maQyaBaagaI AaNaa.
³ Page Layout  Page Setup  Margins  Center on Page  Horizontally &
Vertically)
 RUSHIRAJ COMPUTER, BHIGWAN STATON
MS – Excel 2013
(PRACTICE) Assignment No. 8
REGIONWISE ORDER STATUS

PERCENTAGE
TOTAL
PROCESSED APPORVED REJECTED WORKING / VALUE FOR
REGION ORDERS
ORDERS ORDERS ORDERS PENDING PROCESSED
RECEIVED
ORDERS
NORTH 1200 1000 980 =1000-980 =1200-1000 =1000*100/1200
SOUTH 2000 1500 1340 ? ? ?
EAST 800 650 600 ? ? ?
WEST 1300 1100 1060 ? ? ?

1) “Approved” AaiNa “Rejected Order” caI sarasarI kaZuna

%yaacaa inakala saola E15 AaiNa F15
maQyao AnauËmao dSa-vaa.( Average( ) caa vaapr
kra)
2´ yaaogya Function caa vaapr k$na¸ Total Order Received,
Processed Order AaiNa
Total Number of Approved Orders caI saM#yaa kaZa va %yaa
Anaukmao C14, D14, E14 yaa saolamaQyao
dSa-vaa.
3´“Processed Order” cyaa tulanaot “Approved Order” AaiNa “Rejected
Order” caI T@kovaarI
kaZuna tI AnauËmao E16 va F16 yaa saolamaQyao
dSa-vaa.
4´“Approved Order” rkanyaatIla maaihtI Clear kra AaiNa tI
900,1200,520,1000
ASaI ]Byaa maaMDNaIt (Vertical Order) Bara “Approved Order”
AaiNa“ ProcessedOrder” yaaMcaI
baorIja k$na tI saola D12, E12 maQyao daKvaa.
5´TOTAL Received Order maQauna Processed Order caI T@kovaarI
kaZuna tI Cell D13 maQyao dSa-vaa.
6´G7,G8,G9,G10 saolamaQyao AnauËmao 50, 11, 65, 96 ikMmatI
Gaalaa va %yaaMcaI (G7 to G10) baorIja G13
saolamaQyaofM@Sanacaa vaapr k$na dSa-vaa.
7) “Total Orders Received” rkanyaatIla maaihtI “Processed Orders”
rkanyaat ka^pI kra va
“Rejected Orders” rkanyaatIla “Rejected Orders” caI saM#yaa
kaZa.
8´ kmaItkmaI “Approved Orders” caI saM#yaa AsaNaaáyaa
ivaBaagaacao naava B15 yaa saolamaQyao dSa-vaa
AaiNa Approved Order caI saM#yaa E18 maQyao dSa-vaa.
9´Header and Footer kmaaMDcyaa sahayyaanao panaacyaa
varIla baajaUsa svat:caa p%ta ilaha tr panaacyaa
tLaSaI ³ Footer ´ maQyao poja naMbar ( Page 1 of ?) yaa
fa^rma^TmaQyao Va.
RUSHIRAJ COMPUTER, BHIGWAN STATON
MS – Excel 2013
Assignment No.5
PRODUCT PURCHASE DETAILS

Bill Bill
Item Product Unit Available Purchase Amount Amount
Discount
No Names Price Quantity Quantity without with
Discount Discount
11 Rice 55.00 20 5.00% 3 ? ?
12 Wheat 09.50 50 5.00% 30 ? ?
13 Jawar 08.40 54 5.00% 25 ? ?
14 Dal 18.00 12 5.00% 10 ? ?
15 Coconut 08.00 30 5.00% 20 ? ?
16 Bajara 07.25 25 5.00% 05 ? ?

Question :
1´ KrodI kolaolyaa vastuMcaI [PURCHASE QUANTITY] ikMmat DISCOUNT na dota
BILL AMOUNT WITHOUT

DISCOUNT yaa rkanyaat kaZUna ekUNa ibalaacaI r@kma %yaaca

rkanyaaKalaI 14 naMbarcyaa saolamaQyao dSa-vaa.
(BILL AMOUNT WITHOUT DISCOUNT = PURCHASE QUANTITY X UNIT PRICE)

2´ sava- vastMUcaI DISCOUNT dovaUna ibalaacaI r@kma BILL AMOUNT WITH

DISCOUNT yaa rkanyaat kaZa.

=³vastUcaI KrodI ikMmat ¹³vastUcaI KrodI ikMmat X

iDska}MT´´ x KrodI kolaolyaa vastUcaI saM#yaa

3´ Quantity Available yaa rkanyaatIla saM#yaa 18 poxaa jaast Asalyaasa RED

COLOUR nao dSa-vaa.%yaakrIta

CONDITIONAL FORMATING caa vaapr kra.
4´ TobalamaQaIla sava- AaoLIMcaI ]McaI 28 pa^[-T [tkI kra.
5´ LEN fM@Sanacaa vaapr k$na vastUcao naava - COCONUT yaa SabdatIla
AxaraMcaI saM#yaa D15 saolamaQyao dSa-vaa.
6´ B to K AdyaaxarapasaUna sau$ haoNaaáyaa vastUMcaI naavao laala
rMgaanao dSa-ivaNyaasaazI “PRODOCT NAME” yaa
rkanyaacao fa^rma^iTMga kra [CONDITIONAL FORMATING COMMAND vaapra ].

7´ PURCHASE QUANTITY yaa rkanyaacyaa KalaI daona saola irkamyaa

saaoDUna COUNT FUNCTION vaap$na KrodI kolaolyaa
vastUcaI saM#yaa kaZaÀmaaojaa.
8´ Bill Amount yaa rkanyaatIla sava- sa#yaa 2 dSaaMSa sqaLapaya-Mt
dSa-vaa.
(Home  Number  Decimal Places)

9´SaovaTI PRODUCT NAMEvaUNIT PRICEyaa daona rkanyaatIla maaihtIcyaa

AaQaaro caaT- tyaar kra.
9´ 12 $pyaaMpoxaa kmaI ikMmat Asalaolyaa vastUvar 8% tr 12 poxaa
jaast ikMmat Asalaolyaa vastUvar 15% savalat dyaa.[IffM@Sanacaa
vaapr kra IF(Unit Price <12, “8%”, “15%”)]
 LUCKY COMPUTERS RAWANGAON

ASSIGNMENT No. 6

SSC STUDENT EXAM RESULT SHEET

%age
Seat Social Total
Student Names Marathi Hindi English Maths Science %age Wise
No. Science Marks
Result
111 Manish Kale 68 65 62 98 110 81 ? ? ?
112 Raju Pawar 50 53 54 68 75 62 ? ? ?
113 Nilesh Parkale 66 65 48 75 112 80 ? ? ?
114 Sunita Mane 74 75 75 74 116 90 ? ? ?
115 Anita Shirke 52 43 52 65 70 54 ? ? ?
116 Ramesh Sakhare 63 57 36 74 59 49 ? ? ?
117 Sunil Kajale 57 56 55 65 58 60 ? ? ?
118 Avinash Giramkar 57 65 52 80 76 58 ? ? ?
119 Shailaja Shaikh 76 68 48 100 120 80 ? ? ?
120 Mangal Patil 68 69 66 115 118 90 ? ? ?

sava-p`qama Table Formatting kra.³ Row Height 26¸ Border,

Alignment saoT kra)
1´ Total rkanyaat sava- ivaYayaaMcao ekUNa gauNa kaZa.³
%yaakirta Aa^Taosama (  ) fM@Sanacaa vaapr kra.´
2´ Percentage rkanyaat ivaVaqyaa-McaI T@kovaarI
kaZa.³T@kovaarI = p`aPt gauNa X 100 À ekUNa gauNa´
3´ Result rkanyaat ivaVaqyaa-Mcaa inakala Pass Aqavaa Fail KalaIla
ATIp`maaNao kaZa.
AT : pasa – T@kovaarI 35 ikMvaa 35 poxaa jaast
AsaavaI.
naapasa – T@kovaarI 35 poxaa kmaI AsaavaI.
If
Logical Test Per >= 35

Value_if_true PASS

Value_if_false FAIL

4´ Fail ivaVaqyaa-Mcaa Result laala rMgaanao daKvaa.%yaakirta

Conditional Formatting kmaaMD vaapra.
5´ ivaVaqaI- naava va T@kovaarI yaa daona rkanyaaMcyaa
AaQaaro AalaoK ³ Column Chart´ tyaar kra.
6´ savaa-t jaast T@kovaarI AsaNaara ivaVaqaI- sava-p`qama
yao[-la ASaa pd\QatInao ËmavaarI laavaa.³ Sorting kmaaMDcaa
vaapr kra´
7´ Sheet cao naava SSC Student Result Asao dyaa.³ Sheet 1 var Dbala
i@lak k$na iSaTcao naava badlaa´ va
T^ba klar Purple Va. [ Home Format  Tab Colour  Purple
colour]
 RUSHIRAJ COMPUTER INSTITUTE, BHIGWAN
MS – Excel 2013
Assignment No. 7

BILT GRAPHIC PAPERS LTD., BHADALWADI

Pune – Solpaur Highway, Near Bhigwan
Tal.- Indapur, Dist – Pune

Working Payment
Sr. No. Employee Name City / Village Joinig Date Salary
Days per Day

1. Nilesh Shinde Bhigwan 03/25/2013 26 250 ?

2. Balu Pawar Takrarwadi 04/24/2013 27 250 ?

3. Amol Mali Diksal 05/25/2013 25 230 ?

4. Mahesh Sapkal Bhigwan 08/10/2014 28 250 ?

1) Bhigwan, Takrarwadi, Diksal, Bhadalwadi, Dalaj, Madanwadi yaa p`

%yaok SahrasaazI
5– 5 kamagaaraMcyaa naavaaMsah saMpuNa- maaihtI varIla
TobalamaQyao Bara.
2) Salary yaa ka^lamamaQyao Salary = Working Days x Payment per
Days yaa sau~acaa vaapr kra.
3) Joining Date yaa ka^lamamaQaIla sava- tarKa 14 March 2001 yaa
fa^rma^TmaQyao badlaa.
[ Format Number  Date March 14, 2001]
4) Salary yaa rkanyaatIla sava- saM#yaa Currency (Rs. 6,500.00) yaa
fa^rma^TmaQyao badlaa.
[ Format Number  Currency  Symbol Rs.]
5) TobalamaQaIla sava- maaihtI City / Village yaa rkanyaakirta
AlfabaoTIklaI (A-Z) Sorting kra.
6) DataSubtotalAt each change in City / Village Use Function – Sum
Add Subtotal to  Working Days va Salary yaa pwtIcaa AvalaMba
 k$na Sahranausaar kamaacao idvasa va pgaar yaaMcaI
sabaTaoTla kaZa.
7) Format Sort and Filter ikMvaa Data Filter yaa kmaaMDcyaa
sahayyaanao iflTr kmaaMDcaa vaapr k$na kaoNa%yaahI
daona SaharaMcaI saMpuNa- maaihtI daKvaa.
8) naMtr iflTr kmaaMD baMd kra.
9) SaovaTI TobalacaI sTa[-la KalaIlap`maaNao badlaa.
[ Format Format as Table  Table Style Medium 17].

RUSHIRAJ COMPUTER, BHIGWAN STATON

MS – Access 2013
Assignment No.01

1´p`qama My Document maQyao tumacyaa naavaacaa ek faolDr

tyaar k$na %yaamaQyao punha Access 1 naavaacaa dusara
faolDr (Subfolder) tyaar k$na %yaamaQyao Student1.accdb naavaacaa
DoTabaosa tyaar kra.
2´KalaIla maahItIcyaa AaQaaro Design View maQyao Tobala tyaar
kra.
Field Name Data Type Field Properties
Roll _No Number Long Integer
First Name Text Field Size -18
Middle Name Text Field Size – 17
Last Name Text Field Size -16
City Text Field Size -20
Admission_ Date Date/Time Short Date
Fees Currency -----------
Address Text Field Size -25

3´Tobalalaa Student ho naava dovaUna saovh kra¸ prMtu %yaa

vaoLI Primary Key doNyaasaazI ivacaarlao Asata No baTnavar i@lk
kra va SaovaTI Table saovh k$na baMd kra.
4´taoca Tobala punha Design View Aaopna k$na %yaamaQyao
KalaIla badla kra.
1´ First Name yaa iflDcyaa Agaaodr Title ho navaIna iflD
samaaivaYT kra.
³p`qama Tobala Design View maQyao Aaopna k$na jyaa
iflDcyaa Agaaodr naivana iflD samaaivaYT
kravayaacao Aaho %yaa
iflDmaQyao i@lak k$na Insert Row hI kmaaMD vaap$na
irkamaI AaoL AaNaNao va jao iflD hvao Aaho to
ilaihNao.´
2´ Admission Date yaa iflDcaI Date/Time Property - Medium Date ASaI saoT kra.
³p`qama Tobala Design View Aaopna k$na jyaa iflDcaI
Property badlaayacaI Aaho %yaa iflDmaQyao i@lak k$na
Properities maQaUna hvaa tao badla kravaa.´
3´ First Name yaa iflDcaI Field Size Property 18 eovajaI 15 saoT kra.
4´ Address ho iflD Tobala maQaUna Delete kra.
³p`qama Tobala Design View maQyao Aaopna k$na jao iflD
iDlaIT krayacao Aaho to isalao@T k$na Design  Delete Row )

5´SaovaTI Tobala punha saovh k$na baMd kra.

6´Tobala punha Aaopna k$na %yaamaQyao 10 ivadyaaqyaa-
caI maaihtI ³Records´Bara.
 RUSHIRAJ COMPUTER, BHIGWAN STATON
MS – Access 2013Assignment No.02

1´ tumacyaa faolDrmaQaIla Student.accdb naavaacaI Database

fa[-la Aaopna kra.
2´ KalaIla maahItIcyaa AaQaaro Design View maQyao
navaIna Table tyaar kra.
{ Create Tab  Table Design}

Filed Name Data Type Field Properties

Lib_Card_No. Text Field Size - 12
Book_ Name Text Field Size - 20
Author Text Filed Size - 15
Book_Rec_Date Date/Time Medium Date
Price Currency Currency
3´Tobalalaa Liabrary Asao naava dovaUna Table saovh kra.
4´ Tobala Design View maQyao Aaopna k$na Lib_Card_No. yaa
iflDlaa Primary Key saoT kra.
{ Tobala Home  Design View maQyao Aaopna k$na jyaa
iflDlaa Primary Key dyaavayaacaI Aaho to
iflD p`qama isalao@T kravao naMtr Design Tab  Primary
Key yaa kmaaMDvarÀ caavaIcyaa icanhavar
i@lak kravao.}
5´ Roll_No ho naivana iflD Library yaa TobalamaQyao
savaa-t SaovaTI Insert k$na Tobala saovh kra.
{ p`qama Tobala Design View maQyao Aaopna k$na
savaa-t SaovaTcyaa iflDcyaa KalaIla AaoLIt
varIla iflD
Ta[-p kravao.}
6´ Student Table maQyao tumhI ilaihlaolao Roll Numbers punha
Library TobalamaQaIla Roll_No yaa
 iflDmaQaIla rkanyaat kaoN%yaahI Ëmaanao ilaha.
7´ Table saovh k$na %yaamaQyao 8 pustkaMcaI maaihtI
Bara.
8´ Student Table Design View maQyao Aaopna k$na
%yaamaQaIla Roll_No yaa iflDlaa Primary Key Va.
8´ Student TablevaLiabrary Table yaa daona TobalamaQyaoRoll_No
yaa iflDcaa vaapr k$na
Relationshiptyaar kra.
{1´Database ToolsRelationships yaa kamaaMDvar i@lak
kravao. 2´Aalaolyaa Show Table ivaMDaotIla daona
Tobala pOMkI p`qama Student Table Select k$na Add kra¸
naMtr Library Table Select k$na Add kra va Saao Tobala
ivaMDao baMd kra. 3´naMtr Student Table maQaIla Roll_No
ho iflD maa}sanao dabaUna AaoZt AaNaUna
samaaorIla Library Table maQaIla savaa-t SaovaTIcyaa
Roll_No yaa iflDvar saaoDa va Create baTnavar i@lak kra }
9´ SaovaTI Student Tobala Aaopna k$na Relationship caok
kra.
RUSHIRAJ COMPUTER, BHIGWAN STATON
MS – Access 2013
Assignment No.03

KalaIla iflDsa\ vaap$na Tobala tyaar kra va

KalaIla maaihtI %yaamaQyao Bara.
TableName :Employee
Emp_No. Emp_Name City Department Salary
1. Ramesh Khade Baramati Sales 7,500.00
2. Sachine Mane Bhigwan Purchase 6,700.00
3. Nitin Jagtap Pune Sales 6,300.00
4. Mahesh Kajale Baramati MIS 15,000.00
5. Raju Naik Bhigwan Purchase 7,000.00
6. Satish Shinde Baramati Workshop 5,400.00
7. Amol Parkale Bhigwan MIS 12,500.00
8. Nilesh Pawar Pune Sales 6,000.00
9. Sanjay Shirke Baramati Workshop 7,500.00
10. Ajit Virkar Pune MIS 13,400.00

varIla maaihtIcyaa AaQaaro KalaIla Query tyaar kra.

Que.1) EmployeeTable maQaUna Emp_Name, City, Salary ho iflDsa\
inavaDUna Query – Design View
cyaa AaQaaro tyaar k$na qry_emp_1 yaa naavaanao
saovh kra.
Que.2) EmployeeTable maQaUna Emp_No., Emp_Name, City inavaDUna
jyaaMcaI City - Bhigwan Aaho
ASaa laaokaMcaI yaadI imaLivaNyaasaazI Query
ilaha.
Que.3) Purchase Department laa kama krt AsaNaaáyaa sava-
kamagaaraMcaI yaadI daKivalaI jaa[-la ASaa
p`karo Query ilaha.
Que.4) jyaa kamagaaracaa pgaar 6500/- poxaa jaast Aaho
ASaa kamagaaraMcaI yaadI dSa-ivaNaarI Query ilaha.
Que.5) jao laaok “baaramatI” yaoqao rahNaaro Aahot
prMtu to Workshop maQyao kama krIt AsatIla ASaa
laaokaMcaI yaadI dSa-ivaNaarI Query ilaha.
Que.6) “Sachin Mane” yaa kamagaaracaI saMpUNa- maaihtI
dSa-ivaNaarI Query ilaha.
Que.7) idlaolyaa DoTabaosamaQaUna iBagavaNa
ikMvaa baaramatI yaa SahramaQyao rahNaaáyaa
laaokaMcaI yaadI dSa-ivaNaarI
Query ilaha.
Que.8) Que.6 maQaIla Query – Design View maQyao Aaopna
k$na“saicana maanao” eovajaI “mahoSa kajaLo”
Asao naava Ta[-p k$na Query Run kra.
 RUSHIRAJ COMPUTER, BHIGWAN STATON
MS – PowerPoint 2013
Assignment No.1

KalaIla maaihtIcyaa AaQaaro Presentation tyaar kra va

%yaamaQyao p`%yaok slaa[-Dvar yaaogya to ica~
samaaivaYz kra.

Slide No.1 ) WELCOME ( vaD-AaT-caa vaapr kra )

INFORMATION ABOUT COMPUTER
Slide No.2 )
Types of Computer
Mainframe Computer.
Super Computer Computer.
Mini Computer
Micro Computer.
Slide No.3) Types of Keyboard
Traditional K/B.
Ergonomic K/B
Flexible / Folding K/B
Wireless K/B
Handheld K/B
Slide No.4) Types of Keys on Keyboards
Function Keys
Alphabetic Keys
Numeric Keys
Arow Keys / Cursor Movement Keys/Navigation Keys
Modifier Keys
Toggle Keys
Slide No.5) Types of Storage Devices Slide No.6 ) THANKING YOU
Primary Memory
RAM
ROM
CMOS
Secondary Memory
Floppy Disk
Hard Disk
Optical Disk ( CD / DVD )
Magnetic Tape