| Join Telegram |  |
| Join Whatsapp Groups |  |
Advanced Excel Quiz – Multiple Choice Questions and Answers:On this page, you will find a fantastic collection of Advanced Excel Quiz Questions and Answers. This Advanced Excel Practice Test is equipped with accurate answers that you can check immediately after submission. Please note that we will keep adding more Advanced Excel MCQ Questions and Answers as per the placement drives being conducted. This Advanced Excel Practice Test evaluates candidates’ mastery of a wide range of its features and formulas. So, take action and thoroughly prepare with the Advanced Excel MCQ Quiz.
Advanced Excel Quiz
Further, before attempting the Advanced Excel MCQ Questions, do know the brief introduction about Advanced Excel through this section. Advanced Excel is an essential tool for individuals and organizations alike, providing a wide range of data analysis and management capabilities. With its powerful features and capabilities, Excel has become the go-to software for managing large amounts of data, performing complex calculations, creating charts and graphs, and automating repetitive tasks. Advanced Excel takes these capabilities to the next level, providing users with even more powerful tools for managing and analyzing data.
Advanced Excel Multiple Choice Questions and Answers – Overview
| Quiz Name | Advanced Excel Quiz |
| Exam Type | MCQ (Multiple Choice Questions) |
| Category | Technical Quiz |
| Mode of Quiz | Online |
Top 60 Advanced Excel MCQs with Answers | Advanced Excel Quiz
1. What is the shortcut key to display the “Format Cells” dialog box in Excel?
a) Ctrl+1
b) Ctrl+2
c) Ctrl+3
d) Ctrl+4
Answer: a) Ctrl+1
Explanation: Ctrl+1 is the shortcut key to display the “Format Cells” dialog box in Excel. This dialog box allows you to change the formatting of cells, such as font, alignment, and number format.
2. Which of the following functions is used to find the highest value in a range of cells?
a) MAX
b) MIN
c) AVERAGE
d) COUNT
Answer: a) MAX
Explanation: The MAX function is used to find the highest value in a range of cells. For example, =MAX(A1:A10) would return the highest value in cells A1 through A10.
3. What is the shortcut key to create a new worksheet in Excel?
a) Ctrl+N
b) Ctrl+W
c) Ctrl+Shift+N
d) Ctrl+Alt+N
Answer: c) Ctrl+Shift+N
Explanation: Ctrl+Shift+N is the shortcut key to create a new worksheet in Excel. This creates a new tab at the bottom of the workbook with a blank worksheet.
4. Which of the following chart types is used to display trends over time?
a) Line chart
b) Bar chart
c) Pie chart
d) Scatter chart
Answer: a) Line chart
Explanation: A line chart is used to display trends over time. For example, you might use a line chart to show how your company’s sales have increased or decreased over the past year.
5. What is the shortcut key to insert a new row in Excel?
a) Ctrl+R
b) Ctrl+I
c) Ctrl+Shift+R
d) Ctrl+Alt+R
Answer: b) Ctrl+I
Explanation: Ctrl+I is the shortcut key to insert a new row in Excel. This will insert a new row above the currently selected row.
6. Which of the following functions is used to count the number of cells in a range that contain a specific value?
a) COUNTIF
b) SUMIF
c) AVERAGEIF
d) MAXIF
Answer: a) COUNTIF
Explanation: The COUNTIF function is used to count the number of cells in a range that contain a specific value. For example, =COUNTIF(A1:A10,”Apples”) would count the number of cells in A1 through A10 that contain the word “Apples”.
7. What is the shortcut key to switch between worksheets in Excel?
a) Ctrl+Tab
b) Ctrl+Page Up
c) Ctrl+Page Down
d) Alt+Tab
Answer: c) Ctrl+Page Down
Explanation: Ctrl+Page Down is the shortcut key to switch between worksheets in Excel. This will move to the next worksheet in the workbook.
8. Which of the following chart types is used to compare values across different categories?
a) Line chart
b) Bar chart
c) Pie chart
d) Scatter chart
Answer: b) Bar chart
Explanation: A bar chart is used to compare values across different categories. For example, you might use a bar chart to compare the sales of different products.
9. What is the shortcut key to format a cell as bold in Excel?
a) Ctrl+B
b) Ctrl+U
c) Ctrl+I
d) Ctrl+Shift+B
Answer: a) Ctrl+B
Explanation: Ctrl+B is the shortcut key to format a cell as bold in Excel. This will make the text in the cell bold.
10. Which of the following functions is used to find the average of a range of cells?
a) MAX
b) MIN
c) AVERAGE
d) COUNT
Answer: c) AVERAGE
Explanation: The AVERAGE function is used to find the average of a range of cells. For example, =AVERAGE(A1:A10) would return the average value of cells A1 through A10.
11. What is the shortcut key to display the “Find and Replace” dialog box in Excel?
a) Ctrl+F
b) Ctrl+H
c) Ctrl+R
d) Ctrl+Shift+F
Answer: b) Ctrl+H
Explanation: Ctrl+H is the shortcut key to display the “Find and Replace” dialog box in Excel. This dialog box allows you to search for and replace specific values in your worksheet.
12. Which of the following chart types is used to show the relationship between two sets of data?
a) Line chart
b) Bar chart
c) Pie chart
d) Scatter chart
Answer: d) Scatter chart
Explanation: A scatter chart is used to show the relationship between two sets of data. For example, you might use a scatter chart to show how the price of a product affects its sales.
13. What is the shortcut key to select all cells in a worksheet in Excel?
a) Ctrl+A
b) Ctrl+S
c) Ctrl+Shift+A
d) Ctrl+Alt+A
Answer: a) Ctrl+A
Explanation: Ctrl+A is the shortcut key to select all cells in a worksheet in Excel. This will highlight all cells in the active worksheet.
14. Which of the following functions is used to find the smallest value in a range of cells?
a) MAX
b) MIN
c) AVERAGE
d) COUNT
Answer: b) MIN
Explanation: The MIN function is used to find the smallest value in a range of cells. For example, =MIN(A1:A10) would return the smallest value in cells A1 through A10.
15. What is the shortcut key to save an Excel workbook?
a) Ctrl+S
b) Ctrl+W
c) Ctrl+Shift+S
d) Ctrl+Alt+S
Answer: a) Ctrl+S
Explanation: Ctrl+S is the shortcut key to save an Excel workbook. This will save any changes you have made to the current workbook.
16. Which of the following chart types is used to show the parts of a whole?
a) Line chart
b) Bar chart
c) Pie chart
d) Scatter chart
Answer: c) Pie chart
Explanation: A pie chart is used to show the parts of a whole. For example, you might use a pie chart to show how your company’s revenue is divided among different products.
17. What is the shortcut key to paste values in Excel?
a) Ctrl+V
b) Ctrl+Shift+V
c) Ctrl+Alt+V
d) Ctrl+P
Answer: b) Ctrl+Shift+V
Explanation: Ctrl+Shift+V is the shortcut key to paste values in Excel. This will paste only the values of the copied cells, without any formatting or formulas.
18. Which of the following functions is used to find the total of a range of cells?
a) MAX
b) MIN
c) AVERAGE
d) SUM
Answer: d) SUM
Explanation: The SUM function is used to find the total of a range of cells. For example, =SUM(A1:A10) would return the sum of cells A1 through A10.
19. Which of the following chart types is used to show the distribution of data?
a) Line chart
b) Bar chart
c) Histogram chart
d) Scatter chart
Answer: c) Histogram chart
Explanation: A histogram chart is used to show the distribution of data. For example, you might use a histogram chart to show the distribution of grades in a class.
20. Which of the following functions is used to round a number to a specified number of decimal places?
a) ROUNDUP
b) ROUNDDOWN
c) ROUND
d) TRUNC
Answer: c) ROUND
Explanation: The ROUND function is used to round a number to a specified number of decimal places. For example, =ROUND(3.14159, 2) would return 3.14.
21. What is the shortcut key to display the “Page Setup” dialog box in Excel?
a) Ctrl+P
b) Ctrl+Shift+P
c) Ctrl+Alt+P
d) Ctrl+Shift+F
Answer: d) Ctrl+Shift+F
Explanation: Ctrl+Shift+F is the shortcut key to display the “Page Setup” dialog box in Excel. This dialog box allows you to set up the print area, margins, and other print options.
22. Which of the following chart types is used to show the ranking or order of data?
a) Line chart
b) Bar chart
c) Pie chart
d) Scatter chart
Answer: b) Bar chart
Explanation: A bar chart is used to show the ranking or order of data. For example, you might use a bar chart to show the sales of different products, ranked from highest to lowest.
23. What is the shortcut key to open the “Format Cells” dialog box in Excel?
a) Ctrl+1
b) Ctrl+2
c) Ctrl+3
d) Ctrl+4
Answer: a) Ctrl+1
Explanation: Ctrl+1 is the shortcut key to open the “Format Cells” dialog box in Excel. This dialog box allows you to format the appearance of cells, including number formats, font styles, and cell borders.
24. Which of the following functions is used to find the largest value in a range of cells?
a) MAX
b) MIN
c) AVERAGE
d) COUNT
Answer: a) MAX
Explanation: The MAX function is used to find the largest value in a range of cells. For example, =MAX(A1:A10) would return the largest value in cells A1 through A10.
25. What is the shortcut key to select an entire column in Excel?
a) Ctrl+C
b) Ctrl+X
c) Ctrl+Space
d) Ctrl+Shift+Space
Answer: c) Ctrl+Space
Explanation: Ctrl+Space is the shortcut key to select an entire column in Excel. This will highlight all cells in the selected column.
26. Which of the following chart types is used to show trends over time?
a) Line chart
b) Bar chart
c) Pie chart
d) Scatter chart
Answer: a) Line chart
Explanation: A line chart is used to show trends over time. For example, you might use a line chart to show how your company’s revenue has changed over the past year.
27. Which of the following functions is used to calculate the variance of a range of cells?
a) VAR
b) VARP
c) STDEV
d) STDEVP
Answer: a) VAR
Explanation: The VAR function is used to calculate the variance of a range of cells. Variance is a measure of how spread out a set of data is. For example, =VAR(A1:A10) would return the variance of cells A1 through A10.
28. What is the shortcut key to open the “Insert Function” dialog box in Excel?
a) Shift+F3
b) Ctrl+F3
c) Alt+F3
d) F3
Answer: c) Alt+F3
Explanation: Alt+F3 is the shortcut key to open the “Insert Function” dialog box in Excel. This dialog box allows you to select a function from a list and enter its arguments.
29. Which of the following chart types is used to show how parts of a whole contribute to the whole?
a) Line chart
b) Bar chart
c) Pie chart
d) Scatter chart
Answer: c) Pie chart
Explanation: A pie chart is used to show how parts of a whole contribute to the whole. For example, you might use a pie chart to show the percentage of a company’s revenue that comes from different products.
30. What is the shortcut key to hide a column in Excel?
a) Ctrl+H
b) Ctrl+K
c) Ctrl+L
d) Ctrl+0
Answer: d) Ctrl+0
Explanation: Ctrl+0 is the shortcut key to hide a column in Excel. This will hide the currently selected column.
31. Which of the following functions is used to calculate the average of a range of cells, ignoring zero values?
a) AVERAGE
b) AVERAGEIF
c) AVERAGEIFS
d) AGGREGATE
Answer: d) AGGREGATE
Explanation: The AGGREGATE function is used to calculate the average of a range of cells, ignoring zero values. For example, =AGGREGATE(1, 6, A1:A10) would return the average of cells A1 through A10, ignoring any zero values.
32. What is the shortcut key to select an entire row in Excel?
a) Shift+Space
b) Ctrl+Space
c) Alt+Space
d) Ctrl+Shift+Space
Answer: a) Shift+Space
Explanation: Shift+Space is the shortcut key to select an entire row in Excel. This will highlight all cells in the selected row.
33. Which of the following chart types is used to show the relationship between two variables?
a) Line chart
b) Bar chart
c) Scatter chart
d) Pie chart
Answer: c) Scatter chart
Explanation: A scatter chart is used to show the relationship between two variables. For example, you might use a scatter chart to show the correlation between a company’s advertising spending and its revenue.
34. What is the shortcut key to open the “Sort” dialog box in Excel?
a) Ctrl+S
b) Ctrl+Shift+S
c) Alt+S
d) Ctrl+Alt+S
Answer: d) Ctrl+Alt+S
Explanation: Ctrl+Alt+S is the shortcut key to open the “Sort” dialog box in Excel. This dialog box allows you to sort a range of cells based on one or more criteria.
35. Which of the following functions is used to count the number of cells in a range that meet a specified condition?
a) COUNT
b) COUNTIF
c) COUNTIFS
d) SUMIF
Answer: b) COUNTIF
Explanation: The COUNTIF function is used to count the number of cells in a range that meet a specified condition. For example, =COUNTIF(A1:A10, “>50”) would count the number of cells in cells A1 through A10 that contain a value greater than 50.
36. What is the shortcut key to move to the next sheet in an Excel workbook?
a) Ctrl+Tab
b) Alt+Tab
c) Ctrl+Page Down
d) Alt+Page Down
Answer: d) Alt+Page Down
Explanation: Alt+Page Down is the shortcut key to move to the next sheet in an Excel workbook. You can use this shortcut key to quickly switch between sheets.
37. Which of the following chart types is used to show changes in data over time?
a) Line chart
b) Bar chart
c) Scatter chart
d) Pie chart
Answer: a) Line chart
Explanation: A line chart is used to show changes in data over time. For example, you might use a line chart to show the trend in a company’s revenue over several quarters.
38. What is the shortcut key to open the “Find and Replace” dialog box in Excel?
a) Ctrl+F
b) Ctrl+R
c) Ctrl+H
d) Ctrl+Shift+F
Answer: c) Ctrl+H
Explanation: Ctrl+H is the shortcut key to open the “Find and Replace” dialog box in Excel. This dialog box allows you to search for and replace text or values in a range of cells.
39. Which of the following functions is used to round a number to the nearest integer?
a) ROUND
b) ROUNDDOWN
c) ROUNDUP
d) INT
Answer: a) ROUND
Explanation: The ROUND function is used to round a number to the nearest integer. For example, =ROUND(3.5) would return 4.
40. What is the shortcut key to select all cells in an Excel worksheet?
a) Ctrl+A
b) Ctrl+Shift+A
c) Ctrl+Alt+A
d) Alt+A
Answer: a) Ctrl+A
Explanation: Ctrl+A is the shortcut key to select all cells in an Excel worksheet. This will highlight all cells in the worksheet.
41. What is the shortcut key to create a new worksheet in an Excel workbook?
a) Ctrl+N
b) Alt+N
c) Shift+N
d) Ctrl+Shift+N
Answer: a) Ctrl+N
Explanation: Ctrl+N is the shortcut key to create a new worksheet in an Excel workbook. This will create a new worksheet with the default name “Sheet1”.
42. Which of the following functions is used to concatenate two or more strings in Excel?
a) CONCATENATE
b) CONCAT
c) TEXTJOIN
d) JOIN
Answer: b) CONCAT
Explanation: The CONCAT function is used to concatenate two or more strings in Excel. For example, =CONCAT(A1, ” “, B1) would concatenate the values in cells A1 and B1 with a space between them.
43. Which of the following functions is used to calculate the variance of a range of cells in Excel?
a) VARIANCE
b) VAR
c) STDEV
d) AVERAGE
Answer: b) VAR
Explanation: The VAR function is used to calculate the variance of a range of cells in Excel. For example, =VAR(A1:A10) would calculate the variance of the values in cells A1 through A10.
44. What is the shortcut key to switch between absolute, relative, and mixed cell references in a formula?
a) F4
b) F5
c) F6
d) F7
Answer: a) F4
Explanation: F4 is the shortcut key to switch between absolute, relative, and mixed cell references in a formula. You can use this shortcut key to quickly change the reference type in a formula.
45. What is the shortcut key to insert a new row in an Excel worksheet?
a) Ctrl+R
b) Alt+R
c) Shift+R
d) Ctrl+Shift+R
Answer: b) Alt+R
Explanation: Alt+R is the shortcut key to insert a new row in an Excel worksheet. You can use this shortcut key to quickly add a new row to your worksheet.
46. Which of the following functions is used to calculate the standard deviation of a range of cells in Excel?
a) VARIANCE
b) VAR
c) STDEV
d) AVERAGE
Answer: c) STDEV
Explanation: The STDEV function is used to calculate the standard deviation of a range of cells in Excel. For example, =STDEV(A1:A10) would calculate the standard deviation of the values in cells A1 through A10.
47. What is the shortcut key to insert a new column in an Excel worksheet?
a) Ctrl+C
b) Alt+C
c) Shift+C
d) Ctrl+Shift+C
Answer: b) Alt+C
Explanation: Alt+C is the shortcut key to insert a new column in an Excel worksheet. You can use this shortcut key to quickly add a new column to your worksheet.
48. Which of the following chart types is used to show the proportion of each value to the total?
a) Line chart
b) Bar chart
c) Scatter chart
d) Pie chart
Answer: d) Pie chart
Explanation: A pie chart is used to show the proportion of each value to the total. For example, you might use a pie chart to show the percentage of sales from each product in a company.
49. What is the shortcut key to format cells in Excel?
a) Ctrl+1
b) Alt+1
c) Shift+1
d) Ctrl+Shift+1
Answer: a) Ctrl+1
Explanation: Ctrl+1 is the shortcut key to format cells in Excel. This will open the “Format Cells” dialog box, which allows you to format cells in various ways.
50. Which of the following functions is used to count the number of cells in a range that contain a numeric value?
a) COUNT
b) COUNTA
c) COUNTBLANK
d) COUNTIF
Answer: a) COUNT
Explanation: The COUNT function is used to count the number of cells in a range that contain a numeric value. For example, =COUNT(A1:A10) would count the number of cells in cells A1 through A10 that contain a numeric value.
51. What is the shortcut key to insert a hyperlink in Excel?
a) Ctrl+K
b) Alt+K
c) Shift+K
d) Ctrl+Shift+K
Answer: a) Ctrl+K
Explanation: Ctrl+K is the shortcut key to insert a hyperlink in Excel. You can use this shortcut key to quickly insert a hyperlink to another location, such as a website or another worksheet in your workbook.
52. What is the shortcut key to copy a cell or range of cells in Excel?
a) Ctrl+C
b) Alt+C
c) Shift+C
d) Ctrl+Shift+C
Answer: a) Ctrl+C
Explanation: Ctrl+C is the shortcut key to copy a cell or range of cells in Excel. You can use this shortcut key to quickly copy data to another location in your worksheet or to another worksheet or workbook.
53. Which of the following functions is used to count the number of cells in a range that are not empty?
a) COUNT
b) COUNTA
c) COUNTBLANK
d) COUNTIF
Answer: b) COUNTA
Explanation: The COUNTA function is used to count the number of cells in a range that are not empty. For example, =COUNTA(A1:A10) would count the number of cells in cells A1 through A10 that are not empty.
54. What is the shortcut key to paste copied data in Excel?
a) Ctrl+V
b) Alt+V
c) Shift+V
d) Ctrl+Shift+V
Answer: a) Ctrl+V
Explanation: Ctrl+V is the shortcut key to paste copied data in Excel. You can use this shortcut key to quickly paste data that you have copied to another location in your worksheet or to another worksheet or workbook.
55. Which of the following chart types is used to compare values side by side?
a) Line chart
b) Bar chart
c) Scatter chart
d) Pie chart
Answer: b) Bar chart
Explanation: A bar chart is used to compare values side by side. For example, you might use a bar chart to compare the sales of different products in a company.
56. What is the shortcut key to select the entire worksheet in Excel?
a) Ctrl+A
b) Alt+A
c) Shift+A
d) Ctrl+Shift+A
Answer: a) Ctrl+A
Explanation: Ctrl+A is the shortcut key to select the entire worksheet in Excel. You can use this shortcut key to quickly select all the cells in your worksheet.
57. Which of the following functions is used to count the number of cells in a range that meet a specific criteria?
a) COUNT
b) COUNTA
c) COUNTBLANK
d) COUNTIF
Answer: d) COUNTIF
Explanation: The COUNTIF function is used to count the number of cells in a range that meet a specific criteria. For example, =COUNTIF(A1:A10, “>50”) would count the number of cells in cells A1 through A10 that are greater than 50.
58. What is the shortcut key to insert a new worksheet in Excel?
a) Ctrl+N
b) Alt+N
c) Shift+N
d) Ctrl+Shift+N
Answer: d) Ctrl+Shift+N
Explanation: Ctrl+Shift+N is the shortcut key to insert a new worksheet in Excel. You can use this shortcut key to quickly add a new worksheet to your workbook.
59. Which of the following functions is used to find the highest value in a range?
a) MAX
b) MIN
c) SUM
d) AVERAGE
Answer: a) MAX
Explanation: The MAX function is used to find the highest value in a range. For example, =MAX(A1:A10) would find the highest value in cells A1 through A10.
60. What is the shortcut key to save a workbook in Excel?
a) Ctrl+S
b) Alt+S
c) Shift+S
d) Ctrl+Shift+S
Answer: a) Ctrl+S
Explanation: Ctrl+S is the shortcut key to save a workbook in Excel. You can use this shortcut key to quickly save your changes to the current workbook.
Advanced Excel MCQs are an excellent way to test and enhance one’s proficiency in managing and analyzing data using Excel. These Advanced Excel MCQs can help individuals and organizations identify areas of improvement, making it easier to achieve their data management and analysis goals. For more such quizzes keep following our Freshersnow website daily.