HomeInterview Q&AExcel Multiple Choice Questions & Answers

Excel Multiple Choice Questions & Answers

QuestionOption AOption BOption COption DAnswer
1. Which function is used to calculate the sum of a range of cells in Excel?A. AVERAGEB. COUNTC. SUMD. MAXC
2. What is the shortcut key to insert a new row in Excel?A. Ctrl + RB. Ctrl + Shift + RC. Ctrl + Alt + RD. Ctrl + Shift + +D
3. Which feature in Excel allows you to group and summarize data?A. Pivot tablesB. FilterC. SortD. Freeze PanesA
4. Which chart type is best for comparing values across categories?A. Pie chartB. Bar chartC. Line chartD. Scatter chartB
5. Which function is used to calculate the average of a range of cells in Excel?A. SUMB. COUNTC. AVERAGED. MAXC
6. What is the keyboard shortcut to save an Excel workbook?A. Ctrl + SB. Ctrl + PC. Ctrl + OD. Ctrl + NA
7. Which function is used to find the highest value in a range of cells?A. MAXB. MINC. COUNTD. AVERAGEA
8. Which Excel function is used to find the total number of cells in a range that contain numbers?A. COUNTB. SUMC. AVERAGED. MAXA
9. Which chart type should be used to display data that changes over time?A. Pie chartB. Bar chartC. Line chartD. Scatter chartC
10. Which feature in Excel allows you to apply a formula to multiple cells at once?A. Copy and PasteB. AutofillC. Fill SeriesD. Format PainterB
QuestionOption AOption BOption COption DAnswer
11. Which keyboard shortcut is used to open the Format Cells dialog box in Excel?A. Ctrl + 1B. Ctrl + 2C. Ctrl + 3D. Ctrl + 4A
12. Which Excel function is used to find the smallest value in a range of cells?A. MAXB. MINC. COUNTD. AVERAGEB
13. What is the keyboard shortcut to undo the last action in Excel?A. Ctrl + ZB. Ctrl + XC. Ctrl + CD. Ctrl + VA
14. Which Excel function is used to round a number to a specified number of decimal places?A. ROUNDB. CEILINGC. FLOORD. TRUNCA
15. Which chart type should be used to display proportions or percentages?A. Pie chartB. Bar chartC. Line chartD. Scatter chartA
16. Which Excel function is used to concatenate (join) two or more strings of text?A. CONCATB. TEXTJOINC. JOIND. MERGEB
17. Which feature in Excel allows you to freeze the rows and columns of a worksheet?A. FilterB. SortC. Freeze PanesD. Pivot tablesC
18. What is the keyboard shortcut to insert a new column in Excel?A. Ctrl + CB. Ctrl + Shift + CC. Ctrl + Alt + CD. Ctrl + Shift + +D
19. Which Excel function is used to calculate the product of a range of cells?A. SUMB. COUNTC. PRODUCTD. MAXC
20. Which chart type should be used to show the relationship between two variables?A. Pie chartB. Bar chartC. Line chartD. Scatter chartD
QuestionOption AOption BOption COption DAnswer
21. Which Excel function is used to find the largest integer less than or equal to a specified number?A. CEILINGB. FLOORC. ROUNDUPD. ROUNDDOWNB
22. Which keyboard shortcut is used to open the Insert Function dialog box in Excel?A. Ctrl + Shift + FB. Ctrl + Shift + GC. Ctrl + Shift + AD. Ctrl + Shift + LD
23. Which chart type should be used to show the distribution of data?A. Pie chartB. Bar chartC. Line chartD. HistogramD
24. Which Excel function is used to calculate the difference between two dates?A. DAYSB. MONTHSC. YEARSD. DATEDIFD
25. Which keyboard shortcut is used to apply the bold formatting to selected text in Excel?A. Ctrl + BB. Ctrl + UC. Ctrl + ID. Ctrl + Shift + BA
26. Which Excel function is used to calculate the exponential growth of a value over time?A. EXPB. GROWTHC. TRENDD. FORECASTB
27. Which feature in Excel allows you to highlight cells that meet specific criteria?A. FilterB. SortC. Conditional FormattingD. Pivot tablesC
28. Which keyboard shortcut is used to delete a selected cell, row, or column in Excel?A. Ctrl + DB. Ctrl + XC. Ctrl + CD. Ctrl + –D
29. Which Excel function is used to convert a text string into a number?A. VALUEB. TEXTC. CONCATENATED. TRIMA
30. Which chart type should be used to show the progress towards a goal?A. Pie chartB. Bar chartC. Line chartD. Gauge chartD
QuestionOption AOption BOption COption DAnswer
31. Which Excel function is used to calculate the average of a range of cells?A. MAXB. MINC. COUNTD. AVERAGED
32. Which keyboard shortcut is used to open the Save As dialog box in Excel?A. Ctrl + SB. Ctrl + Shift + SC. Ctrl + Alt + SD. Ctrl + FB
33. Which chart type should be used to compare values side-by-side?A. Pie chartB. Bar chartC. Line chartD. Scatter chartB
34. Which Excel function is used to calculate the total number of cells that contain numbers in a range?A. COUNTAB. COUNTBLANKC. COUNTIFD. SUMD
35. Which keyboard shortcut is used to select the entire worksheet in Excel?A. Ctrl + AB. Ctrl + Shift + AC. Ctrl + Alt + AD. Ctrl + WA
36. Which Excel function is used to calculate the interest rate for a loan or investment?A. PVB. FVC. RATED. PMTC
37. Which feature in Excel allows you to create custom calculations based on existing data?A. Pivot tablesB. FilterC. SortD. Chart WizardA
38. Which keyboard shortcut is used to switch between the absolute, relative, and mixed reference types in Excel?A. F2B. F4C. F6D. F8B
39. Which Excel function is used to calculate the standard deviation of a range of cells?A. STDEVB. VARPC. AVERAGED. SUMA
40. Which chart type should be used to show the proportion of different categories in a data set?A. Pie chartB. Bar chartC. Line chartD. Scatter chartA
QuestionOption AOption BOption COption DAnswer
41. Which Excel function is used to concatenate two or more text strings?A. CONCATB. TEXTC. JOIND. MERGEA
42. Which keyboard shortcut is used to open the Go To dialog box in Excel?A. Ctrl + GB. Ctrl + FC. Ctrl + HD. Ctrl + EA
43. Which chart type should be used to show the trend of data over time?A. Pie chartB. Bar chartC. Line chartD. Scatter chartC
44. Which Excel function is used to round a number to a specified number of decimal places?A. CEILINGB. FLOORC. ROUNDD. TRUNCC
45. Which keyboard shortcut is used to undo the last action in Excel?A. Ctrl + ZB. Ctrl + XC. Ctrl + CD. Ctrl + VA
46. Which Excel function is used to calculate the present value of a future payment?A. PVB. FVC. RATED. PMTA
47. Which feature in Excel allows you to group data based on common values?A. FilterB. SortC. SubtotalD. Pivot tablesD
48. Which keyboard shortcut is used to create a new workbook in Excel?A. Ctrl + NB. Ctrl + OC. Ctrl + PD. Ctrl + QA
49. Which Excel function is used to calculate the median of a range of cells?A. MINB. MAXC. AVERAGED. MEDIAND
50. Which chart type should be used to show the relationship between two variables?A. Pie chartB. Bar chartC. Line chartD. Scatter chartD
51. Which Excel function is used to find the largest value in a range of cells?A. MAXB. MINC. SUMD. COUNTA
52. Which keyboard shortcut is used to copy the contents of a cell to another cell in Excel?A. Ctrl + CB. Ctrl + VC. Ctrl + XD. Ctrl + RA
53. Which chart type should be used to show the distribution of data?A. Pie chartB. Bar chartC. Line chartD. HistogramD
54. Which Excel function is used to calculate the internal rate of return for a series of cash flows?A. PVB. FVC. IRRD. PMTC
55. Which keyboard shortcut is used to insert a new row in Excel?A. Ctrl + RB. Ctrl + Shift + RC. Ctrl + Alt + RD. Ctrl + IB
56. Which Excel function is used to find the smallest value in a range of cells?A. MAXB. MINC. SUMD. COUNTB
57. Which feature in Excel allows you to highlight cells that meet a specific criteria?A. FilterB. SortC. Conditional formattingD. Pivot tablesC
58. Which keyboard shortcut is used to delete a cell or range of cells in Excel?A. Ctrl + DB. Ctrl + XC. Ctrl + YD. Ctrl + ZB
59. Which Excel function is used to calculate the difference between two dates?A. DATEDIFB. DATEC. DAYD. MONTHA
60. Which chart type should be used to show the relationship between multiple variables?A. Pie chartB. Bar chartC. Line chartD. Scatter chart with multiple seriesD
QuestionOption AOption BOption COption DAnswer
61. Which Excel function is used to calculate the sum of a range of cells?A. MAXB. MINC. SUMD. COUNTC
62. Which keyboard shortcut is used to paste the contents of a copied cell to another cell in Excel?A. Ctrl + CB. Ctrl + VC. Ctrl + XD. Ctrl + PB
63. Which chart type should be used to show the parts of a whole?A. Pie chartB. Bar chartC. Line chartD. Scatter chartA
64. Which Excel function is used to calculate the future value of an investment?A. PVB. FVC. RATED. PMTB
65. Which keyboard shortcut is used to insert a new column in Excel?A. Ctrl + CB. Ctrl + VC. Ctrl + Shift + CD. Ctrl + Shift + VC
66. Which Excel function is used to round a number up to the nearest integer?A. CEILINGB. FLOORC. ROUNDUPD. ROUNDDOWNA
67. Which feature in Excel allows you to group data based on time periods?A. FilterB. SortC. SubtotalD. Pivot tablesC
68. Which keyboard shortcut is used to save a workbook in Excel?A. Ctrl + SB. Ctrl + PC. Ctrl + QD. Ctrl + WA
69. Which Excel function is used to count the number of cells in a range that meet a specific criteria?A. COUNTB. COUNTIFC. SUMD. AVERAGEB
70. Which chart type should be used to show the comparison between different categories of data?A. Pie chartB. Bar chartC. Line chartD. Scatter chartB
QuestionOption AOption BOption COption DAnswer
71. Which Excel function is used to calculate the present value of an investment?A. PVB. FVC. RATED. PMTA
72. Which keyboard shortcut is used to select the entire worksheet in Excel?A. Ctrl + AB. Ctrl + Shift + AC. Ctrl + Alt + AD. Ctrl + HomeA
73. Which chart type should be used to show the trend of data over time?A. Pie chartB. Bar chartC. Line chartD. Scatter chartC
74. Which Excel function is used to calculate the payment for a loan?A. PVB. FVC. RATED. PMTD
75. Which keyboard shortcut is used to hide a row or column in Excel?A. Ctrl + HB. Ctrl + RC. Ctrl + 9D. Ctrl + 0C
76. Which Excel function is used to calculate the absolute value of a number?A. ABSB. SIGNC. ROUNDUPD. ROUNDDOWNA
77. Which feature in Excel allows you to summarize data based on multiple criteria?A. FilterB. SortC. SubtotalD. Pivot tablesD
78. Which keyboard shortcut is used to close a workbook in Excel?A. Ctrl + SB. Ctrl + PC. Ctrl + QD. Ctrl + WD
79. Which Excel function is used to calculate the average of a range of cells?A. MAXB. MINC. SUMD. AVERAGED
80. Which chart type should be used to show the relationship between two variables?A. Pie chartB. Bar chartC. Line chartD. Scatter chartD
QuestionOption AOption BOption COption DAnswer
81. Which Excel function is used to find the highest value in a range of cells?A. MAXB. MINC. SUMD. COUNTA
82. Which keyboard shortcut is used to insert a new row in Excel?A. Ctrl + CB. Ctrl + VC. Ctrl + Shift + CD. Ctrl + Shift + VD
83. Which chart type should be used to show the comparison between different data series over time?A. Pie chartB. Bar chartC. Line chartD. Scatter chartC
84. Which Excel function is used to calculate the interest rate of an investment?A. PVB. FVC. RATED. PMTC
85. Which keyboard shortcut is used to unhide a hidden row or column in Excel?A. Ctrl + HB. Ctrl + RC. Ctrl + 9D. Ctrl + 0D
86. Which Excel function is used to calculate the square root of a number?A. SQRTB. POWERC. ROUNDUPD. ROUNDDOWNA
87. Which feature in Excel allows you to group data based on categories?A. FilterB. SortC. SubtotalD. Pivot tablesD
88. Which keyboard shortcut is used to open the “Find and Replace” dialog box in Excel?A. Ctrl + FB. Ctrl + RC. Ctrl + HD. Ctrl + GC
89. Which Excel function is used to calculate the median of a range of cells?A. MAXB. MINC. SUMD. MEDIAND
90. Which chart type should be used to show the comparison between different data series that are not related to time?A. Pie chartB. Bar chartC. Line chartD. Scatter chartB
QuestionOption AOption BOption COption DAnswer
91. Which keyboard shortcut is used to open the “Go To” dialog box in Excel?A. Ctrl + GB. Ctrl + TC. Ctrl + YD. Ctrl + UA
92. Which chart type should be used to show the distribution of data?A. Pie chartB. Bar chartC. Line chartD. HistogramD
93. Which Excel function is used to round a number to the nearest integer?A. ROUNDUPB. ROUNDDOWNC. ROUNDD. CEILINGC
94. Which keyboard shortcut is used to select the entire worksheet in Excel?A. Ctrl + AB. Ctrl + EC. Ctrl + SD. Ctrl + XA
95. Which chart type should be used to show the relationship between two variables?A. Pie chartB. Bar chartC. Line chartD. Scatter chartD
96. Which Excel function is used to find the average of a range of cells?A. MAXB. MINC. SUMD. AVERAGED
97. Which keyboard shortcut is used to copy a formula to adjacent cells in Excel?A. Ctrl + CB. Ctrl + VC. Ctrl + DD. Ctrl + RC
98. Which feature in Excel allows you to combine multiple cells into one cell?A. Merge CellsB. Split CellsC. Center Across SelectionD. Wrap TextA
99. Which Excel function is used to calculate the standard deviation of a range of cells?A. STDEVB. VARC. STDEVAD. VARAA
100. Which keyboard shortcut is used to save a workbook in Excel?A. Ctrl + SB. Ctrl + OC. Ctrl + ND. Ctrl + PA

Share:

Leave a Reply

You May Also Like

Python is a versatile and widely-used programming language known for its simplicity and readability. Whether you’re a beginner or an...
Are you ready to test your knowledge and sharpen your skills in C# programming? Whether you’re a beginner looking to...
Are you ready to test your knowledge of Java? Whether you’re a beginner seeking to solidify your understanding of the...