Can You Pass This Microsoft Excel Exam Quiz?

15 Questions | Total Attempts: 180

SettingsSettingsSettings
Please wait...
Microsoft Excel Quizzes & Trivia

.


Questions and Answers
  • 1. 
    AN EXAMPLE OF  CELL ADDRESS .. 
    • A. 

      23G

    • B. 

      11

    • C. 

      A11

    • D. 

      A

  • 2. 
    WHAT IS SHORTCUT FOR COPY ?
    • A. 

      CTRL+C

    • B. 

      CTRL

    • C. 

      COPY

    • D. 

      PASTE

  • 3. 
    HOW TO START ANY FORMULA IN A CELL ?
    • A. 

      /

    • B. 

      *

    • C. 

      +

    • D. 

      =

  • 4. 
    WHICH SYNTAX IS CORRECT ?
    • A. 

      =(A1-B1)

    • B. 

      (A1-B1)

    • C. 

      A1

  • 5. 
    On an excel sheet the active cell in indicated by ?
    • A. 

      A dark wide border

    • B. 

      WITH A DOT

    • C. 

      COLOR OF THE CELL IS CHANGED

    • D. 

      By italic text

  • 6. 
    If you press ___, the cell accepts your typing as its contents ?
    • A. 

      SHIFT+ENTER

    • B. 

      ENTER

    • C. 

      CTRL

    • D. 

      CTRL+ENTER

  • 7. 
    A EXCEL SHEET CONTAINS ?
    • A. 

      ROW

    • B. 

      COLUMN

    • C. 

      ROW AND COLUMN

    • D. 

      LINES

  • 8. 
    CAN WE ADD PICTURE IN A EXCEL SHEET ?
    • A. 

      YES

    • B. 

      NO

  • 9. 
    Which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?
    • A. 

      IF

    • B. 

      OR

    • C. 

      AND

    • D. 

      NOT

  • 10. 
    PRODUCT FUNCTION IS USED FOR ?
    • A. 

      MULTIPLICATION

    • B. 

      DIVISION

    • C. 

      ADDITION

    • D. 

      NOTHING

  • 11. 
    What is Microsoft Excel?
    • A. 

      Microsoft excel is an electronic worksheet developed by Microsoft, to be used for organizing, storing and manipulating.

    • B. 

      IT IS USED FOR VARIOUS CALCULATION

    • C. 

      ANY OF THE ABOVE

  • 12. 
    EVERY CELL MUST HAVE A ADDRESS ..
    • A. 

      TRUE

    • B. 

      FALSE

  • 13. 
    TABLE OPTION CAN BE FOUND ON ...
    • A. 

      HOME

    • B. 

      INSERT

    • C. 

      FORMULAS

    • D. 

      VIEW

  • 14. 
    CTRL + X COMMAND IS USED FOR ?
    • A. 

      CUT

    • B. 

      COPY

    • C. 

      PASTE

  • 15. 
    CTRL + Z IS USED FOR ?
    • A. 

      REDO

    • B. 

      COPY

    • C. 

      UNDO

    • D. 

      PASTE