| 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 |
