Multiple Choice Interview Questions & Answers- MS Excel 2025

 MS Excel 2025 – Multiple Choice Interview Questions & Answers

1. What is the role of AI in Excel 2025?

A) Only used for spell checking

B) Provides predictive analytics, automation, and real-time insights

C) Used only for data visualization

D) No AI features are available in Excel

Answer: B) Provides predictive analytics, automation, and real-time insights

2. Which shortcut key is used to apply filters in Excel?

A) Ctrl + F

B) Ctrl + Shift + L

C) Alt + F4

D) Ctrl + P

Answer: B) Ctrl + Shift + L

3. What is the function of the “Copilot” AI feature in Excel 2025?

A) Assists in creating advanced formulas and automates tasks

B) Only suggests formatting changes

C) Only works in PowerPoint, not Excel

D) Used for internet browsing within Excel

Answer: A) Assists in creating advanced formulas and automates tasks

4. Which function is used for AI-driven data forecasting in Excel 2025?

A) =SUM()

B) =FORECAST.ETS()

C) =VLOOKUP()

D) =TEXT()

Answer: B) =FORECAST.ETS()

5. Which AI-powered feature helps in generating summaries and insights from data?

A) Smart Insights

B) Flash Fill

C) Pivot Tables

D) Power Query

Answer: A) Smart Insights

6. Which shortcut is used to insert a new row in Excel?

A) Ctrl + Shift + "+"

B) Ctrl + Alt + R

C) Ctrl + Enter

D) Shift + Space

Answer: A) Ctrl + Shift + "+"

7. What is the purpose of Power Query in Excel?

A) To create animated charts

B) To clean, transform, and import data from multiple sources

C) To automatically save the workbook

D) To convert Excel files into PDFs

Answer: B) To clean, transform, and import data from multiple sources

8. How does Excel 2025 handle large datasets efficiently?

A) Uses AI-powered formulas and dynamic arrays

B) Slows down when handling large data

C) Requires third-party plugins for optimization

D) Only works with small datasets

Answer: A) Uses AI-powered formulas and dynamic arrays

9. What is the use of the "Get & Transform" feature in Excel?

A) To create animated presentations

B) To automate repetitive tasks

C) To connect, clean, and analyze data from various sources

D) To insert new rows and columns

Answer: C) To connect, clean, and analyze data from various sources

10. Which AI-driven feature in Excel allows users to ask questions in natural language and get instant answers?

A) Smart Chat

B) Data Insights

C) Power Automate

D) Excel Copilot

Answer: D) Excel Copilot