Microsoft Excel - Set 3

10 Questions

Settings
Please wait...
Microsoft Excel - Set 3

Online MCQ Quiz on Microsoft Excel - Set 3 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. 
    Which Chart can be created in Excel?
    • A. 

      Area

    • B. 

      Line

    • C. 

      Pie

    • D. 

      All of the above

  • 2. 
    • A. 

      5,430.00

    • B. 

      5,436.80

    • C. 

      5,436.8

    • D. 

      6.8

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

      Date ()

    • B. 

      Today ()

    • C. 

      Now ()

    • D. 

      Time ()

  • 4. 
    How do you display 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. 
    • A. 

      Sheet3!A10

    • B. 

      Sheet1!A10

    • C. 

      Sheet3.A10

    • D. 

      A10