The Ultimate MS Office Online MCQ Test!

43 Questions | Total Attempts: 27378

SettingsSettingsSettings
Please wait...
The Ultimate MS Office Online MCQ Test!

Welcome to The Ultimate MS Office Online MCQ 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 applying 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. 
    Which of the following is a popular DOS based spreadsheet package?
    • 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. 
    Concatenation of text can be done using:
    • 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.