Welcome to your learningsector21 : Excel MCQ Part - 1
1. Which feature in Excel is used to protect a worksheet from being modified?
2. Which option in Excel allows you to align text to the left in a cell?
3. Which function in Excel is used to round a number to the nearest integer or specified decimal places?
4. Which Excel feature is used to calculate the average of a range of cells, excluding specified criteria?
5. Which Excel feature is used to combine the contents of two or more cells into one cell?
6. Which keyboard shortcut is used to insert the current time in a cell in Excel?
7. Which Excel feature is used to apply specific formatting based on a cell's value?
8. Which option in Excel allows you to change the background color of a cell?
9. Which keyboard shortcut is used to format cells as bold in Excel?
10. Which option in Excel allows you to adjust the width of columns to fit the contents?
11. Which Excel feature is used to freeze rows or columns so that they remain visible while scrolling?
12. Which Excel feature is used to calculate the difference between two dates?
13. Which keyboard shortcut is used to save an Excel workbook?
14. Which option in Excel allows you to insert a new row?
15. Which function in Excel is used to calculate the exponential power of a number?
16. Which keyboard shortcut is used to select the entire column in Excel?
17. Which function in Excel is used to calculate the product of a range of cells?
18. Which Excel feature is used to sort data in ascending or descending order?
19. Which Excel feature is used to highlight cells that meet specific criteria?
20. Which function in Excel is used to count the number of cells in a range that meet specific criteria?
21. Which keyboard shortcut is used to paste the contents of the clipboard in Excel?
22. Which feature in Excel allows you to combine two or more cells into a single cell?
23. Which keyboard shortcut is used to undo the last action in Excel?
24. Which function in Excel is used to find the average value of a range of cells?
26. Which keyboard shortcut is used to cut the selected cells in Excel?
27. Which function in Excel is used to calculate the sum of a range of cells that meet specific criteria?
28. Which of the following is used to enter, edit, and view data in a cell?
29. Which option in Excel allows you to insert a new column?
30. Which function in Excel is used to calculate the square root of a number?
31. Which function in Excel is used to add up a range of cells?
32. Which keyboard shortcut is used to select non-adjacent cells in Excel?
33. Which feature in Excel is used to display a preview of how the data will look when printed?
34. Which function in Excel is used to count the number of cells in a range that contain numbers?
35. Which function in Excel is used to calculate the average of a range of cells, excluding zero values?
36. Which option in Excel allows you to remove duplicate values from a range of cells?
37. Which Excel feature is used to remove leading and trailing spaces from text in a cell?
38. Which Excel function is used to find the smallest value in a range of cells?
39. Which function in Excel is used to calculate the factorial of a number?
40. Which option in Excel allows you to format cells as currency?
41. Which Excel feature is used to create a visual representation of data using bars or columns?
42. Which keyboard shortcut is used to select the entire worksheet in Excel?
43. Which keyboard shortcut is used to insert a new worksheet in Excel?
44. Which option in Excel allows you to insert the current date in a cell?
45. Which Excel feature is used to calculate the total of a range of cells in the bottom-right corner of the worksheet?
46. Which option in Excel allows you to insert a new worksheet?
47. Which option in Excel allows you to change the font color of a cell?
48. Which option in Excel allows you to convert text to lowercase?
49. Which Excel function is used to find the highest value in a range of cells?
50. Which option in Excel allows you to display the formulas instead of the calculated results?
