Microsoft Excel - Set 2

10 Questions

Settings
Please wait...
Microsoft Excel - Set 2

Online MCQ Quiz on Microsoft Excel - Set 2 No. Of Questions:- 10 Time:- 10 Minutes Full Mark:- 100 Pass Mark:- 70 This Quiz if for those user who wants to test their knowledge in Microsoft Excel. For more MCQ Questions and Online Quizzes please visit https://www. McqQuestions. Com


Questions and Answers
  • 1. 
    An Excel Workbook is a collection of …….
    • A. 

      Workbooks

    • B. 

      Worksheets

    • C. 

      Charts

    • D. 

      Worksheets and Charts

  • 2. 
    What do you mean by a Workspace?
    • A. 

      Group of Columns

    • B. 

      Group of Worksheets

    • C. 

      Group of Rows

    • D. 

      Group of Workbooks

  • 3. 
    • A. 

      WINDOWS

    • B. 

      DOS

    • C. 

      UNIX

    • D. 

      OS/2

  • 4. 
    In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
    • A. 

      AutoFill

    • B. 

      Auto correct

    • C. 

      Auto sum

    • D. 

      Auto format

  • 5. 
    To select an entire column in MS-EXCEL, press?
    • A. 

      CTRL + C

    • B. 

      CTRL + Arrow key

    • C. 

      CTRL + S

    • D. 

      None of the above

  • 6. 
    To return the remainder after a number is divided by a divisor in EXCEL we use the function?
    • A. 

      ROUND ( )

    • B. 

      FACT ( )

    • C. 

      MOD ( )

    • D. 

      DIV ( )

  • 7. 
    Which function is not available in the Consolidate dialog box?
    • A. 

      Pmt

    • B. 

      Average

    • C. 

      Max

    • D. 

      Sum

  • 8. 
    Which is not the function of “Edit, Clear” command?
    • A. 

      Delete contents

    • B. 

      Delete notes

    • C. 

      Delete cells

    • D. 

      Delete formats

  • 9. 
    Microsoft Excel is a powerful………..
    • A. 

      Word processing package

    • B. 

      Spreadsheet package

    • C. 

      Communication S/W Package

    • D. 

      DBMS package

  • 10. 
    How do you rearrange the data in ascending or descending order?
    • A. 

      Data, Sort

    • B. 

      Data, Form

    • C. 

      Data, Table

    • D. 

      Data Subtotals