- What is Power Query in Excel?
Power Query is a data transformation and data preparation tool that allows users to import, clean, transform, and load data from various sources such as databases, web pages, and files. It helps automate repetitive data cleaning tasks. - What is Power Pivot?
Power Pivot is an advanced data modeling tool used to create relationships between tables, perform complex calculations, and analyze large datasets efficiently using DAX. - What is DAX?
DAX (Data Analysis Expressions) is a formula language used in Power Pivot and Power BI to create calculated columns and measures. - What is the difference between Power Query and Power Pivot?
Power Query is used for data extraction and transformation, while Power Pivot is used for data modeling and analysis. - What is a Pivot Table cache?
It is a hidden memory storage that holds a copy of the data used in a Pivot Table to improve performance. - What is the use of GETPIVOTDATA?
It extracts specific data from a Pivot Table dynamically. - What is dynamic named range?
A range that automatically updates when new data is added using formulas like OFFSET or INDEX. - Explain OFFSET function.
OFFSET returns a reference to a range that is a specified number of rows and columns from a starting point. - Explain INDIRECT function.
INDIRECT returns the reference specified by a text string, allowing dynamic cell references. - What is array formula?
An array formula performs multiple calculations on one or more items in an array. - What are dynamic arrays?
Formulas that automatically spill results into multiple cells (e.g., FILTER, SORT). - What is FILTER function?
Returns filtered data based on conditions. - What is SORT function?
Sorts a range dynamically. - What is UNIQUE function?
Returns unique values from a dataset. - What is SEQUENCE function?
Generates a sequence of numbers automatically. - What is LET function?
Allows defining variables within formulas to improve readability and performance. - What is LAMBDA function?
Creates custom reusable functions without VBA. - What is spill error?
Occurs when dynamic array results cannot expand into required cells. - What is structured reference?
References table data using column names. - What is advanced conditional formatting?
Using formulas to apply complex formatting rules. - Explain INDEX + MATCH vs XLOOKUP.
INDEX+MATCH is flexible, while XLOOKUP is simpler and more powerful with built-in error handling. - What is 3D reference?
Reference across multiple sheets. - What is circular reference?
When a formula refers to itself, causing an error. - What is iterative calculation?
Allows circular references to calculate repeatedly until a condition is met. - What is scenario manager?
Tool to analyze different outcomes. - What is Goal Seek?
Finds input value to achieve desired result. - What is Solver?
Advanced optimization tool to find best solution. - What is data model?
A collection of tables with relationships. - What is relationship in data model?
Connection between tables using common fields. - What is star schema?
Data model with fact and dimension tables. - What is KPI in Excel?
Key performance indicator to measure performance. - What is dashboard?
Visual representation of key data insights. - What are slicers?
Interactive filters for Pivot Tables. - What is timeline slicer?
Date-based filtering tool. - What is drill-through?
Navigate from summary to detailed data. - What is Power BI integration?
Using Excel data in Power BI. - What is VBA?
Visual Basic for Applications used for automation. - What is macro security?
Controls macro execution permissions. - What is module in VBA?
Container for storing VBA code. - What is event in VBA?
Trigger for code execution. - What is user form?
Custom interface for input. - What is debugging?
Finding and fixing code errors. - What is error handling in VBA?
Managing runtime errors using code. - What is automation?
Performing repetitive tasks automatically. - What is workbook event?
Code triggered by workbook actions. - What is worksheet event?
Code triggered by sheet changes. - What is data import from SQL?
Fetching data from databases. - What is ODBC connection?
Standard database connectivity method. - What is ETL process?
Extract, Transform, Load data workflow. - What is data cleansing?
Removing errors from data. - What is text parsing?
Breaking text into parts. - What is advanced filtering?
Complex filtering with criteria range. - What is pivot calculated field?
Custom calculation in pivot table. - What is measure in Power Pivot?
Calculation using DAX. - Difference between calculated column and measure?
Column is row-based, measure is aggregate. - What is data refresh?
Updating imported data. - What is connection query?
Link to external data source. - What is workbook size optimization?
Reducing file size. - How to improve Excel performance?
Use efficient formulas, avoid volatile functions. - What are volatile functions?
Functions that recalculate frequently (e.g., NOW, RAND). - What is multi-threading in Excel?
Parallel calculation for faster processing. - What is Excel table vs range?
Tables support structured references. - What is cube function?
Retrieve data from OLAP cubes. - What is OLAP?
Online Analytical Processing. - What is Power Map?
3D data visualization tool. - What is geospatial analysis?
Location-based data analysis. - What is forecast sheet?
Predicts future trends. - What is regression analysis?
Statistical relationship analysis. - What is correlation?
Measure of relationship between variables. - What is histogram?
Distribution chart. - What is box plot?
Shows data distribution. - What is sparklines advanced usage?
Mini charts for trends. - What is chart automation?
Dynamic charts using formulas. - What is named formula?
Custom formula using names. - What is workbook linking issues?
Broken references between files. - What is auditing tools?
Trace precedents/dependents. - What is watch window?
Monitor important cells. - What is evaluate formula?
Step-by-step formula breakdown. - What is data protection advanced?
Lock formulas and restrict editing. - What is digital signature?
Authenticates workbook. - What is co-authoring advanced?
Real-time collaboration. - What is version control?
Track file changes. - What is SharePoint integration?
Team collaboration platform. - What is Excel API?
Programming interface for automation. - What is Office Scripts?
Automation in Excel online. - What is difference between VBA and Office Scripts?
VBA is desktop-based, Office Scripts are web-based. - What is dynamic dashboard?
Interactive dashboard with filters. - What is data storytelling?
Presenting insights visually. - What is best practice for dashboards?
Use clean layout and KPIs. - What is Excel limitation?
Row limit, performance issues with large data. - What is Big Data handling in Excel?
Using Power Pivot and external tools. - What is Excel vs Power BI?
Excel is flexible; Power BI is for large-scale BI. - What is automation workflow?
End-to-end automated data process. - What is real-time data in Excel?
Live data updates. - What is API integration?
Fetching data from web services. - What is web scraping in Excel?
Extracting data from websites. - What is advanced Excel use cases?
Finance, HR analytics, dashboards.
📢 Join Our WhatsApp Channel
💼 Get Daily IT Job Updates, Interview Preparation Tips & Instant Alerts directly on WhatsApp.
👉 Join WhatsApp Now📢 Join Our Telegram Channel
💼 Get Daily IT Job Updates, Interview Tips & Exclusive Alerts directly on Telegram!
👉 Join Telegram