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