Microsoft Excel Trivia Knowledge Exam: Quiz!

10 Questions | Total Attempts: 54

SettingsSettingsSettings
Please wait...
Microsoft Excel Quizzes & Trivia

.


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. 
    MS-EXCEL is based on ……….
    • 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