PC Package
Part – A
Contact Us for this solution
1(a) What is
Graphical User Interface? Discuss the use of status bar, title bar and menu bar
in detail?
2 What is a mail
merge? Discuss mail merge concepts with a suitable example.
3. Explain the
following operations with an example.
(a) Copy a text and
place in another position
(b) Create table
with 5 rows and 3 columns
(c) Adding a page
numbers in the center of the page
(d) Set the
margins.
4. (a) What is
worksheet? How does it differ from spreadsheet? What are the data types placed
in a cell? Explain.
(b) Discuss the
facilities available to format the data in the cell with an example.
5(a)What is a chart?
Discuss step by step to create various types of chart using the given set of
data.
5 (b) Discuss
various operations in MS - ACESS with an example.
(a)
Delete a field
(b)
Insert a record
(c)
Sorting the records
(d)
Creating and printing reports
Part - B
1 (a) List the
benefits for PowerPoint facility in MS-OFFICE
(b) Give a suitable
operational sequence to do the following:
(i) Insert a
picture in the slide
(ii) Add an excel
sheet
(iii) Add date and
time in all the slides.
2. Write short
notes on:
(a) Find and
replace a text in Word
(b) Functions in
Excel
(c) Creating table
with constraints
(d) Format the
slides in PowerPoint.
3a) Explain the
uses of finding files/folders option and run command.
3b) What are the
steps involved in indenting, paging and changing margins in word document?
c) How will you
perform a spell check and auto text in word?
d) State the
procedure for using chart wizard. How would you choose the appropriate chart?
e) How to change
the 'column width' and use 'paste' function in Excel?
f) Explain creating
and using Auto forms in Access.
g) State the steps
for creation and sizing of an organizational chart in PowerPoint?
h) Explain the
Calendar views available in MS outlook.
i)What are the
functions and uses of title bar, status bar, menu bar and tool bars in Windows?
j) Explain the
steps involved in inserting, moving and resizing of pictures and their
printing.
k) What are the
uses of formula function? Explain with examples the uses of "sum"
function in Excel.
l) Discuss the
creation, entering and editing a Table' in Access.
4. Discuss the
transition and animation effects in slides and state how you will perform a
slideshow.
5. What are the
utilities available in MS outlook for E-mails? Comment on it.
Part
- C
Q1. What is the
best way to find out what version of Office you're using?
a. Watch for the
"splash" screen when it opens
b. Check the front
of your user manual
c. Click Help/About
d. Look into the
Help files under Version
Q2. If you needed
to create a slide presentation, which Office program would you use?
a. Excel
b. Publisher
c. PowerPoint
d. Word
Q3. Which of these
statements are true about VBA?
a. It stands for
Visual Basic Automation.
b. A macro
programming language used by Office applications.
c. It's the visual
animation feature in Power Point.
d. V. B. Allan, the
guy who started Microsoft with Bill Gates.
Q4. In Word, which
is the best view to use if you're running low on resources?
a. Print Preview
b. Outline View
c. Page Layout View
d. Normal View
Q5. In Access,
you've been working on your database a lot lately and you notice it's getting
quite large. What's the best thing to do to be sure it's at it's most efficient
size?
a. Delete any
unnecessary data entries and resave it.
b. Sort the
database in alphabetical order to compact it.
c. Use the Repair
and Compact option on the Tools menu.
d. Click
File/CompressDatabases.
Q6. If you wanted
to create your own new toolbar in an Office application, with all your favorite
features, what would you do first?
a. Call someone who
knows how to do it. It's always easier to bother someone else than to learn it
yourself.
b. Click
Tools/Customize/Commands and drag the features you want onto a toolbar and
rename it to a new name.
c. Click Tools/Customize/Toolbars/New
to create a new toolbar, then drag items onto it.
d. Click
View/Toolbars/New to create a new toolbar.
Q7. In Word, if you
needed to pass a macro to another computer, how would you do it?
a. Use the
Organizer to pass the macro to another template and have the recipient copy it
to their normal.dot also using the Organizer.
b. In the VB
Editor, export the code into a .BAS file and import it on the other system.
c. Save the macro
to a new template and put it in your Office StartUp directory.
d. All of the
above.
Q8. Excel is an
Office program that you can use to create:
a. A database
b. A spreadsheet
c. A pie chart
d. All of the above
Q9. To get Help
when using Office, you would click the:
a. F2 Key
b. F1 Key
c. F10Key
d. ESC Key
Q10.To turn on the
Office Shortcut Bar:
a. Click
Start/Programs/Office Shortcuts
b. Click
Start/Programs/Microsoft Office Tools/Microsoft Office Shortcut Bar.
c. In any Office
program, click Windows/Shortcut Bar.
d. There is no such
thing as an Office Shortcut Bar
Q11. Which of the
following is word processing software?
a) Microsoft Word
b) Microsoft Excel
c) Microsoft
Internet Explorer
d) Microsoft
Windows Explorer
Q12. What is the
size of a standard floppy disc?
a) 4 V
b) 2 V2 "
c) 3 V2 "
d) 5 V2 "
Q13.Where should
you save your computer files?
a) on disc and in
folders
b) in a draw
c) in a filing
cabinet
d) in the bin
Q14.When the text
automatically goes onto the next line this is called
a) text wrap
b) page wrap
c) word wrap
d) wrap word
Q15. Before
printing a document you should always
a) use the Print
button
b) use Print
Preview
c) use the Print
button and then Print Preview
d) edit your
document
Q16. WYSIWYG is
short for
a) when your seen
is what you get
b) what you see is
why you get
c) when you see is
why you get
d) what you see is
what you get
Q17. When entering
in a lot of text in capitals you should use the
a) Enter key
b) Ctrl key
c) Caps Lock key
d) Insert key
Q18. Left justify
is the same as
a) Align left
b) Align centre
c) Align right
d) none of the
above
Q19.Using the Bold
feature is a way of
a) splitting up
paragraphs
b) making the text
less readable
c) enhancing the
appearance of certain text
d) showing off your
skills
Q20. To put text on
the right of the page use the
a) Align left
button
b) Align center
button
c) Justify button
d) Align right
button
Q21. Which of the
following is spreadsheet software?
a) Microsoft Word
b) Microsoft Excel
c) Microsoft
Internet Explorer
d) Microsoft
Windows Explorer
Q22. Excel Workbooks
can contain several
a) pages
b) chapters
c) worksheets
d) workbooks
Q23. To
automatically fit text in cells you can use
a) Column Auto
Selection
b) Column AutoFit
Selection
c) Row AutoFit
Selection
d) Column Selection
Q24. Which of the
following is a correct cell address in Excel?
a) Rowl
b) Celll
c) lA
d) Al
Q25. Bold, italic,
underline and alignment are options.
a) formatting
b) fancy
c) Excel
d) workbook
Q26. Which of the
following is NOT an appropriate UK date setting?
a) 14/03/2002
b) 03/27/2002
c) 14/03/02
d) 14 March 2002
Q27. Which of the
following is NOT a number format available in Excel?
a) fraction
b) decimal
c) percentage
d) text
Q28. To keep table
headings visible you can use
a) Hold Headings
b) Freeze Headings
c) Freeze Panes
d) Hold Panes
Q29. Which of the
following is presentation graphics software?
a) Microsoft Word
b) Microsoft Excel
c) Microsoft
Internet Explorer
d) Microsoft
PowerPoint
Q30. Which of the
following is NOT a PowerPoint view?
a) Normal
b) Slide Sorter
c) Web
d) Outline
Q31. Which view
shows the slide presentation in full screen?
a) Normal
b) Slide Sorter
c) Slide Show
d) Outline
Q32. With which
view you can see the main textual features that make up the slides of a
presentation?
a) Normal
b) Slide Sorter
c) Slide Show
d) Outline
Q33. What can you
can apply to a presentation to give it a fully designed, professional look?
a) design templates
b) design plates
c) pictures
d) text
Q34. To ensure that
you don't lose you work you should
a) print it
regularly
b) copy it
regularly
c) edit it
regularly
d) save it
regularly
Q35. Transition
effects take place
a) when you save
your work
b) between slide
changes
c) when text
scrolls onto the slide
d) none of the
above
Q36. Animation
effects take place
a) when you save
your work
b) between slide
changes
c) when text
scrolls onto the slide
d) none of the
above
Q37. Each new slide
should be chosen with a style.
a) slide layout
b) slide format
c) slide edit
d) slide save
Q38. If the slide
show runs automatically how do you stop the slides?
a) with the Shift
key
b) with the Enter
key
c) with the Esc key
d) with the Ctrl
key
Q39. Which symbol
shown below means greater than?
a)<>
b) =
c) <
d)>
Q40. To temporarily
search for a specific set of data in a list you should use
a) arrange
b) filter
c) edit
d) re-arrange
No comments:
Post a Comment