Excel - Clasa A X-a

10 Óntrebri | Total Attempts: 104

Settings
Please wait...
Excel - Clasa A X-a

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. 
    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 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. 
    In the formula, which symbol specifies the fixed columns or rows?
    • A. 

      $

    • B. 

      *

    • C. 

      %

    • D. 

      &

  • 8. 
    Excel displays the current cell address in the ←←←.
    • A. 

      Formula bar

    • B. 

      Status Bar

    • C. 

      Name Box

    • D. 

      Title Bar

  • 9. 
    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

  • 10. 
    To record " sequence of keystrokes "nd ¡ouse "ctions to ¢l"y b"ck l"ter we use:
    • A. 

      Media Player

    • B. 

      Sound Recorder

    • C. 

      Calculator

    • D. 

      Macro Recorder