Saurastra University 2006 Diploma Computer Engineering Networking & Web Page Designing - Question Paper
*SP-5362*
SP-5362 Seat No._
Diploma in Computer Science Examination
April/May - 2006 Spread Sheet Management & Word Processing
Time : 3 Hours] [Total Marks : 100
[WINDOWS]
1 PfCiPe EaeU eOu N (Au' r) 20
(1) GUI OBiA Windows o/s Pi AelgYOu gUZau.
(2) My Computer OB EiA PuO aAu.
(3) Windows Explorer Pf pOYulAOe gUZau.
(4) Recycle Bin OB EiA PuO aAu.
(5) Disdplay Properties feYauA UuZe gUZau.
(6) Taskbar Properties feYauA UuZe gUZau.
[WORD]
2 PfQiPe EaeU eOu N (Au' 12) 20
(1) UagEA Pi USEiaaa UlalEA gUZau.
(2) Mail Merge Pf gAafOe gUZau.
(3) Page Setup feYauA UuZe gUZau.
(4) Table Management Pf gAafOe gUZau.
(5) af eE P @aiO eEPi gAafOe gUZau.
(6) Indents PTabs gUZau.
3 PiQjPe EaeU eOu N (Au' 12) 20
(1) afPe VEeLfli EaUeBPe Au' OeQ ulaP gUau.
(2) afPe TuUjEUA EaUeBPe Au' OeQ ulaP gUau.
(3) ali OugjgB OB EA PuO aAu.
(4) VOjaUA Pj AeUB UeEPi gAafOe gUau.
(5) Find Pj Replace gAafOe gUau.
(6) aljUe Text ae 'PUjLEPf gAafOe gUau.
[EXCEL]
4 PiQjPe EaeU eOu N (Au' 12) 20
(1) A Spread sheet OAE OBfA Excel Pf lalalEOe gU1/2au.
(2) Absolute Relative Pj Mixed BIBLg gUau.
(3) QeEiPe OAeB EHeeai Excel Ue QeEi OiYeB ABae UeEPe Steps gUau.
(4) Fill Handle Pj Custom list Pf gAafOe gUau.
(5) Work Book, Work Sheet PjWork Space Pu AYea
VOlE ABu.
(6) Excel Ue IiSEB Pj jfaeLg I1SEBP1 gAafOe gUau.
5 PiQjPe T@aP gUau N (Au' &) 20
|
IF ( ) |
HLOOKUP ( ) |
VLOOKUP ( ) |
|
NOW ( ) |
PROPER ( ) |
POWER ( ) |
|
SUM/F ( ) |
COUNT ( ) |
WEEKDAY ( ) |
|
REPT ( ) |
MID ( ) |
MIN ( ) |
|
MAX ( ) |
LOWER ( ) |
AVERAGE ( ) |
1 Attempt for following : (any four) 20
(1) Explain features of Windows o/s as GUI.
(2) Write short note on 'My Computer'.
(3) Write uses of Windows Explorer.
(4) Write short note on 'Recycle Bin'.
(5) Explain Display properties Dialog Box.
(6) Explain Taskbar properties Dialog Box.
2 Attempt for following : (any four) 20
(1) Explain Bulleting & Multilevel Bulleting.
(2) Explain Mail Merge Facility.
(3) Explain Page Setup Dialog Box.
(4) Expalin Table Management Facility.
(5) Explain facilities of Word Art & Clip Art.
(6) Explain Indents and Tabs.
3 Attempt for following : (any four) 20
(1) Explain any five options of standard tooblars of word.
(2) Explain any five options of formatting toolbars of word.
(3) Write short note on word processing.
(4) Explain facilities of Spelling and Grammar.
(5) Explain facilities of Find and Replace.
(6) Explain Facilities of Text Alignment of MS Word.
(1) Explain features of MS Excel as a spreadsheet package.
(2) Explain Absolute, Relative and Mixed Reference.
(3) Give types of Charts ? Explain steps for creating a chart in Excel.
(4) Explain facilities of Fill Handle and Custom List.
(5) Explain concept of Work Book, Work Sheet and Work Space.
(6) Explain facilities of Filter and Advance Filter in Excel.
5 Explain following functions : (any ten)
20
|
HLOOKUP ( ) PROPER ( ) COUNT ( ) MID ( ) LOWER ( ) IF ( ) NOW ( ) SUM/F ( ) REPT ( ) MAX ( ) |
VLOOKUP ( ) POWER ( ) WEEKDAY ( ) MIN ( ) AVERAGE ( ) |
SP-5362] 4 [ 2000/51-47 ]
|
Attachment: |
| Earning: Approval pending. |
