1. Where can we get Sort button?
2. The IF function allows you to:
3. What symbol is used to enter a formula in Excel?
4. ______________Button lets you change the zoom level?
5. What key combination is used to access the SUM function in Excel?
6. What does Ctrl+C do in Excel?
7. What is the purpose of cell formatting in Excel?
8. Write the formula of DA, which is 25% of Basic
9. How may rows are available in Excel?
10. To get Rename Sheet option we need ___________click on the sheet name.
11. Where can we get the data validation tool?
12. What happens if you enter a formula that results in an error (e.g., dividing by zero)?
13. What is the extension name of MS-Excel 2021?
14. To find the last row press ____________Key?
15. Where can we find the Comment button?
16. Which tool lets you search the data Name wise?
17. What is the correct way to reference a cell in another sheet within the same workbook?
18. The SUM function in Excel is used to:
19. What is the executable filename of MS-Excel 2021?
20. Where can we get the Filter button?
21. ______________tool can show the graphical representation of the data?
22. What does the function VLOOKUP do in Excel?
23. The formula =A1 + B1 will add the values in cells A1 and B1. In which cell should this formula be entered?
24. Which of the following is NOT a valid data type in a cell that can be used in formulas?
25. What is the purpose of conditional formatting in Excel?
