Ms Excel Test Set-4

Instruction:-

  • Number of Questions : 25
  • Total Marks : 25
  • Each question carry 1 Marks
  • No negative marking
  • Passing percentage 50%

  •  

    Results

    #1. MS Excel is mainly used for:

    #2. The default file extension of Excel 2007 and later is:

    #3. The intersection of a row and a column is called:

    #4. A workbook is a collection of:

    #5. The active cell is identified by:

    #6. Which symbol is used to start a formula in Excel?

    #7. Which function adds numbers?

    #8. Which function finds the average?

    #9. Which key repeats the last action?

    #10. What is the result of =LEN(” INDIA “)?

    #11. Which function combines text from multiple cells?

    #12. Which tab is used to create charts?

    #13. Which tab contains the Sort & Filter options?

    #14. Which feature arranges data alphabetically?

    #15. Which feature displays only selected records?

    #16. Which function performs logical tests?

    #17. Which function rounds a number?

    #18. Which function returns the length of text?

    #19. Which function joins text strings?

    #20. =COUNTA(A1:A10) counts:

    #21. Which tab is used to create a PivotTable?

    #22. Which feature prevents rows or columns from scrolling?

    #23. Which shortcut replaces data?

    #24. Which shortcut prints the workbook?

    #25. Which error appears when dividing by zero?

    Previous
    Finish

    Leave a Comment

    Your email address will not be published. Required fields are marked *