PC Package V1

Contact www.solvedcare.com for best and lowest cost solution or email solvedcare@gmail.com

PC Package V1

Assignment A
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.
(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
Assignment 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.
3
a) Explain the uses of finding files/folders option and run command.
b) 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.
Assignment C
1. 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
2. If you needed to create a slide presentation, which Office program would you use?
a. Excel
b. Publisher
c. PowerPoint
d. Word
3. 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.
4. 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
5. 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.
6. 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.
PC Package
Copyright © Amity University
7. 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.
8. 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
9. To get Help when using Office, you would click the:
a. F2 Key
b. F1 Key
c. F10 Key
d. ESC Key
10.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
11.Which of the following is word processing software?
a) Microsoft Word
b) Microsoft Excel
c) Microsoft Internet Explorer
d) Microsoft Windows Explorer
12. What is the size of a standard floppy disc?
a) 4 1/2 ”
b) 2 1/2 ”
c) 3 1/2 ”
d) 5 1/2 ”
13.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
PC Package
Copyright © Amity University
14.When the text automatically goes onto the next line this is called
a) text wrap
b) page wrap
c) word wrap
d) wrap word
15. 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
16. 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
17. 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
18. Left justify is the same as
a) Align left
b) Align centre
c) Align right
d) none of the above
19.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
20. 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
21. Which of the following is spreadsheet software?
a) Microsoft Word
b) Microsoft Excel
PC Package
Copyright © Amity University
c) Microsoft Internet Explorer
d) Microsoft Windows Explorer
22. Excel Workbooks can contain several
a) pages
b) chapters
c) worksheets
d) workbooks
23. To automatically fit text in cells you can use
a) Column Auto Selection
b) Column AutoFit Selection
c) Row AutoFit Selection
d) Column Selection
24. Which of the following is a correct cell address in Excel?
a) Row1
b) Cell1
c) 1A
d) A1
25. Bold, italic, underline and alignment are _____ options.
a) formatting
b) fancy
c) Excel
d) workbook
26.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
27. Which of the following is NOT a number format available in Excel?
a) fraction
b) decimal
c) percentage
d) text
28. To keep table headings visible you can use
a) Hold Headings
b) Freeze Headings
c) Freeze Panes
d) Hold Panes
PC Package
Copyright © Amity University
29. Which of the following is presentation graphics software?
a) Microsoft Word
b) Microsoft Excel
c) Microsoft Internet Explorer
d) Microsoft PowerPoint
30. Which of the following is NOT a PowerPoint view?
a) Normal
b) Slide Sorter
c) Web
d) Outline
31. Which view shows the slide presentation in full screen?
a) Normal
b) Slide Sorter
c) Slide Show
d) Outline
32. 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
33. 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
34. 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
35. 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

Contact www.solvedcare.com for best and lowest cost solution or email solvedcare@gmail.com

Comments are closed.