Ms Excel Test Set-3

Leave a Comment / Ms Office Tests / By

Instruction:-

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

    •  

    Results

    Share your score!
    Tweet your score!
    Tweet your score!
    Share to other

    #1. Which of the following is not a valid formula in Ms-Excel?

    #2. Where we can see the formula applied in the cell in the Ms-Excel?

    #3. Which of the following is a valid formula for average calculating in Ms-Excel?

    #4. What will be the output of the formula if we apply =ceiling(48,5) in Ms-Excel?

    #5. Which function returns the highest value?

    #6. Which function returns the row number of a reference?

    #7. Which function returns the second largest number in A1:A10?

    #8. Which function counts non-empty cells?

    #9. Which shortcut saves the workbook?

    #10. Which shortcut creates a new workbook?

    #11. Pre-programmed formula in Ms-Excel is also known as

    #12. Which option is used to join more than one cell into a single cell in Ms-Excel?

    #13. Which of the following chart is used to represent the different variable of a single quantity in Ms-Excel?

    #14. Workbook is collection of ____ in Ms-Excel?

    #15. Which shortcut is to open save as dialog box in Ms-Excel?

    #16. Which shortcut edits the active cell?

    #17. Which shortcut inserts the current date?

    Previous
    Finish

    Leave a Comment

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