MBEL-PC Package

MBEL-PC Package

PC Package


Part - 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.


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 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?


b) =

c) <



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


Quick Find
Use keywords to find the product you are looking for.
Advanced Search
0 items
Share Product

osCommerce Online Merchant Copyright © 2010 osCommerce
osCommerce provides no warranty and is redistributable under the GNU General Public License
Note: We provide all Solutions and Contents for Reference/Study purpose only.