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