The Ultimate MS Office Online Test!

43 Questions

Settings
Please wait...
The Ultimate MS Office Online Test!

Some knowledge of Microsoft office packages is required from any new employees that an organization is looking to hire. The quiz below is specially designed for a student who needs a refresher on all things related to Ms. Office. Is that you? Give it a try and get to see what you need to practice more on before you apply for the job you have been eyeing.


Questions and Answers
  • 1. 
    • A. 

      Word Processor

    • B. 

      Data base

    • C. 

      Image Editor

    • D. 

      File Manager

  • 2. 
    • A. 

      E-Mail Client

    • B. 

      Scheduler

    • C. 

      Address Book

    • D. 

      All of the above

  • 3. 
    MS Office provides help in many ways. Which of these are more closer to the answer?
    • A. 

      What’s This

    • B. 

      Office Assistant

    • C. 

      Help Menu

    • D. 

      All of the above

  • 4. 
    Which menu in MS Word can be used to change page size & typeface?
    • A. 

      View

    • B. 

      Tools

    • C. 

      Format

    • D. 

      Data

  • 5. 
    • A. 

      Down Cursor Key

    • B. 

      Enter Key

    • C. 

      Shift + Enter

    • D. 

      Control + Enter

  • 6. 
    Which of these toolbars allows changing of Fonts and their sizes?
    • A. 

      Standard

    • B. 

      Formatting

    • C. 

      Print Preview

    • D. 

      None of these

  • 7. 
    • A. 

      Menu bar

    • B. 

      Status Bar

    • C. 

      Tool bar

    • D. 

      Scroll bar

  • 8. 
    Which of the following are valid Min. & Max. zoom sizes in MS Office?
    • A. 

      10, 100

    • B. 

      20, 250

    • C. 

      10, 500

    • D. 

      10, 1000

  • 9. 
    Which type of files cannot be navigated using Clip Art browser?
    • A. 

      AVI

    • B. 

      BMP

    • C. 

      WAV

    • D. 

      MP3

  • 10. 
    Which option in File pull-down menu is used to close a file in MS Word?
    • A. 

      New

    • B. 

      Quit

    • C. 

      Close

    • D. 

      Exit

  • 11. 
    • A. 

      Word

    • B. 

      Smart Cell

    • C. 

      Excel

    • D. 

      Lotus 1-2-3

  • 12. 
    • A. 

      256

    • B. 

      1024

    • C. 

      32000

    • D. 

      65535

  • 13. 
    A Worksheet can have a maximum number of rows?
    • A. 

      256

    • B. 

      1024

    • C. 

      32000

    • D. 

      65536

  • 14. 
    A typical worksheet has number of columns?
    • A. 

      128

    • B. 

      256

    • C. 

      512

    • D. 

      1024

  • 15. 
    Comments put in cells are called?
    • A. 

      Smart Tip

    • B. 

      Cell Tip

    • C. 

      Web Tip

    • D. 

      Soft Tip

  • 16. 
    • A. 

      Format -> Window

    • B. 

      View -> Window -> Split

    • C. 

      Window -> Split

    • D. 

      View -> Split

  • 17. 
    Getting data from a cell located in a different sheet is called?
    • A. 

      Accessing

    • B. 

      Referencing

    • C. 

      Updating

    • D. 

      Functioning

  • 18. 
    • A. 

      Number

    • B. 

      Character

    • C. 

      Label

    • D. 

      Date/Time

  • 19. 
    Which elements of a worksheet can be protected from accidental modification?
    • A. 

      Contents

    • B. 

      Objects

    • C. 

      Scenarios

    • D. 

      All of the above

  • 20. 
    • A. 

      Apostrophe (‘)

    • B. 

      Exclamation (!)

    • C. 

      Hash (#)

    • D. 

      Ampersand (&)

  • 21. 
    Which area in an Excel window allows entering values and formulas?
    • A. 

      Title Bar

    • B. 

      Menu Bar

    • C. 

      Formula Bar

    • D. 

      Standard Tool Bar

  • 22. 
    Multiple calculations can be made in a single formula using?
    • A. 

      Standard Formulas

    • B. 

      Array Formula

    • C. 

      Complex Formulas

    • D. 

      Smart Formula

  • 23. 
    An Excel Workbook is a collection of?
    • A. 

      Workbooks

    • B. 

      Worksheets

    • C. 

      Charts

    • D. 

      Worksheets and Charts

  • 24. 
    Graphics for word processor?
    • A. 

      Peripheral

    • B. 

      Clip art

    • C. 

      Highlight

    • D. 

      Execute

  • 25. 
    • A. 

      It converts selected text into the next larger size of the same font

    • B. 

      It adds a line break to the document

    • C. 

      It makes the selected text bold

    • D. 

      It applies Italic formatting t the selected text.

  • 26. 
    • A. 

      To enhance the overall appearance of the document

    • B. 

      To mark the starting and ending of a page

    • C. 

      To make large document more readable

    • D. 

      To allow page headers and footers to appear on document when it is printed

  • 27. 
    • A. 

      It converts selected text into the next larger size of the same font

    • B. 

      It adds a line break to the document

    • C. 

      It makes the selected text bold

    • D. 

      It applies Italic formatting the selected text

  • 28. 
    • A. 

      Zero

    • B. 

      2 rows and 1 column

    • C. 

      2 rows and 2 column

    • D. 

      1 row and 1 column

  • 29. 
  • 30. 
    What sym­bol is used to enter num­ber as text?
    • A. 

    • B. 

      "

    • C. 

      =

    • D. 

      +

  • 31. 
    • A. 

      Sort command from Table menu

    • B. 

      Sort command from Data menu

    • C. 

      Sort command from Tools menu

    • D. 

      None of these

  • 32. 
    To select mul­ti­ple non-adjacent cells in a work­sheet you will click them holding?
    • A. 

      CTRL key

    • B. 

      ALT key

    • C. 

      Shift Key

    • D. 

      Ctrl+Shift key

  • 33. 
    How many sheets are there in Excel Work­book by default?
    • A. 

      2

    • B. 

      3

    • C. 

      4

    • D. 

      5

  • 34. 
    Which of the fol­low­ing com­po­nent dis­plays the con­tents of active cell?
    • A. 

      Name box

    • B. 

      Formula bar

    • C. 

      Menu bar

    • D. 

      Status bar

  • 35. 
    To move to the pre­vi­ous work­sheet press:
    • A. 

      Ctrl+PgUp

    • B. 

      Ctrl+PgDn

    • C. 

      Shift+Tab

    • D. 

      Ctrl+Tab

  • 36. 
    Red tri­an­gle at the top right cor­ner of a cell indicates:
    • A. 

      There is an error in the cell.

    • B. 

      Choose Tools and then Options.

    • C. 

      Choose File and then Properties.

    • D. 

      Choose Edit and then Files.

  • 37. 
    Two common wildcard characters that Excel recognizes are?
    • A. 

      * and ?

    • B. 

      < and >

    • C. 

      ^ and /

    • D. 

      + and -

  • 38. 
    How to align center using a shortcut?
    • A. 

      CTRL+j

    • B. 

      CTRL+e

    • C. 

      CTRL+r

    • D. 

      CTRL+l

  • 39. 
    Short cut to insert the current date in a word:
    • A. 

      Shift+d

    • B. 

      Ctrl+shift+d

    • C. 

      Alt+shift+d

    • D. 

      Ctrl+d

  • 40. 
    • A. 

      1638

    • B. 

      72

    • C. 

      512

    • D. 

      1024

  • 41. 
    • A. 

      Select list and press bullets icon in toolbar

    • B. 

      Press bullets icon in toolbar

    • C. 

      Select list and select format --> bullets and numbering

    • D. 

      Both A and C

  • 42. 
    Which of the following shortcut key is used to check spelling?
    • A. 

      F1

    • B. 

      F2

    • C. 

      F7

    • D. 

      F9

  • 43. 
    • A. 

      There is an error in the cell

    • B. 

      There is a com¬ment asso¬ci¬ated with the cell

    • C. 

      The font color of the text in cell is red

    • D. 

      The cell can’t accept formula