Office Automation

Q:No:1: Tick the correct one:

1. The extension of Ms-word document is _____________________.
         a) BMP        b) DOC          c) TXT          d) XLS

2. In Ms-word, to select the whole document, we use ________________.
         a) F1            b) Alt +F        c) Ctrl + A          d) None these

3. In Ms-Word, to insert page break, we can use _____________ key combination.
        a) Alt + Enter          b) Ctrl + Enter         c) Shift + Enter      d) None of these

4. If we want to save an existing save document by pressing CTRL + S, which procedure will be          run?
        a) Save as        b) Save          c) Search          d) Send

5. The Text which comes on top of every page is called _________________
        a) Heading           b) Top             c) Header            d) Footer

6. Shift + F7 is the shortcut of __________________________
        a) Thesaurus        b) Spelling and Grammar       c) Mail Merge       d) Option

7. When you press ____________ key, MS-word Automatically creates a new Paragraph.
        a) Ctrl + Enter      b) Shift + Enter        c) Enter        d) None of these

8. The Word "Wrap Text".
         a) Automatically moves text to the next line when necessary
         b) Appears at the bottom of the document
         c) Allow you to type over text
         d) None of the above

9. ____________ command save the Active files with New File Name.
         a) Save         b) Save As         c) Save As web       d) Version

10. A chart that shows how various values make up a whole is known as _______________
         a) Function       b) Line Graph       c) Pie Chart          d) None of these

11. The Default Name of MS-Excel File is ________________.
         a) Worksheet           b) Workbook          c) Book                d) None of these

12. In Auto Format command we use the ____________ templates to format our worksheet.
         a) Pre-Designed         b) Blank           c) None Pre-Designed       d) None of these

13. Cell Edit key in Excel is _______________________.
         a) F4            b) F2           c) F1              d) Ctrl + F2

14. To drag a selected range of the data to another worksheet in the same workbook, use the 
        a) Tab key           b) Alt Key          c) Ctrl Key          d) None of these

15. MS Excel has maximum __________ number of Column.
        a)  256          b)  65536       c)  6536           d) None of these

16. Microsoft Excel is an Electronic _________________
        a) Worksheet        b) Record book         c) Workbook          d) None of these

17. MS Excel Product of ______________________
        a) Sun Micro System         b) Macromedia          c) Micro Soft         d) Multi Software System

18. By the help of ___________ function we can adds all the numbers in a range of cells.
        a) Count( )            b) Sum( )           c) Add( )             d) Total ( )

19. In Excel, ____________ Command is used arrange data in Ascending or Descending order.
        a) Data---> Sort      b) Data-----> Index     c) Data --->Order     d) Tools--->Sort  

20. MS- Excel Database is limited to the number of rows in worksheet__________.
        a) 65536           b) 65000         c) 40000              d) 256

Q:No:02: Write the purpose of the following Short Keys:

1. Alt + F + S  :   ___________________________________________________________

2. Ctrl + B  :       ___________________________________________________________

3. Ctrl + U  :      ___________________________________________________________

4. Ctrl  + Z  :      ___________________________________________________________

5. Ctrl + I   :       ___________________________________________________________

Q:No:03: Write the purpose of the following Functions:

1. SQRT ( ) : ______________________________________________________________

2. DATE ( ) : ______________________________________________________________

3. SUM( ) : _______________________________________________________________

4. IF ( ) : _________________________________________________________________

5. AVERAGE( ) : __________________________________________________________

Q:No:04: Choose the correct answer:

1. What is the extension of the presentation saved in PowerPoint?
       a)  .DOC            b) .BAT            c) .PPT             d).XLS

2. _____________ key use for start slide show.
       a) F2            b) F3                c) F4            d) F5

3. _____________ Keys save the document.
       a) Ctrl + Enter          b) Shift + Enter       c) Shift + C       d) Ctrl +S

4. ______________ Key use for end the slide show.
       a) ESC              b) TAB             c) Shift + TAB            d) CTRL + ALT

5. PowerPoint is called _______________ software.
       a) Spread Sheet         b) Word Processing      c) Presentation       d) Graphic

6. Which of the following is a helpful way to provide reminders for you during a presentation?
       a) Transparencies          b) Templates              c) Speaker Notes              d) None of these

7. ___________ view enables you to view multiple slides on a single  screen.
       a) Normal View         b) Master           c) Slide sorter view           d) None of these

8. ____________ View is the main editing view, which you use to write and design your        presentation?
       a) Outline           b) Normal           c) Slide Show             d) Slide Sorter

9. What is template?
       a) A template is another word for Table
       b) A template is a collection of pre-designed slides
       c) A template is a paper plate
       d) None of these

10. How can you emphasize (highlight) text on the screen while running the slide show?
        a) Use a pointer and tap the screen repeatedly to get everyone's attention
        b) Use the pen
        c) Point at it with your finger
        d) Pronunciation louder on the words you want to emphasize