Welcome to your learningsector21 : Excel MCQ Part - 2
1. Which Excel feature is used to apply a specific format to a cell based on its value or condition?
2. Which Excel feature is used to calculate the net present value of an investment?
3. Which Excel function is used to calculate the largest value in a range of cells?
4. Which Excel feature is used to calculate the internal rate of return for an investment?
5. Which Excel feature is used to calculate the difference between two dates?
6. Which Excel feature is used to freeze rows or columns so that they remain visible while scrolling?
7. Which function in Excel is used to calculate the factorial of a number plus 1?
8. Which Excel feature is used to calculate the present value of an investment?
9. Which Excel feature is used to calculate the sum of a range of cells, excluding hidden rows or columns?
10. Which function in Excel is used to round a number to the nearest integer or specified decimal places?
11. Which keyboard shortcut is used to copy the selected cells in Excel?
12. Which keyboard shortcut is used to undo the last action in Excel?
13. Which option in Excel allows you to resize the width of multiple columns to fit the contents?
14. Which option in Excel allows you to insert the file path and name into a cell?
15. Which keyboard shortcut is used to insert the current date in a cell in Excel?
16. Which function in Excel is used to calculate the tangent of an angle?
17. Which keyboard shortcut is used to select all cells in a worksheet in Excel?
18. Which function in Excel is used to calculate the square root of a number?
19. Which option in Excel allows you to apply a border around a selected range of cells?
20. Which function in Excel is used to count the number of cells in a range that meet a specified condition?
21. Which Excel feature is used to calculate the average of a range of cells, including numbers, text, and logical values?
22. Which function in Excel is used to calculate the sum of a range of cells, including only numbers and ignoring text or blank cells?
23. Which option in Excel allows you to insert a line break within a cell?
24. Which option in Excel allows you to convert text to lowercase?
25. Which Excel feature is used to create a chart or graph based on selected data?
26. Which option in Excel allows you to apply a specific number format to a cell?
27. Which function in Excel is used to calculate the average of a range of cells, excluding blank cells?
28. Which option in Excel allows you to apply a specific font color to a cell?
29. Which option in Excel allows you to insert the current time in a header or footer?
30. Which keyboard shortcut is used to select the entire worksheet in Excel?
31. Which function in Excel is used to calculate the product of a range of cells?
32. Which function in Excel is used to concatenate multiple text strings into one?
33. Which function in Excel is used to calculate the sum of a range of cells, excluding specified criteria?
34. Which Excel feature is used to sort data in ascending or descending order?
35. Which function in Excel is used to calculate the median of a range of cells?
36. Which keyboard shortcut is used to select the entire column in Excel?
37. Which option in Excel allows you to split text into separate columns based on a delimiter?
38. Which option in Excel allows you to change the font style of a cell?
39. Which option in Excel allows you to merge multiple cells into one?
40. Which keyboard shortcut is used to select the entire worksheet in Excel?
41. Which option in Excel allows you to insert a hyperlink to a webpage or file?
42. Which Excel feature is used to calculate the total number of cells in a range that contain numbers?
43. Which keyboard shortcut is used to open the Excel Help window?
44. Which keyboard shortcut is used to open the Format Cells dialog box in Excel?
45. Which keyboard shortcut is used to select non-adjacent cells or ranges in Excel?
46. Which Excel feature is used to group and summarize data based on specified criteria?
47. Which option in Excel allows you to create a drop-down list in a cell?
48. Which keyboard shortcut is used to delete a selected column in Excel?
49. Which keyboard shortcut is used to save the current workbook in Excel?
50. Which function in Excel is used to calculate the cosine of an angle?
