Ms Excel Test Set-2

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!
    Share to other

    #1. Which of the following is NOT a valid data type in Excel?

    #2. Which feature in Excel is used to restrict the type of data entered into a cell?

    #3. What does the “Conditional Formatting” feature allow you to do in Excel?

    #4. How can you quickly sort a column in ascending order in Excel?

    #5. What is the main use of a PivotTable in Excel?

    #6. Which function is used to search for a value in the first column of a table and return a corresponding value from another column?

    #7. In Excel, how do you adjust the page orientation for printing?

    #8. Which function in Excel is used to combine text from multiple cells into one?

    #9. Which of the following keyboard shortcuts moves the active cell to the beginning of a worksheet?

    #10. In Excel, what is the maximum number of rows in a worksheet?

    #11. What is the effect of using an absolute reference (e.g., $A$1) in a formula when copying it across multiple cells?

    #12. Which of the following is the correct syntax for the SUM function in Excel?

    #13. Which function can be used to find the largest value in a range of cells?

    #14. Which bar lies top of the window in Excel Screen?

    #15. What is the difference between VLOOKUP and HLOOKUP?

    #16. What is the purpose of using the “Goal Seek” tool in Excel?

    #17. Which of the following formatting options would you use to display numbers as currency in Excel?

    #18. In which tab data validation option are available?

    #19. Which tab is used for wrap text and merge cell in spreadsheet?

    #20. Which formula in Excel is used to find the text length?

    #21. To print only the selected range of cells, which of the following options should be selected?

    #22. Which Excel function would you use to calculate the number of cells in a range that contain numbers?

    #23. What is the function of ‘Enter Key’ in MS Excel?

    #24. What does the formula =IF(AND(A1>10, B1<20), "Yes", "No") do?

    #25. Which formula in Excel is convert the lower case test into upper case text?

    Previous
    Finish

    Leave a Comment

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