Excel MCQ Questions and Answers

Leave a Comment / By /

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?

a) .xls
b) .xlsx
c) .xlsm
d) .xlt

Answer:

b) .xlsx

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?

a) SUM()
b) TOTAL()
c) ADD()
d) PLUS()

Answer:

a) SUM()

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?

a) View tab > Window group > Freeze Panes
b) Home tab > Cells group > Freeze Panes
c) Data tab > Freeze Panes
d) Insert tab > Freeze Panes

Answer:

a) View tab > Window group > Freeze Panes

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?

a) To change the style of a table
b) To organize and summarize complex data
c) To merge multiple sheets
d) To create a new workbook

Answer:

b) To organize and summarize complex data

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?

a) Checks the visibility of specific cells
b) Looks up and retrieves data from a specific column in a table
c) Calculates the variance of a set of numbers
d) Converts text to values

Answer:

b) Looks up and retrieves data from a specific column in a table

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?

a) Home tab > Editing group > Sort & Filter
b) Data tab > Sort & Filter group > Filter
c) Insert tab > Filter
d) Review tab > Filter

Answer:

b) Data tab > Sort & Filter group > Filter

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?

a) Ctrl + N
b) Ctrl + B
c) Ctrl + X
d) Ctrl + M

Answer:

a) Ctrl + N

Explanation:

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

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

a) To change the format of the text
b) To format a cell based on its value
c) To protect cells
d) To highlight duplicate values

Answer:

b) To format a cell based on its value

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?

a) Right-click on the row number and select 'Insert'
b) Home tab > Cells group > Insert
c) Data tab > Insert Row
d) Review tab > Insert

Answer:

a) Right-click on the row number and select 'Insert'

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?

a) A collection of charts
b) A single spreadsheet
c) A collection of worksheets
d) A template

Answer:

c) A collection of worksheets

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?

a) AutoFill
b) Copy/Paste
c) Drag/Drop
d) AutoSum

Answer:

a) AutoFill

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?

a) Pie chart
b) Line chart
c) Scatter plot
d) Bar chart

Answer:

c) Scatter plot

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?

a) Integrates formulas
b) Performs a logical test and returns one value for a TRUE result, and another for a FALSE result
c) Increases font size
d) Identifies functions

Answer:

b) Performs a logical test and returns one value for a TRUE result, and another for a FALSE result

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?

a) A collection of data
b) The intersection of a row and a column
c) A formula
d) A chart element

Answer:

b) The intersection of a row and a column

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?

a) Right-click the column header and choose 'Hide'
b) Home tab > Editing group > Hide
c) Data tab > Hide Column
d) Insert tab > Hide

Answer:

a) Right-click the column header and choose 'Hide'

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?

a) CONCATENATE()
b) MERGE()
c) COMBINE()
d) JOIN()

Answer:

a) CONCATENATE()

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?

a) To validate the accuracy of formulas
b) To ensure the integrity of data entered into cells
c) To check the spelling in the data
d) To validate the formatting of cells

Answer:

b) To ensure the integrity of data entered into cells

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?

a) Data tab > Data Tools group > Data Validation
b) Insert tab > Dropdown List
c) Home tab > Editing group > Dropdown List
d) View tab > Dropdown List

Answer:

a) Data tab > Data Tools group > Data Validation

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?

a) Counts the number of cells that contain text
b) Counts the number of cells that contain numbers
c) Calculates the total sum of a range of cells
d) Counts the number of characters in a cell

Answer:

b) Counts the number of cells that contain numbers

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?

a) Click and drag to select multiple sheets
b) Right-click a worksheet tab and select 'Group'
c) Hold down Ctrl and click each worksheet you want to group
d) Go to the Data tab and select 'Group Sheets'

Answer:

c) Hold down Ctrl and click each worksheet you want to group

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?

a) Ctrl + S
b) Ctrl + W
c) Ctrl + E
d) Ctrl + X

Answer:

a) Ctrl + S

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?

a) Quick Analysis
b) Data Analysis
c) PivotTable
d) Solver

Answer:

a) Quick Analysis

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?

a) Splits a single cell into multiple cells
b) Combines text from two or more cells into one cell
c) Adds up all the numbers in a range of cells
d) Compares two cells for similarities

Answer:

b) Combines text from two or more cells into one cell

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?

a) To arrange data in a random order
b) To filter out specific data
c) To organize data in ascending or descending order
d) To delete unnecessary data

Answer:

c) To organize data in ascending or descending order

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?

a) Review tab > Proofing group > Protect Sheet
b) Review tab > Changes group > Protect Sheet/Protect Workbook
c) Home tab > Cells group > Protect Sheet
d) Data tab > Protect Sheet

Answer:

b) Review tab > Changes group > Protect Sheet/Protect Workbook

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.

Related MCQ (Multiple Choice Questions) :

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top