Here are 25 multiple-choice questions (MCQs) focused on Microsoft Excel, complete with answers and explanations. These questions cover a range of functionalities and features of Excel.

## 1. What is the default file extension of an Excel workbook?

### Answer:

### Explanation:

The default file extension for an Excel workbook in newer versions is .xlsx, which stands for Microsoft Excel Open XML Spreadsheet.

## 2. Which function in Excel gives the sum of a range of cells?

### Answer:

### Explanation:

The SUM() function is used in Excel to calculate the total sum of a range of cells.

## 3. How can you freeze panes in Excel?

### Answer:

### Explanation:

Freezing panes in Excel is done via the View tab in the Window group, allowing you to keep specific rows or columns visible while scrolling through the sheet.

## 4. What is the purpose of a PivotTable in Excel?

### Answer:

### Explanation:

PivotTables in Excel are powerful tools used to organize and summarize complex data sets, allowing for a more in-depth analysis.

## 5. What does VLOOKUP function do in Excel?

### Answer:

### Explanation:

VLOOKUP function in Excel is used to search for a value in the first column of a table array and returns a value in the same row from a specified column.

## 6. How do you apply a filter to a data range in Excel?

### Answer:

### Explanation:

To apply a filter to a data range in Excel, use the Filter option in the Sort & Filter group under the Data tab.

## 7. Which keyboard shortcut is used to create a new Excel workbook?

### Answer:

### Explanation:

The keyboard shortcut Ctrl + N is used to create a new Excel workbook.

## 8. What is the purpose of Conditional Formatting in Excel?

### Answer:

### Explanation:

Conditional Formatting in Excel is used to format cells automatically based on their values, such as coloring cells with high or low values.

## 9. How do you insert a new row in Excel?

### Answer:

### Explanation:

To insert a new row in Excel, right-click on the row number where you want the new row and then select 'Insert'.

## 10. What is a 'Workbook' in Excel?

### Answer:

### Explanation:

In Excel, a workbook is a file that contains one or more worksheets to help organize data in a more manageable way.

## 11. What feature in Excel allows you to apply the same formula to an entire column or row?

### Answer:

### Explanation:

The AutoFill feature in Excel allows you to extend a series or apply the same formula to an entire row or column by dragging the fill handle.

## 12. Which chart type in Excel shows the relationship between two variables?

### Answer:

### Explanation:

A scatter plot (or scatter chart) in Excel is used to display the relationship between two numerical variables.

## 13. What does the 'IF' function do in Excel?

### Answer:

### Explanation:

The 'IF' function in Excel is used to perform a logical test, returning one value if the condition is TRUE and another value if it's FALSE.

## 14. What is a 'Cell' in Excel?

### Answer:

### Explanation:

In Excel, a cell is the basic unit where data is stored, and it is identified by the intersection of a row and a column.

## 15. How can you hide a column in Excel?

### Answer:

### Explanation:

To hide a column in Excel, right-click the column header and select 'Hide' from the context menu.

## 16. Which function would you use to combine the text from two or more cells into one cell?

### Answer:

### Explanation:

The CONCATENATE() function in Excel is used to combine the text from two or more cells into one cell.

## 17. What is the purpose of 'Data Validation' in Excel?

### Answer:

### Explanation:

Data Validation in Excel is used to control the type of data or the values that users enter into a cell.

## 18. How do you create a dropdown list in a cell in Excel?

### Answer:

### Explanation:

To create a dropdown list in Excel, go to the Data tab, select Data Validation in the Data Tools group, and set the criteria for the dropdown.

## 19. What does the 'COUNT' function in Excel do?

### Answer:

### Explanation:

The COUNT function in Excel is used to count the number of cells that contain numbers within a range.

## 20. How can you group worksheets in Excel?

### Answer:

### Explanation:

To group worksheets in Excel, hold down the Ctrl key and click each worksheet tab you want to include in the group.

## 21. What is the keyboard shortcut for saving an Excel workbook?

### Answer:

### Explanation:

The keyboard shortcut for saving an Excel workbook is Ctrl + S, a common shortcut in many software applications for the save operation.

## 22. Which feature in Excel is used to quickly analyze data and provide different viewing options?

### Answer:

### Explanation:

Quick Analysis in Excel provides a set of analytical tools (like formatting, charts, and totals) that can be applied to a selected data range with just a few clicks.

## 23. What does the 'Concatenate' function do in Excel?

### Answer:

### Explanation:

The 'Concatenate' function in Excel is used to join two or more text strings into one string.

## 24. What is the purpose of 'Data Sorting' in Excel?

### Answer:

### Explanation:

Data Sorting in Excel is used to organize data either in an ascending or descending order, based on numerical, textual, or date data.

## 25. How do you protect a worksheet or workbook in Excel?

### Answer:

### Explanation:

To protect a worksheet or workbook in Excel, go to the Review tab and use the options in the Changes group. You can choose to protect the current sheet or the entire workbook with or without a password.