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

1. How can you create a dynamic array in Excel without using array formulas?

Using the new spill functionality

Applying conditional formatting

Using the Array function

Applying data validation rules

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

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

IRR

NPV

XIRR

9. How can you perform a Monte Carlo simulation in Excel?

Using the Analysis Toolpak

Applying conditional formatting

Using the Scenario Manager

Applying data validation rules

10. 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

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 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

13. 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

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

MID

MIDDLE

SUBSTRING

EXTRACT

15. 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

16. 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

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

Power View

Dashboard Builder

Visualization Tools

Report Designer

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

TOTAL

SUM

ADD

COUNT

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

Co-authoring

Track Changes

Comments

Version History

20. Which Excel tool can be used to perform complex data analysis and visualization?

Power BI

Power Query

Power Map

Power Pivot

Microsoft Excel MCQ Test 2