Top Microsoft Excel Test - 35+ MCQs: Microsoft Excel test: Evaluate Your Spreadsheet Skills with Excel Questions and Answers

1. Which option allows you to create a new worksheet in an Excel workbook?

Insert Worksheet option

New Worksheet option

Add Worksheet option

Create Worksheet option

2. Which formula can be used to count the number of cells in a range that contain numbers?

SUMIF

COUNT

COUNTIF

SUM

3. Which keyboard shortcut is used to open the 'Find and Replace' dialog box in Excel?

Ctrl + F

Ctrl + R

Alt + F

Alt + R

4. How can you sort data alphabetically in Excel?

Using the Sort A to Z option in the Data Tab

Right-clicking and selecting Sort

Using the Format Cells dialog box

Applying a sort style

5. Which formula can be used to calculate the internal rate of return (IRR) in Excel?

IRR

NPV

XIRR

6. Which Excel feature allows you to create dynamic dashboards?

Power View

Dashboard Builder

Visualization Tools

Report Designer

7. Which feature in Excel allows you to collaborate with others in real-time?

Co-authoring

Track Changes

Comments

Version History

8. How can you protect specific cells from being edited in Excel?

Using the Protect Sheet feature

Applying a cell lock format

Using the Hide Cells feature

Applying a password to the workbook

9. What is the default extension for an Excel workbook file?

.xls

.xlsx

.exl

.xl

10. Which option allows you to adjust the width of columns in Excel?

Column Width option in the Format Tab

Dragging the column boundary

Using the AutoFit Column Width option

Applying a column style

11. How can you apply conditional formatting to highlight cells that contain specific text?

Using the Conditional Formatting option in the Home Tab

Applying a text style

Using the Find and Replace feature

Setting custom cell formats

12. How can you link data between multiple Excel workbooks?

Using the Paste Link option

Applying a hyperlink

Using the Import Data feature

Setting cell references manually

13. How can you protect a specific cell from being edited in Excel?

Using the Protect Sheet option

Setting a cell lock in the Format Cells dialog box

Applying Data Validation

Using the Freeze Panes option

14. Which function is used to sum a range of cells in Microsoft Excel?

TOTAL

SUM

ADD

COUNT

15. What is the purpose of the VLOOKUP function in Excel?

To vertically search for a value in a table

To validate data entries

To perform vertical calculations

To visualize data trends

16. Which feature allows you to visualize data trends over time in Excel?

Sparklines

Data Bars

Color Scales

Icon Sets

17. How can you create a pivot table in Excel?

Using the Pivot Table option in the Insert Tab

Using the Data Analysis Toolpak

Applying a Pivot Table style

Using the Advanced Options in the Home Tab

18. How can you apply a filter to data in an Excel spreadsheet?

Using the Filter option in the Data Tab

Right-clicking on the data and selecting Filter

Using the Sort option in the Home Tab

Applying Conditional Formatting

19. Which function is used to extract the middle name from a full name in Excel?

MID

MIDDLE

SUBSTRING

EXTRACT

20. How can you apply a border to a cell in Excel?

Using the Border option in the Home Tab

Right-clicking and selecting Border

Using the Format Cells dialog box

Applying a cell style

21. How can you change the font size of selected text in an Excel cell?

Using the Font Size option in the Home Tab

Right-clicking and selecting Font Size

Using the Format Cells dialog box

Applying a cell style

22. How can you protect an entire Excel workbook from unauthorized access?

Using the Protect Workbook option in the Review Tab

Applying a password to individual cells

Using the Hide Workbook feature

Setting permissions in the File Properties

23. Which Excel feature allows you to track changes made to a workbook?

Track Changes

Version History

Audit Trail

Revision Control

24. How can you merge multiple cells into a single cell in Excel?

Using the Merge & Center option in the Home Tab

Right-clicking and selecting Merge Cells

Using the Format Cells dialog box

Applying a cell style

25. How can you create a custom data validation rule in Excel?

Using the Data Validation feature

Applying a predefined rule

Using the Conditional Formatting feature

Applying a custom format

26. How can you split text from one cell into multiple cells based on a delimiter in Excel?

Using the Text to Columns feature

Applying a split function

Using the CONCATENATE function

Setting custom cell formats

27. How can you apply a currency format to cells in Excel?

Using the Number Format option in the Home Tab

Right-clicking and selecting Currency

Using the Format Cells dialog box

Applying a cell style

28. Which chart type is best suited for displaying trends over a period in Excel?

Pie Chart

Bar Chart

Line Chart

Scatter Plot

29. How can you create a custom Excel function using VBA?

Using the Visual Basic Editor

Applying a custom formula

Using the Function Wizard

Applying a macro

30. Which Excel feature allows you to create automated workflows and data integrations?

Power Automate

Data Connections

Data Validation

Scenario Manager

Microsoft Excel MCQ Test 1