MS Word & Excel Quiz # 2

25 Questions | Attempts: 260
Share

SettingsSettingsSettings
MS Word & Excel Quiz # 2 - Quiz


Questions and Answers
  • 1. 
     Which of the following is the second step in creating a macro?
    • A. 

      Start recording

    • B. 

      Using your mouse or keyboard, perform the task you want to automate

    • C. 

       Assign a keyboard shortcut to the macro

    • D. 

      Give the macro a name

  • 2. 
    When assigning a shortcut key to a symbol, you should always try to select a key or key combination that is:
    • A. 

      Unassigned

    • B. 

      Located on the ten-key pad section of your keyboard

    • C. 

      Assigned to another task

    • D. 

      From the same font family as the symbol

  • 3. 
    Which feature is used to replace straight quotes with smart quotes as you type?
    • A. 

      Auto Correct as you type

    • B. 

      Auto Change as you type

    • C. 

      Auto Format as you type

    • D. 

      Smart Tags as you type

  • 4. 
     Which of the following command is not available in Tools menu?
    • A. 

      Auto text

    • B. 

      Autocorrect

    • C. 

      Auto summarize

    • D. 

      Macro

  • 5. 
    Word has a list of predefined typing, spelling, capitalization, and grammar errors that _____ can detect and correct.
    • A. 

      AutoEntry

    • B. 

      AutoCorrect

    • C. 

      AutoAdd

    • D. 

      AutoSpell

  • 6. 
    Which option is not available in Insert Table Autofit behavior?
    • A. 

      Fixed Column Width

    • B. 

      AutoFit to Contents

    • C. 

      Autofit to Window

    • D. 

      Autofit to Column

  • 7. 
    Tabs stop position cannot be the following alignment
    • A. 

      Decimal Alignment

    • B. 

      Center Alignment

    • C. 

      Bar Alignment

    • D. 

      Justify Alignment

  • 8. 
    Ctrl + B
    • A. 

      Search the selected text

    • B. 

      Paste the selected text

    • C. 

      Bold the selected text

    • D. 

      Open the specified file

  • 9. 
    To move the cursor page to page of document
    • A. 

      Ctrl+PgDn

    • B. 

      Ctrl+PgUp

    • C. 

      Both of above

    • D. 

      None of above

  • 10. 
    What is the shortcut key to "Insert Hyperlink" in a document?
    • A. 

      Ctrl + H

    • B. 

      Ctrl + K

    • C. 

      Ctrl + L

    • D. 

      None of above

  • 11. 
    What is extension of files created in MS-Excel 97-2003
    • A. 

      .xlx

    • B. 

      .msx

    • C. 

      .dot

    • D. 

      .xls

  • 12. 
    What is extension of files created in MS-Excel 2007-2015
    • A. 

      .txt

    • B. 

      .xls

    • C. 

      .xlsx

    • D. 

      .xsl

  • 13. 
    Which is the correct formula for SUM Function in MS Excel.
    • A. 

      /SUM(A1+A5)

    • B. 

      =SUM(A1-A5)

    • C. 

      =SUM(A1:A5)       

    • D. 

      +SUM(A1:A5)

  • 14. 
    Which menu option in MS Excel has the option to "Sort the Data"
    • A. 

      Review

    • B. 

      Data

    • C. 

      Formula

    • D. 

      Insert

  • 15. 
    Which button in MS Excel to calculate the sum of number
    • A. 

      AutoSum

    • B. 

      Fill

    • C. 

      Insert

    • D. 

      Merge

  • 16. 
    What is the Shortcut key for "Current Date" in Excel
    • A. 

      Ctrl + C

    • B. 

      Ctrl + D

    • C. 

      Alt + ;

    • D. 

      Ctrl + ;

  • 17. 
    What is the intersection of a column and a row on a worksheet called?
    • A. 

      Column

    • B. 

      Value

    • C. 

      Address

    • D. 

      Cell

  • 18. 
    Which type of chart is useful for comparing value over categories?
    • A. 

      Pie Chart

    • B. 

      Column Chart

    • C. 

      Line Chart

    • D. 

      Dot Chart

  • 19. 
    Which function in Excel tells how many numeric entries are there
    • A. 

      Num

    • B. 

      Count

    • C. 

      Sum

    • D. 

      ChkNum

  • 20. 
    A features that displays only the data in column (s) according to specified criteria
    • A. 

      Formula

    • B. 

      Sorting

    • C. 

      Filtering

    • D. 

      Pivot

  • 21. 
    Statistical calculations and preparation of tables and graphs can be done using
    • A. 

      Adobe Photoshop

    • B. 

      Excel

    • C. 

      Notepad

    • D. 

      Power Point

  • 22. 
    What type of chart will you use to compare performance of two employees in the year 2016 ?
    • A. 

      Column Chart

    • B. 

      Line Chart

    • C. 

      Pie Chart

    • D. 

      Dot Chart

  • 23. 
    Which one is not a Function in MS Excel ?
    • A. 

      SUM

    • B. 

      AVG

    • C. 

      MAX

    • D. 

      MIN

  • 24. 
    Functions in MS Excel must begin with ___
    • A. 

      An () sign

    • B. 

      An Equal Sign

    • C. 

      A Plus Sign

    • D. 

      A > Sign

  • 25. 
    Which function in Excel checks whether a condition is true or not ? 
    • A. 

      SUMAVER

    • B. 

      COUNT

    • C. 

      IF

    • D. 

      AVERAGE

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.