MS Office MCQ Online Test Quiz With Answers

43 Questions | Total Attempts: 45050

SettingsSettingsSettings
MS Office MCQ Online Test Quiz With Answers - Quiz

Welcome to the MS Office MCQ Online Test Quiz With Answers! 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. 
    Which of the following is not a part of a standard office suite?
    • A. 

      Word Processor

    • B. 

      Data base

    • C. 

      Image Editor

    • D. 

      File Manager

  • 2. 
    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

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

      View

    • B. 

      Tools

    • C. 

      Format

    • D. 

      Data

  • 4. 
    Which key should be pressed to start a new paragraph in MS Word?
    • A. 

      Down Cursor Key

    • B. 

      Enter Key

    • C. 

      Shift + Enter

    • D. 

      Control + Enter

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

      Standard

    • B. 

      Formatting

    • C. 

      Print Preview

    • D. 

      None of these

  • 6. 
    Which bar is usually located below that Title Bar that provides categorized options?
    • A. 

      Menu bar

    • B. 

      Status Bar

    • C. 

      Tool bar

    • D. 

      Scroll bar

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

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

      AVI

    • B. 

      BMP

    • C. 

      WAV

    • D. 

      MP3

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

      New

    • B. 

      Quit

    • C. 

      Close

    • D. 

      Exit

  • 10. 
    Which of the following is a popular DOS based spreadsheet package?
    • A. 

      Word

    • B. 

      Smart Cell

    • C. 

      Excel

    • D. 

      Lotus 1-2-3

  • 11. 
    How many characters can be typed in a single cell in Excel?
    • A. 

      256

    • B. 

      1024

    • C. 

      32000

    • D. 

      65535

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

      256

    • B. 

      1024

    • C. 

      32000

    • D. 

      65536

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

      Smart Tip

    • B. 

      Cell Tip

    • C. 

      Web Tip

    • D. 

      Soft Tip

  • 14. 
    Which menu option can be used to split windows into two?
    • A. 

      Format -> Window

    • B. 

      View -> Window -> Split

    • C. 

      Window -> Split

    • D. 

      View -> Split

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

      Accessing

    • B. 

      Referencing

    • C. 

      Updating

    • D. 

      Functioning

  • 16. 
    Which of the following is not a valid data type in Excel?
    • A. 

      Number

    • B. 

      Character

    • C. 

      Label

    • D. 

      Date/Time

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

      Contents

    • B. 

      Objects

    • C. 

      Scenarios

    • D. 

      All of the above

  • 18. 
    Concatenation of text can be done using:
    • A. 

      Apostrophe (‘)

    • B. 

      Exclamation (!)

    • C. 

      Hash (#)

    • D. 

      Ampersand (&)

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

      Title Bar

    • B. 

      Menu Bar

    • C. 

      Formula Bar

    • D. 

      Standard Tool Bar

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

      Standard Formulas

    • B. 

      Array Formula

    • C. 

      Complex Formulas

    • D. 

      Smart Formula

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

      Workbooks

    • B. 

      Worksheets

    • C. 

      Charts

    • D. 

      Worksheets and Charts

  • 22. 
    Graphics for word processor?
    • A. 

      Peripheral

    • B. 

      Clip art

    • C. 

      Highlight

    • D. 

      Execute

  • 23. 
    What does the Ctrl + I shortcut key accomplish in Ms-Word?
    • 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.

  • 24. 
    Why are headers and footers used in document?
    • 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

  • 25. 
    What does Ctrl + B shortcut accomplish in Ms Word?
    • 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

Back to Top Back to top