Question Option A Option B Option C Option D Answer 1. Which function is used to calculate the sum of a range of cells in Excel? A. AVERAGE B. COUNT C. SUM D. MAX C 2. What is the shortcut key to insert a new row in Excel? A. Ctrl + R B. Ctrl + Shift + R C. Ctrl + Alt + R D. Ctrl + Shift + + D 3. Which feature in Excel allows you to group and summarize data? A. Pivot tables B. Filter C. Sort D. Freeze Panes A 4. Which chart type is best for comparing values across categories? A. Pie chart B. Bar chart C. Line chart D. Scatter chart B 5. Which function is used to calculate the average of a range of cells in Excel? A. SUM B. COUNT C. AVERAGE D. MAX C 6. What is the keyboard shortcut to save an Excel workbook? A. Ctrl + S B. Ctrl + P C. Ctrl + O D. Ctrl + N A 7. Which function is used to find the highest value in a range of cells? A. MAX B. MIN C. COUNT D. AVERAGE A 8. Which Excel function is used to find the total number of cells in a range that contain numbers? A. COUNT B. SUM C. AVERAGE D. MAX A 9. Which chart type should be used to display data that changes over time? A. Pie chart B. Bar chart C. Line chart D. Scatter chart C 10. Which feature in Excel allows you to apply a formula to multiple cells at once? A. Copy and Paste B. Autofill C. Fill Series D. Format Painter B Question Option A Option B Option C Option D Answer 11. Which keyboard shortcut is used to open the Format Cells dialog box in Excel? A. Ctrl + 1 B. Ctrl + 2 C. Ctrl + 3 D. Ctrl + 4 A 12. Which Excel function is used to find the smallest value in a range of cells? A. MAX B. MIN C. COUNT D. AVERAGE B 13. What is the keyboard shortcut to undo the last action in Excel? A. Ctrl + Z B. Ctrl + X C. Ctrl + C D. Ctrl + V A 14. Which Excel function is used to round a number to a specified number of decimal places? A. ROUND B. CEILING C. FLOOR D. TRUNC A 15. Which chart type should be used to display proportions or percentages? A. Pie chart B. Bar chart C. Line chart D. Scatter chart A 16. Which Excel function is used to concatenate (join) two or more strings of text? A. CONCAT B. TEXTJOIN C. JOIN D. MERGE B 17. Which feature in Excel allows you to freeze the rows and columns of a worksheet? A. Filter B. Sort C. Freeze Panes D. Pivot tables C 18. What is the keyboard shortcut to insert a new column in Excel? A. Ctrl + C B. Ctrl + Shift + C C. Ctrl + Alt + C D. Ctrl + Shift + + D 19. Which Excel function is used to calculate the product of a range of cells? A. SUM B. COUNT C. PRODUCT D. MAX C 20. Which chart type should be used to show the relationship between two variables? A. Pie chart B. Bar chart C. Line chart D. Scatter chart D Question Option A Option B Option C Option D Answer 21. Which Excel function is used to find the largest integer less than or equal to a specified number? A. CEILING B. FLOOR C. ROUNDUP D. ROUNDDOWN B 22. Which keyboard shortcut is used to open the Insert Function dialog box in Excel? A. Ctrl + Shift + F B. Ctrl + Shift + G C. Ctrl + Shift + A D. Ctrl + Shift + L D 23. Which chart type should be used to show the distribution of data? A. Pie chart B. Bar chart C. Line chart D. Histogram D 24. Which Excel function is used to calculate the difference between two dates? A. DAYS B. MONTHS C. YEARS D. DATEDIF D 25. Which keyboard shortcut is used to apply the bold formatting to selected text in Excel? A. Ctrl + B B. Ctrl + U C. Ctrl + I D. Ctrl + Shift + B A 26. Which Excel function is used to calculate the exponential growth of a value over time? A. EXP B. GROWTH C. TREND D. FORECAST B 27. Which feature in Excel allows you to highlight cells that meet specific criteria? A. Filter B. Sort C. Conditional Formatting D. Pivot tables C 28. Which keyboard shortcut is used to delete a selected cell, row, or column in Excel? A. Ctrl + D B. Ctrl + X C. Ctrl + C D. Ctrl + – D 29. Which Excel function is used to convert a text string into a number? A. VALUE B. TEXT C. CONCATENATE D. TRIM A 30. Which chart type should be used to show the progress towards a goal? A. Pie chart B. Bar chart C. Line chart D. Gauge chart D Question Option A Option B Option C Option D Answer 31. Which Excel function is used to calculate the average of a range of cells? A. MAX B. MIN C. COUNT D. AVERAGE D 32. Which keyboard shortcut is used to open the Save As dialog box in Excel? A. Ctrl + S B. Ctrl + Shift + S C. Ctrl + Alt + S D. Ctrl + F B 33. Which chart type should be used to compare values side-by-side? A. Pie chart B. Bar chart C. Line chart D. Scatter chart B 34. Which Excel function is used to calculate the total number of cells that contain numbers in a range? A. COUNTA B. COUNTBLANK C. COUNTIF D. SUM D 35. Which keyboard shortcut is used to select the entire worksheet in Excel? A. Ctrl + A B. Ctrl + Shift + A C. Ctrl + Alt + A D. Ctrl + W A 36. Which Excel function is used to calculate the interest rate for a loan or investment? A. PV B. FV C. RATE D. PMT C 37. Which feature in Excel allows you to create custom calculations based on existing data? A. Pivot tables B. Filter C. Sort D. Chart Wizard A 38. Which keyboard shortcut is used to switch between the absolute, relative, and mixed reference types in Excel? A. F2 B. F4 C. F6 D. F8 B 39. Which Excel function is used to calculate the standard deviation of a range of cells? A. STDEV B. VARP C. AVERAGE D. SUM A 40. Which chart type should be used to show the proportion of different categories in a data set? A. Pie chart B. Bar chart C. Line chart D. Scatter chart A Question Option A Option B Option C Option D Answer 41. Which Excel function is used to concatenate two or more text strings? A. CONCAT B. TEXT C. JOIN D. MERGE A 42. Which keyboard shortcut is used to open the Go To dialog box in Excel? A. Ctrl + G B. Ctrl + F C. Ctrl + H D. Ctrl + E A 43. Which chart type should be used to show the trend of data over time? A. Pie chart B. Bar chart C. Line chart D. Scatter chart C 44. Which Excel function is used to round a number to a specified number of decimal places? A. CEILING B. FLOOR C. ROUND D. TRUNC C 45. Which keyboard shortcut is used to undo the last action in Excel? A. Ctrl + Z B. Ctrl + X C. Ctrl + C D. Ctrl + V A 46. Which Excel function is used to calculate the present value of a future payment? A. PV B. FV C. RATE D. PMT A 47. Which feature in Excel allows you to group data based on common values? A. Filter B. Sort C. Subtotal D. Pivot tables D 48. Which keyboard shortcut is used to create a new workbook in Excel? A. Ctrl + N B. Ctrl + O C. Ctrl + P D. Ctrl + Q A 49. Which Excel function is used to calculate the median of a range of cells? A. MIN B. MAX C. AVERAGE D. MEDIAN D 50. Which chart type should be used to show the relationship between two variables? A. Pie chart B. Bar chart C. Line chart D. Scatter chart D 51. Which Excel function is used to find the largest value in a range of cells? A. MAX B. MIN C. SUM D. COUNT A 52. Which keyboard shortcut is used to copy the contents of a cell to another cell in Excel? A. Ctrl + C B. Ctrl + V C. Ctrl + X D. Ctrl + R A 53. Which chart type should be used to show the distribution of data? A. Pie chart B. Bar chart C. Line chart D. Histogram D 54. Which Excel function is used to calculate the internal rate of return for a series of cash flows? A. PV B. FV C. IRR D. PMT C 55. Which keyboard shortcut is used to insert a new row in Excel? A. Ctrl + R B. Ctrl + Shift + R C. Ctrl + Alt + R D. Ctrl + I B 56. Which Excel function is used to find the smallest value in a range of cells? A. MAX B. MIN C. SUM D. COUNT B 57. Which feature in Excel allows you to highlight cells that meet a specific criteria? A. Filter B. Sort C. Conditional formatting D. Pivot tables C 58. Which keyboard shortcut is used to delete a cell or range of cells in Excel? A. Ctrl + D B. Ctrl + X C. Ctrl + Y D. Ctrl + Z B 59. Which Excel function is used to calculate the difference between two dates? A. DATEDIF B. DATE C. DAY D. MONTH A 60. Which chart type should be used to show the relationship between multiple variables? A. Pie chart B. Bar chart C. Line chart D. Scatter chart with multiple series D Question Option A Option B Option C Option D Answer 61. Which Excel function is used to calculate the sum of a range of cells? A. MAX B. MIN C. SUM D. COUNT C 62. Which keyboard shortcut is used to paste the contents of a copied cell to another cell in Excel? A. Ctrl + C B. Ctrl + V C. Ctrl + X D. Ctrl + P B 63. Which chart type should be used to show the parts of a whole? A. Pie chart B. Bar chart C. Line chart D. Scatter chart A 64. Which Excel function is used to calculate the future value of an investment? A. PV B. FV C. RATE D. PMT B 65. Which keyboard shortcut is used to insert a new column in Excel? A. Ctrl + C B. Ctrl + V C. Ctrl + Shift + C D. Ctrl + Shift + V C 66. Which Excel function is used to round a number up to the nearest integer? A. CEILING B. FLOOR C. ROUNDUP D. ROUNDDOWN A 67. Which feature in Excel allows you to group data based on time periods? A. Filter B. Sort C. Subtotal D. Pivot tables C 68. Which keyboard shortcut is used to save a workbook in Excel? A. Ctrl + S B. Ctrl + P C. Ctrl + Q D. Ctrl + W A 69. Which Excel function is used to count the number of cells in a range that meet a specific criteria? A. COUNT B. COUNTIF C. SUM D. AVERAGE B 70. Which chart type should be used to show the comparison between different categories of data? A. Pie chart B. Bar chart C. Line chart D. Scatter chart B Question Option A Option B Option C Option D Answer 71. Which Excel function is used to calculate the present value of an investment? A. PV B. FV C. RATE D. PMT A 72. Which keyboard shortcut is used to select the entire worksheet in Excel? A. Ctrl + A B. Ctrl + Shift + A C. Ctrl + Alt + A D. Ctrl + Home A 73. Which chart type should be used to show the trend of data over time? A. Pie chart B. Bar chart C. Line chart D. Scatter chart C 74. Which Excel function is used to calculate the payment for a loan? A. PV B. FV C. RATE D. PMT D 75. Which keyboard shortcut is used to hide a row or column in Excel? A. Ctrl + H B. Ctrl + R C. Ctrl + 9 D. Ctrl + 0 C 76. Which Excel function is used to calculate the absolute value of a number? A. ABS B. SIGN C. ROUNDUP D. ROUNDDOWN A 77. Which feature in Excel allows you to summarize data based on multiple criteria? A. Filter B. Sort C. Subtotal D. Pivot tables D 78. Which keyboard shortcut is used to close a workbook in Excel? A. Ctrl + S B. Ctrl + P C. Ctrl + Q D. Ctrl + W D 79. Which Excel function is used to calculate the average of a range of cells? A. MAX B. MIN C. SUM D. AVERAGE D 80. Which chart type should be used to show the relationship between two variables? A. Pie chart B. Bar chart C. Line chart D. Scatter chart D Question Option A Option B Option C Option D Answer 81. Which Excel function is used to find the highest value in a range of cells? A. MAX B. MIN C. SUM D. COUNT A 82. Which keyboard shortcut is used to insert a new row in Excel? A. Ctrl + C B. Ctrl + V C. Ctrl + Shift + C D. Ctrl + Shift + V D 83. Which chart type should be used to show the comparison between different data series over time? A. Pie chart B. Bar chart C. Line chart D. Scatter chart C 84. Which Excel function is used to calculate the interest rate of an investment? A. PV B. FV C. RATE D. PMT C 85. Which keyboard shortcut is used to unhide a hidden row or column in Excel? A. Ctrl + H B. Ctrl + R C. Ctrl + 9 D. Ctrl + 0 D 86. Which Excel function is used to calculate the square root of a number? A. SQRT B. POWER C. ROUNDUP D. ROUNDDOWN A 87. Which feature in Excel allows you to group data based on categories? A. Filter B. Sort C. Subtotal D. Pivot tables D 88. Which keyboard shortcut is used to open the “Find and Replace” dialog box in Excel? A. Ctrl + F B. Ctrl + R C. Ctrl + H D. Ctrl + G C 89. Which Excel function is used to calculate the median of a range of cells? A. MAX B. MIN C. SUM D. MEDIAN D 90. Which chart type should be used to show the comparison between different data series that are not related to time? A. Pie chart B. Bar chart C. Line chart D. Scatter chart B Question Option A Option B Option C Option D Answer 91. Which keyboard shortcut is used to open the “Go To” dialog box in Excel? A. Ctrl + G B. Ctrl + T C. Ctrl + Y D. Ctrl + U A 92. Which chart type should be used to show the distribution of data? A. Pie chart B. Bar chart C. Line chart D. Histogram D 93. Which Excel function is used to round a number to the nearest integer? A. ROUNDUP B. ROUNDDOWN C. ROUND D. CEILING C 94. Which keyboard shortcut is used to select the entire worksheet in Excel? A. Ctrl + A B. Ctrl + E C. Ctrl + S D. Ctrl + X A 95. Which chart type should be used to show the relationship between two variables? A. Pie chart B. Bar chart C. Line chart D. Scatter chart D 96. Which Excel function is used to find the average of a range of cells? A. MAX B. MIN C. SUM D. AVERAGE D 97. Which keyboard shortcut is used to copy a formula to adjacent cells in Excel? A. Ctrl + C B. Ctrl + V C. Ctrl + D D. Ctrl + R C 98. Which feature in Excel allows you to combine multiple cells into one cell? A. Merge Cells B. Split Cells C. Center Across Selection D. Wrap Text A 99. Which Excel function is used to calculate the standard deviation of a range of cells? A. STDEV B. VAR C. STDEVA D. VARA A 100. Which keyboard shortcut is used to save a workbook in Excel? A. Ctrl + S B. Ctrl + O C. Ctrl + N D. Ctrl + P A
Tag: MCQ
Share:
You May Also Like
Are you ready to test your knowledge and sharpen your skills in C# programming? Whether you’re a beginner looking to...
-
-
December 2, 2024
Python is a versatile and widely-used programming language known for its simplicity and readability. Whether you’re a beginner or an...
-
-
December 1, 2024
Are you ready to test your knowledge of Java? Whether you’re a beginner seeking to solidify your understanding of the...
-
-
November 29, 2024