Microsoft Excel Quiz: Test On Functions!

10 Questions | Total Attempts: 56879

SettingsSettingsSettings
Please wait...
Microsoft Excel Quizzes & Trivia

Microsoft excel quiz: test on functions! Microsoft Excel is considered to be one of the most diverse Microsoft office tools as it not only allows calculations but can also allow processing of different sets of data. Are you confident in your ability to carry out different tasks with this tool? How about you take this quiz and see how true that is and which aspects of excel you may have forgotten!


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 the “Edit, Clear” command?
    • A. 

      Delete contents

    • B. 

      Delete notes

    • C. 

      Delete cells

    • D. 

      Delete formats

  • 9. 
    Microsoft Excel is 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