Microsoft Excel Quiz Test: MCQ!

10 Questions | Total Attempts: 25603

SettingsSettingsSettings
Please wait...
Microsoft Excel Quiz Test: MCQ!

Are you familiar with Microsoft Excel, and do you think you can pass this quiz? Microsoft Excel helps you to be productive because of its multi-purpose spreadsheet. Teachers, employers, and scientists all make use of this convenient software feature. It may be intimidating at first, but you can learn how to navigate through Microsoft Excel. If you want to learn more about Microsoft Excel and find out how to use its spreadsheet, try this quiz.


Questions and Answers
  • 1. 
    Which Chart can be created in Excel?
    • A. 

      Area

    • B. 

      Line

    • C. 

      Pie

    • D. 

      All of the above

  • 2. 
    What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?
    • A. 

      5,430.00

    • B. 

      5,436.80

    • C. 

      5,436.8

    • D. 

      6.8

  • 3. 
    How do you display the current date and time in MS Excel?
    • A. 

      Date ()

    • B. 

      Today ()

    • C. 

      Now ()

    • D. 

      Time ()

  • 4. 
    How do you display the current date only in MS Excel?
    • A. 

      Date ()

    • B. 

      Today ()

    • C. 

      Now ()

    • D. 

      Time ()

  • 5. 
    How do you wrap the text in a cell?
    • A. 

      Format, cells, font

    • B. 

      Format, cells, protection

    • C. 

      Format, cells, number

    • D. 

      Format, cells, alignment

  • 6. 
    What does COUNTA () function do?
    • A. 

      Counts cells having alphabets

    • B. 

      Counts empty cells

    • C. 

      Counts cells having number

    • D. 

      Counts non-empty cells

  • 7. 
    What is the short cut key to highlight the entire column?
    • A. 

      Ctrl+C

    • B. 

      Ctrl+Enter

    • C. 

      Ctrl+Page Up

    • D. 

      Ctrl+Space Bar

  • 8. 
    In the formula, which symbol specifies the fixed columns or rows?
    • A. 

      $

    • B. 

      *

    • C. 

      %

    • D. 

      &

  • 9. 
    Excel displays the current cell address in the ……….
    • A. 

      Formula bar

    • B. 

      Status Bar

    • C. 

      Name Box

    • D. 

      Title Bar

  • 10. 
    What is the correct way to refer the cell A10 on sheet3 from sheet1?
    • A. 

      Sheet3!A10

    • B. 

      Sheet1!A10

    • C. 

      Sheet3.A10

    • D. 

      A10

Back to Top Back to top