100 Excel

Interview Questions
And Answers

APOORVA IYER
 Advanced Formulas And Functions

1. Explain the difference between VLOOKUP, HLOOKUP, and XLOOKUP.

 VLOOKUP (Vertical Lookup):
o Searches a value in the first column of a table and returns a value from a specified
column to the right.
o Cannot look to the left.
o Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
o Example: =VLOOKUP("ProductA", A2:D100, 3, FALSE) returns the value in the
3rd column of the matching row.
 HLOOKUP (Horizontal Lookup):
o Works like VLOOKUP but searches horizontally in the first row and returns data
from a specified row below it.
o Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
o Example: =HLOOKUP("Q1", A1:D5, 3, FALSE) returns value from the 3rd row in
the column where "Q1" is found in the first row.
 XLOOKUP:
o A modern replacement for both VLOOKUP and HLOOKUP.
o Can search both vertically and horizontally.
o Can return values to the left or right, and has built-in error handling.
o Syntax: =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found],
[match_mode], [search_mode])
o Example: =XLOOKUP("ProductA", A2:A100, C2:C100, "Not Found")
 Key Differences:
o Direction: VLOOKUP and HLOOKUP are one-directional; XLOOKUP is
flexible.
o Error Handling: XLOOKUP allows custom messages for not found values.
o Performance: XLOOKUP is more dynamic and efficient, especially in large
datasets.

linkedin.com/in/apoorvaiyerkcl | 1 | P a g e
2. How do INDEX and MATCH work together?
 INDEX returns the value of a cell at a specific row and column number in a range.
o Syntax: =INDEX(array, row_num, [column_num])
o Example: =INDEX(B2:B10, 3) returns the third value from range B2:B10.
 MATCH returns the position of a value in a range.
o Syntax: =MATCH(lookup_value, lookup_array, [match_type])
o Example: =MATCH("ProductA", A2:A10, 0) returns the position of "ProductA".
 Combined Use Case (INDEX + MATCH):
o This combination replaces VLOOKUP for more flexibility.
o Example:
o =INDEX(C2:C10, MATCH("ProductA", A2:A10, 0))
 This searches for "ProductA" in A2:A10, finds its position, and then fetches
the corresponding value from C2:C10.
 Advantages Over VLOOKUP:
o Works when lookup value is not in the first column.
o Better for large datasets with many columns.
o More resilient to column insertions/deletions.

3. What is the LET function and how does it improve formula performance?
 LET allows you to assign names to calculation results inside a formula. These names
can be reused, improving readability and performance.
 Syntax:
 =LET(name1, value1, name2, value2, ..., calculation)
 Example:
 =LET(x, A1+10, y, A2+20, x*y)
o Here, x = A1 + 10, y = A2 + 20, and the result is x * y.
 Why It’s Useful:
o Avoids repeating the same calculation.
o Makes formulas cleaner and easier to understand.

linkedin.com/in/apoorvaiyerkcl | 2 | P a g e
 o Improves performance in large workbooks by avoiding redundant calculations.

4. How do dynamic arrays work in Excel?

 Dynamic arrays automatically spill multiple results into adjacent cells.
 Examples of dynamic array functions:
o SEQUENCE(), SORT(), FILTER(), UNIQUE(), RANDARRAY()
 Spill Behavior:
o A formula returns a range of results and automatically fills the adjacent cells.
o Example: =SEQUENCE(5) fills 5 rows with numbers 1 to 5.
o If something blocks the spill range (like a filled cell), Excel shows a #SPILL! error.
 Benefits:
o Simplifies tasks that earlier required helper columns or array formulas.
o Enables live updating of results when source data changes.

5. Explain the FILTER function with an example.

 The FILTER function returns a dynamic array of values that meet a condition.
 Syntax:
 =FILTER(array, include, [if_empty])
 Example:
 =FILTER(A2:B100, B2:B100 > 5000, "No Match")
o This filters rows in range A2:B100 where values in column B are greater than
5000.
 Advantages:
o Dynamic and auto-expanding.
o Much more powerful and flexible than manual filtering or IF functions.
 Use Cases:
o Filter customers with high sales.
o Filter data based on date range, region, product type, etc.

linkedin.com/in/apoorvaiyerkcl | 3 | P a g e
6. How do you use SEQUENCE and RANDARRAY functions?
 SEQUENCE Function:
o Generates a list of sequential numbers in an array format.
o Syntax: =SEQUENCE(rows, [columns], [start], [step])
o Example: =SEQUENCE(5,1,1,1) returns numbers from 1 to 5 in a single column.
o Use Cases:
 Automatically generate serial numbers.
 Create row/column indices without manual entry.
 RANDARRAY Function:
o Returns an array of random numbers between 0 and 1 (or specified min and max).
o Syntax: =RANDARRAY([rows], [columns], [min], [max], [whole_number])
o Example 1: =RANDARRAY(5,1) returns 5 random decimals between 0 and 1.
o Example 2: =RANDARRAY(5,1,1,100,TRUE) returns 5 random whole numbers
between 1 and 100.
o Use Cases:
 Simulate datasets for testing.
 Generate randomized samples or scores.
 Both functions support dynamic arrays, meaning results will spill into adjacent cells
automatically.

7. What is the LAMBDA function and how can it be used?

 LAMBDA allows you to create custom functions without VBA.
 It lets you define internal variables and return calculated results based on inputs.
 Syntax:
 =LAMBDA(parameter1, parameter2, ..., calculation)
 Example:
 =LAMBDA(x, x^2)(5)
o Returns 25. This is a function that squares the number passed to it.
 Reusable LAMBDA (via Name Manager):

linkedin.com/in/apoorvaiyerkcl | 4 | P a g e
 o You can save a LAMBDA function in Name Manager and reuse it like any Excel
function.
o For example: Create a custom discount formula or tax calculator.
 Benefits:
o No need for VBA for simple functions.
o Makes workbook logic modular and maintainable.
o Enhances performance over using repeated formulas.

8. How do you handle errors using IFERROR and ISERROR?

 IFERROR:
o Catches errors and returns an alternate result.
o Syntax: =IFERROR(value, value_if_error)
o Example: =IFERROR(A1/B1, "Divide by zero") returns the result of A1/B1 or
"Divide by zero" if there’s an error.
 ISERROR:
o Returns TRUE if the value is any error (e.g., #DIV/0!, #N/A, #REF!).
o Syntax: =ISERROR(value)
o Can be used inside an IF function: =IF(ISERROR(A1/B1), "Error", A1/B1)
 Best Practices:
o Use IFERROR to hide or manage expected errors.
o Use ISERROR when you want to perform conditional logic based on the presence
of an error.

9. Explain the use of SUMIFS and COUNTIFS with multiple criteria.

 SUMIFS and COUNTIFS allow summing or counting based on multiple conditions.
 SUMIFS Syntax:
 =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
o Example: =SUMIFS(C2:C100, A2:A100, "North", B2:B100, "Electronics")
 Adds values in column C where region is North and category is Electronics.

linkedin.com/in/apoorvaiyerkcl | 5 | P a g e
  COUNTIFS Syntax:
 =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)
o Example: =COUNTIFS(A2:A100, "North", B2:B100, ">5000")
 Counts rows where region is North and sales > 5000.
 Use Cases:
o Sales analysis by region and product.
o Tracking headcount by department and gender.
o Monitoring quality metrics or attendance with conditions.

10. How do you use TEXTJOIN and CONCAT functions?

 Both functions combine text from multiple cells or strings.
 TEXTJOIN:
o Allows adding a delimiter and ignoring blank cells.
o Syntax: =TEXTJOIN(delimiter, ignore_empty, text1, text2, ...)
o Example: =TEXTJOIN(", ", TRUE, A1:A5) joins values with comma, ignoring
blanks.
 CONCAT:
o Simplified replacement for CONCATENATE, combines text but doesn’t offer
delimiters or ignore blanks.
o Syntax: =CONCAT(text1, text2, ...)
o Example: =CONCAT(A1, B1, C1) joins the values from three cells.
 Use Cases:
o Merge full names from first and last name columns.
o Create address lines from multiple fields.
o Combine product codes, tags, or labels for display or export.

linkedin.com/in/apoorvaiyerkcl | 6 | P a g e
 Data Analysis And Manipulation

11. How do you create and customize Pivot Tables?

 Pivot Tables are powerful tools in Excel for summarizing, analyzing, exploring, and
presenting large data sets in an interactive and dynamic way.
 Steps to Create a Pivot Table:
1. Select your data range (make sure it has headers).
2. Go to Insert → PivotTable.
3. Choose where you want the PivotTable to appear (new or existing worksheet).
4. Drag fields into Rows, Columns, Values, and Filters as needed.
 Customization Options:
o Use the Value Field Settings to change aggregation (Sum, Count, Average, etc.).
o Apply filters or slicers for user-friendly interaction.
o Use Group to combine items (e.g., group dates by month or years).
o Format numbers with number formatting to improve readability.
o Right-click and use Show Values As for options like % of Total, Running Total,
etc.
 Use Cases:
o Summarizing monthly sales by product and region.
o Analyzing customer transactions by category.
o Creating management-ready performance reports.

12. What are slicers and how do they enhance Pivot Table usability?
 Slicers are visual filtering tools that make PivotTables more interactive.
 How to Add a Slicer:
o Click inside the Pivot Table.
o Go to PivotTable Analyze → Insert Slicer.
o Choose the fields for which you want to filter visually (e.g., Region, Category).
 Benefits of Slicers:

linkedin.com/in/apoorvaiyerkcl | 7 | P a g e
 o Display as clickable buttons, easier than traditional filter dropdowns.
o Allow multiple selections at once.
o Make reports more user-friendly, especially for business presentations.
o Can be formatted with colors, sizes, and styles to match dashboards.
 Use Case Example:
o A dashboard where users can filter sales by region or month with one click.

13. How do you use Power Query to clean and transform data?
 Power Query (Get & Transform Data) is a tool for extracting, cleaning, and reshaping
data before it’s loaded into Excel.
 How to Access:
o Go to Data → Get Data → Choose source (Excel, CSV, Web, SQL Server, etc.).
 Key Data Transformation Steps:
o Remove duplicates, filter rows, split columns by delimiter or position.
o Replace values, change data types, trim text, rename columns.
o Merge or append queries from different sources.
o Apply pivot/unpivot operations for better structure.
 Advantages:
o Automates the data cleaning process.
o Steps are recorded as applied steps and can be edited later.
o Eliminates the need for manual cleaning each time.
 Use Case:
o Cleaning customer transaction data, transforming sales data formats, joining
monthly reports.

14. Explain how to use Power Pivot for data modeling.

 Power Pivot allows you to create data models with multiple tables linked through
relationships — similar to a relational database — and use advanced DAX formulas.
 Steps to Use Power Pivot:

linkedin.com/in/apoorvaiyerkcl | 8 | P a g e
 1. Enable Power Pivot from Add-ins (if not already active).
2. Load tables into the Data Model using Power Query or directly from Excel.
3. Go to Manage in Power Pivot to build relationships between tables using keys.
4. Use DAX formulas to create calculated columns and measures.
5. Use the model in PivotTables by choosing data from the model.
 Benefits:
o Handles millions of rows efficiently.
o Advanced aggregations and custom KPIs using DAX.
o Supports relationships between tables (one-to-many, many-to-one).
 Use Case:
o Creating a sales report by linking product, region, and sales transaction tables
without duplicating data.

15. How do you remove duplicates efficiently?

 Using the Ribbon:
o Select your data range.
o Go to Data → Remove Duplicates.
o Choose columns to check for duplicates.
o Excel removes rows that have the same values in selected columns.
 Using Power Query:
o Load data into Power Query.
o Select columns and click Remove Duplicates from the ribbon.
o Apply and load back to Excel.
 Using Formulas (Advanced):
o Use =UNIQUE() in dynamic arrays to list distinct values (Excel 365+).
o Alternatively, use helper columns with COUNTIFS or IF(COUNTIF(...)) for older
versions.
 Use Cases:
o Cleaning raw data before analysis.

linkedin.com/in/apoorvaiyerkcl | 9 | P a g e
 o Identifying unique customer entries or transaction records.
o Ensuring accuracy in reports by avoiding repeated values.

16. What is data validation and how do you create dependent drop-down lists?
 Data Validation restricts the type of data or values users can enter into a cell, helping
maintain consistency and accuracy.
 Steps to Create a Basic Drop-Down List:
1. Select the target cells.
2. Go to Data → Data Validation → Settings tab.
3. Choose List from the “Allow” drop-down.
4. Enter your list values separated by commas or refer to a cell range.
 Creating Dependent Drop-Down Lists (Two-Level Example):
o Step 1: Create separate named ranges for each category.
o Step 2: In the second drop-down’s Data Validation formula, use:
o =INDIRECT(A2)
Assuming A2 holds the category (e.g., Region), and corresponding named ranges like “North”,
“South”, etc. exist.
 Use Cases:
o Ensuring only valid departments, product categories, or regions are selected.
o Creating dynamic forms and models for end users.
o Controlling user input to prevent downstream errors.

17. How do you use conditional formatting with formulas?

 Conditional Formatting with Formulas applies formatting based on custom logic
defined through formulas.
 Steps:
1. Select the target range.
2. Go to Home → Conditional Formatting → New Rule.
3. Choose “Use a formula to determine which cells to format”.

linkedin.com/in/apoorvaiyerkcl | 10 | P a g e
 4. Enter a logical formula (returns TRUE or FALSE).
5. Set the desired format (color, font, border, etc.).
 Examples:
o Highlight sales above 10,000:
o =B2>10000
o Highlight duplicate values:
o =COUNTIF(A:A, A2)>1
o Highlight dates within last 7 days:
o =A2>=TODAY()-7
 Use Cases:
o Quickly visualizing trends, exceptions, or errors.
o Highlighting outliers in financial reports or KPIs.
o Monitoring overdue tasks, thresholds, or performance.

18. How do you split and merge cells or text using Text to Columns and Flash Fill?
 Text to Columns:
o Splits data in one column into multiple columns based on delimiters or fixed width.
o Go to Data → Text to Columns.
o Choose Delimited (e.g., comma, space) or Fixed Width.
o Useful for splitting full names, dates, or codes.
 Flash Fill:
o Automatically fills in values based on a pattern you start typing.
o Available under Data → Flash Fill, or triggered by pressing Ctrl + E.
 Examples:
o Extracting first names: Type “John” next to “John Smith” and press Ctrl + E.
o Extracting domain from emails: From john@example.com, type “example.com”
and use Flash Fill.
 Merging Cells:
o Use Home → Merge & Center to combine multiple cells.

linkedin.com/in/apoorvaiyerkcl | 11 | P a g e
 o Useful for headers and formatting (not ideal for data operations).
 Use Cases:
o Splitting full names, addresses, codes.
o Combining product categories or labels.
o Cleaning imported data formats for analysis.

19. Explain how to consolidate data from multiple sheets.

 Consolidate is used to combine data from different sheets into a summary.
 Steps:
1. Go to Data → Consolidate.
2. Choose the aggregation function (Sum, Average, etc.).
3. Add references from multiple sheets/ranges.
4. Check “Top row” or “Left column” if labels exist.
 Best Practices:
o Ensure consistent structure in all source sheets (same columns and headers).
o Use named ranges for clarity and maintenance.
o Use Power Query for dynamic consolidation of data from many sheets/files.
 Use Cases:
o Consolidating monthly sales reports.
o Combining department-wise budgets or targets.
o Merging team data from different project workbooks.

20. How do you use advanced filters for complex data extraction?
 Advanced Filter enables filtering data with multiple complex criteria, beyond what
standard filters allow.
 Steps:
1. Prepare a criteria range with the same headers as your dataset.
2. Go to Data → Advanced under the Sort & Filter group.
3. Choose to Filter the list in-place or Copy to another location.

linkedin.com/in/apoorvaiyerkcl | 12 | P a g e
 4. Specify the data range and criteria range.
 Example:
o Filter for:
 Sales > 10000
 Region = “North”
o Use two rows in criteria:
o Region Sales
o North >10000
 Use Cases:
o Extracting custom datasets for reporting or further analysis.
o Creating summary tables based on multiple conditions.
o Filtering without using formulas or helper columns.

Automation And Macros

21. What is a macro and how do you record one?

 A macro is a recorded sequence of actions in Excel that can be run repeatedly to automate
repetitive tasks like formatting, calculations, or report generation.
 How to Record a Macro:
1. Go to View → Macros → Record Macro.
2. Give your macro a name (no spaces), assign a shortcut key (optional), and choose
where to store it.
3. Perform the steps you want to automate.
4. Click Stop Recording when done.
 Where It’s Stored:
o Stored in a module inside the Visual Basic for Applications (VBA) editor.
o Can be saved in This Workbook or in a Personal Macro Workbook for access
across all files.

linkedin.com/in/apoorvaiyerkcl | 13 | P a g e
  Use Cases:
o Repetitive formatting of reports.
o Creating monthly data exports.
o Generating charts from updated data.

22. How do you write a simple VBA script to automate a task?

 You can write VBA scripts by opening the VBA Editor (Alt + F11).
 Basic VBA Example – Clear a Range:
 Sub ClearData()
 Range("A2:D100").ClearContents
 End Sub
 Steps:
1. Press Alt + F11 to open the VBA Editor.
2. Insert a new Module (Right-click → Insert → Module).
3. Paste the code and close the editor.
4. Run the macro from the Macros list (Alt + F8).
 Use Cases:
o Automating data entry or cleaning.
o Generating repetitive reports.
o Adding time stamps, alerts, or formatting through buttons.

23. What are the security considerations when using macros?

 Macros can pose security risks because VBA can perform file operations and execute
malicious code.
 Key Considerations:
o Enable macros only from trusted sources.
o Excel disables macros by default in downloaded files.
o Set macro settings via File → Options → Trust Center → Trust Center Settings
→ Macro Settings.

linkedin.com/in/apoorvaiyerkcl | 14 | P a g e
  Best Practices:
o Sign your macros with a digital certificate.
o Use the Personal Macro Workbook only for safe, internal use.
o Keep macros in read-only or protected sheets if distributing to others.
 Warnings to Look Out For:
o Files prompting you to enable macros unexpectedly.
o Suspicious macros that open websites, delete data, or create hidden objects.

24. How do you debug a VBA macro?

 Debugging in VBA allows you to identify and fix issues in your macro code.
 Techniques:
o Use F8 to step through code one line at a time.
o Use breakpoints (click in the margin or press F9) to pause code execution.
o Add Debug.Print statements to output values to the Immediate Window.
o Use the Watch Window to track variable values during runtime.
o Use MsgBox to display variable values in pop-ups.
 Common Errors:
o Syntax errors (e.g., missing parentheses).
o Runtime errors (e.g., referencing a non-existent sheet).
o Logic errors (e.g., loop not executing as intended).

25. Explain how to create user-defined functions (UDFs) in VBA.

 A User-Defined Function (UDF) allows you to create a custom Excel function using
VBA.
 Steps to Create a UDF:
1. Press Alt + F11 to open the VBA Editor.
2. Insert a Module.
3. Write the function:
4. Function AddTwoNumbers(x As Double, y As Double) As Double

linkedin.com/in/apoorvaiyerkcl | 15 | P a g e
 5. AddTwoNumbers = x + y
6. End Function
7. Save and return to Excel.
8. Use it like a regular function: =AddTwoNumbers(5,10)
 Benefits:
o Customize calculations Excel doesn’t offer natively.
o Simplify complex logic into one reusable function.
 Use Cases:
o Tax or commission calculators.
o Financial metrics or statistical analysis.
o Cleaning or transforming text in unique ways.

Absolutely — understood. From now on, I’ll continue answering each full section without pausing
for your approval in between. I’ll maintain the exact format you prefer and take the necessary time
to ensure quality and completeness for each block of 5 questions.
Continuing with the remaining part of the current section:

26. How can you automate report generation using Excel?

 Automating report generation in Excel reduces manual effort and ensures consistency
across recurring reports.
 Techniques to Use:
o Macros (VBA): Automate steps like pulling data, formatting, inserting charts, and
exporting to PDF.
o Power Query: Automatically fetch and transform data from multiple sources.
o Pivot Tables + Slicers: Create dynamic templates that update when data is
refreshed.
o Formulas + Named Ranges: Use dynamic ranges and formulas that update
automatically.
o Scheduled Power Automate (via Microsoft 365): Can trigger Excel workflows
like report emails.
 Example VBA Workflow:

linkedin.com/in/apoorvaiyerkcl | 16 | P a g e
 o Refresh queries → Update pivot tables → Export selected sheets to PDF → Email
report.
 Use Case:
o Weekly or monthly dashboards, sales summaries, financial statements, or KPI
trackers.

27. How do you assign macros to buttons or shapes?

 Assigning macros to buttons makes them easily executable without going through the
Developer tab.
 Steps:
1. Go to Insert → Shapes or Form Controls → Choose a button.
2. Draw it on the sheet.
3. Right-click → Assign Macro.
4. Choose the macro you want to link and click OK.
 Optional Enhancements:
o Rename the shape (e.g., “Run Report”).
o Format it with colors, borders, and effects for better UI.
 Use Cases:
o Create “Refresh Data”, “Clear Inputs”, or “Generate Report” buttons.
o Improve accessibility for business users unfamiliar with VBA or Developer tab.

28. What is the difference between Sub and Function in VBA?

 Both Sub and Function are used to write code in VBA, but they serve different purposes.
 Sub Procedure:
o Performs a task (e.g., clear cells, apply formatting).
o Does not return a value.
o Called directly or via button/macro list.
o Example:
o Sub ClearRange()

linkedin.com/in/apoorvaiyerkcl | 17 | P a g e
 o Range("A1:B10").ClearContents
o End Sub
 Function Procedure:
o Returns a value and can be used in worksheets like native Excel formulas.
o Cannot modify the workbook unless called from a Sub.
o Example:
o Function Square(x As Double) As Double
o Square = x * x
o End Function
 Use Case Distinction:
o Use Sub to perform actions.
o Use Function to calculate and return values.

29. How do you handle errors in VBA code?

 Handling errors in VBA is essential for creating robust, crash-free macros.
 Error Handling Techniques:
o On Error Resume Next: Ignores error and moves to next line (use with caution).
o On Error GoTo Label: Directs control to a label in case of an error.
o Sub Example()
o On Error GoTo ErrHandler
o ' code
o Exit Sub
o ErrHandler:
o MsgBox "An error occurred."
o End Sub
 Best Practices:
o Use specific error messages to help debug.
o Avoid suppressing all errors — handle them gracefully.

linkedin.com/in/apoorvaiyerkcl | 18 | P a g e
 o Log errors using MsgBox, Debug.Print, or writing to a log file.
 Use Cases:
o Skipping missing sheets.
o Preventing crashes during file operations.
o Displaying user-friendly messages.

30. How do you use loops and conditional statements in VBA?

 Loops and conditionals allow you to repeat tasks and branch logic based on conditions.
 Conditional Statements:
o If...Then...Else: Execute based on conditions.
o If A > 100 Then MsgBox "High"
 Loops:
o For Loop:
o For i = 1 To 10
o Cells(i, 1) = i
o Next i
o Do While Loop:
o Do While Cells(i,1) <> ""
o i=i+1
o Loop
o For Each Loop:
o For Each cell In Range("A1:A10")
o cell.Value = cell.Value * 2
o Next cell
 Use Cases:
o Loop through rows to apply logic.
o Conditional formatting via code.
o Repeating actions across multiple sheets or files.

linkedin.com/in/apoorvaiyerkcl | 19 | P a g e
 Scenario Based And Business Applications

31. How have you used Excel to optimize business processes?

 Excel can significantly streamline business operations by reducing manual work and
standardizing data processing.
 Example Use Cases:
o Automated Sales Tracker: Used Excel with Power Query and formulas to
consolidate daily sales, auto-update reports, and email summaries.
o Inventory Alerts: Set up conditional formatting and formula-based flags for low
stock levels.
o Client Onboarding Tracker: Used Excel forms with data validation to capture
and track client progress.
 Benefits Delivered:
o Saved 10+ hours/week in report generation.
o Improved accuracy and real-time visibility.
o Enabled non-technical staff to interact with dynamic reports.

32. Describe a complex Excel project where you analyzed large datasets.
 Project Example: Customer Churn Analysis
 Data: 100,000+ rows of telecom customer data across usage, billing, complaints, and
demographics.
 Approach:
o Cleaned and merged data using Power Query.
o Created DAX measures and used Power Pivot for aggregations.
o Built interactive dashboards showing churn patterns using slicers and PivotCharts.
o Applied formulas like COUNTIFS, AVERAGEIFS, and IFERROR to detect
trends.
 Outcome:
o Identified that 60% of churn cases involved late payment patterns.
o Enabled the business to implement targeted retention strategies.

linkedin.com/in/apoorvaiyerkcl | 20 | P a g e
33. How do you create interactive dashboards in Excel?
 Interactive dashboards help visualize KPIs and trends dynamically.
 Steps:
1. Use Pivot Tables for data summarization.
2. Insert PivotCharts or standard charts (line, bar, pie).
3. Add Slicers and Timelines for interactivity.
4. Use Named Ranges and Dynamic Formulas (e.g., OFFSET, INDEX, MATCH)
for responsive charts.
5. Link controls to charts and summaries using formulas or VBA.
 Best Practices:
o Use consistent color themes and clear labeling.
o Include KPIs, trends, and filterable segments (e.g., region, product, month).
 Tools:
o Combo charts, progress bars (using conditional formatting), interactive buttons.

34. How do you perform what-if analysis using Goal Seek and Scenario Manager?
 Goal Seek:
o Helps you find the input value needed to achieve a specific goal.
o Example: What price is needed to achieve Rs. 1,00,000 in revenue?
o Go to Data → What-If Analysis → Goal Seek → Set the target cell and desired
value.
 Scenario Manager:
o Lets you define multiple input sets and compare outcomes.
o Use for financial forecasting, budgeting, or strategic planning.
o Go to Data → What-If Analysis → Scenario Manager → Add scenarios and
inputs → Show results.
 Use Cases:
o Sales target planning.

linkedin.com/in/apoorvaiyerkcl | 21 | P a g e
 o Expense projection.
o Investment ROI modeling.

35. How do you forecast sales or financial data in Excel?

 Tools to Use:
o FORECAST.LINEAR function for simple linear projections.
o TREND, GROWTH, and LINEST for more advanced regression-based
forecasting.
o Data → Forecast Sheet for creating interactive line charts with confidence
intervals (Excel 2016+).
 Example:
 =FORECAST.LINEAR(13, B2:B12, A2:A12)
o Predicts the 13th month’s value based on months 1–12.
 Best Practices:
o Clean and structure your historical data.
o Account for seasonality, growth trends, and outliers.
o Visualize forecasts with charts and add upper/lower bounds if possible.
 Use Cases:
o Monthly revenue forecasting.
o Headcount planning.
o Budget estimates for business proposals.

36. How do you track project timelines using Excel?

 Excel is commonly used to build Gantt chart-style project trackers and task monitoring
tools, especially in smaller teams or when MS Project is unavailable.
 Steps to Track Timelines:
1. Create a table with columns like: Task Name, Start Date, End Date, Duration,
Assigned To, Status.
2. Use formulas to calculate duration:
3. =End Date - Start Date

linkedin.com/in/apoorvaiyerkcl | 22 | P a g e
 4. Add conditional formatting to highlight overdue tasks or critical activities.
5. Use bar charts or stacked bar charts to create a Gantt chart visualization (Start
Date as base, Duration as bar length).
6. Use drop-downs (Data Validation) for status updates like “In Progress,”
“Completed,” or “Pending.”
 Use Cases:
o Product development tracking
o Marketing campaign planning
o Internal team deadline management

37. How do you use Excel for inventory management?

 Excel can serve as a basic inventory management system, especially for small businesses
or departments without ERP tools.
 Core Components:
o Item Master Table: Item ID, Item Name, Category, Reorder Level, Supplier.
o Stock In/Out Sheet: Date, Item ID, Quantity In, Quantity Out.
o Use formulas like:
o =SUMIF(StockInOut!B:B, A2, StockInOut!C:C) - SUMIF(StockInOut!B:B, A2,
StockInOut!D:D)
to calculate current stock based on transactions.
 Optional Features:
o Conditional formatting to flag low stock.
o Dashboards showing top-selling items, reorder alerts.
o Pivot tables to analyze monthly inflow/outflow trends.
 Use Case:
o Managing office supplies, product stock, raw materials, or consumables.

38. How do you ensure data accuracy and integrity in your Excel models?

linkedin.com/in/apoorvaiyerkcl | 23 | P a g e
  Ensuring accuracy is critical, especially when Excel outputs are used for decision-making
or reporting to stakeholders.
 Techniques:
o Use Data Validation to control user input.
o Apply Named Ranges to reduce reference errors.
o Use IFERROR, ISNUMBER, and logical checks to handle or flag errors.
o Lock formula cells and protect the sheet to avoid unintentional changes.
o Create an Audit Sheet summarizing assumptions and checks.
 Best Practices:
o Avoid hardcoding numbers inside formulas.
o Include a version history or change log.
o Always test edge cases (e.g., zero values, missing inputs).
 Use Case:
o Financial models, sales forecasts, pricing tools, or MIS reports.

39. Explain how you would present complex data to non-technical stakeholders.
 Non-technical stakeholders prefer clarity and actionable insights over detailed raw data or
formulas.
 Approach:
o Create a dashboard or summary sheet with visual charts (bar, line, pie) and KPIs
(e.g., growth rate, totals, targets).
o Use Slicers and drop-downs to allow simple interactivity.
o Highlight key metrics using conditional formatting (e.g., red-yellow-green status).
o Include short text explanations and insights (e.g., "Sales dipped 12% in Q3 due to
low demand in South region").
 Best Practices:
o Use plain language — avoid jargon like “dynamic arrays” or “data models.”
o Focus on trends, anomalies, and business outcomes.
o Offer downloadable PDFs or snapshots for easy sharing.
 Use Case:

linkedin.com/in/apoorvaiyerkcl | 24 | P a g e
 o Presenting a sales dashboard to a regional manager.
o Reporting campaign ROI to a marketing head.

40. How do you handle sensitive data in Excel securely?

 Excel is not a full-fledged data security tool, but several features can help protect sensitive
data.
 Security Measures:
o Password-protect workbooks and worksheets (File → Info → Protect Workbook).
o Use cell locking and sheet protection to restrict editing.
o Use File → Options → Trust Center settings to manage macro behavior and
external links.
o Store files in secure, access-controlled locations (e.g., OneDrive, SharePoint,
encrypted drives).
 Additional Tips:
o Avoid emailing files with sensitive information. Use shared links with restricted
access.
o Mask or anonymize sensitive fields (e.g., employee ID instead of name).
o Keep a log of who accesses or edits the file if shared in collaborative settings.
 Use Case:
o HR data, salary reports, customer PII, and financial statements.

linkedin.com/in/apoorvaiyerkcl | 25 | P a g e
 Data Visualization And Reporting

41. How do you create dynamic charts that update with data changes?
Dynamic charts automatically adjust to new or changing data, reducing the need for manual
updates. They are crucial when building dashboards or monthly reports.
Best methods to create dynamic charts:
• Use Excel Tables:
Convert your dataset to a table using Ctrl + T. Any chart built on a table will auto-expand as rows
are added or removed.
• Named Ranges (Dynamic):
Use formulas like OFFSET or INDEX to define ranges that grow as data changes:
=OFFSET(Sheet1!$A$1, 0, 0, COUNTA(Sheet1!$A:$A), 1)
Then, create a named range from this formula and use it as the source for the chart.
• Pivot Charts:
When used with Pivot Tables built from Excel Tables, Pivot Charts update dynamically as data
changes or filters are applied.
Dynamic charts are essential for automation and reduce maintenance in regular reporting tasks.

42. What are Sparklines and how do you use them?

Sparklines are miniature charts embedded in a single cell that show trends over time. They are
ideal for visualizing patterns across rows—like month-on-month sales or performance scores.
Types of Sparklines:
• Line
• Column
• Win/Loss
Steps to Insert Sparklines:
1. Select the cell where you want the sparkline.
2. Go to Insert > Sparklines.
3. Choose the data range.
4. Click OK.
Features:
• Can highlight highest/lowest points.

linkedin.com/in/apoorvaiyerkcl | 26 | P a g e
• Customizable colors and markers.
• Do not require chart axes or labels—minimalist and compact.
Sparklines are especially useful in dashboards and compact reports.

43. How do you customize chart elements (titles, legends, axes)?

Customizing chart elements improves clarity, usability, and alignment with business requirements.
Steps to Customize:
1. Click on the chart.
2. Use the Chart Elements (+) button or go to Chart Design > Add Chart Element.
Common Customizations:
• Titles: Add a descriptive chart title. Use =cell_reference to link it dynamically.
• Legends: Adjust position (Top, Bottom, Right) or remove if unnecessary.
• Axes: Format axis labels, add gridlines, or change scale (e.g., log scale or reverse axis).
• Data Series: Customize colors, line styles, or add markers.
Custom formatting makes reports more professional and easier to interpret.

44. How do you use conditional formatting to create heat maps?

Heat maps use color gradients to represent the intensity or magnitude of values—ideal for
identifying outliers, trends, or performance levels.
Steps:
1. Select your data range.
2. Go to Home > Conditional Formatting > Color Scales.
3. Choose a preset scale (e.g., Green-Yellow-Red).
Customizations:
• Create 2-color or 3-color rules.
• Define min, midpoint, and max using formulas or values.
• Combine with data bars or icon sets for enhanced insights.
Use Case:
Highlight regions with higher sales or departments with higher expenses at a glance.

45. How do you use custom number formats to enhance the readability of your charts and
reports in Excel?

linkedin.com/in/apoorvaiyerkcl | 27 | P a g e
Custom number formats help display data clearly without changing the actual values.
Examples:
• Thousands: #,##0,"K" → displays 15000 as 15K
• Percentages: 0.00% → shows 0.4567 as 45.67%
• Currency: $#,##0.00
• Hide zeroes: #,##0;-#,##0;;@ → blank cell for zero value
Steps:
1. Select cells > Ctrl + 1 (Format Cells) > Number tab > Custom
2. Enter or select the custom format
Readable numbers make charts cleaner, especially in financial and KPI dashboards.

46. How do you use the Camera tool to create live snapshots of data?
The Camera tool captures a live image of a selected range that updates as the source data changes.
It's useful for dashboards or placing tables in strategic visual areas.
Steps:
1. Enable the Camera tool:
o File > Options > Customize Ribbon > Add Camera tool to Quick Access Toolbar.
2. Select the data range to capture.
3. Click the Camera tool.
4. Click anywhere on the sheet to paste the live snapshot.
Use Case:
Display a summary table from another sheet without duplicating the data. The image updates
when the source is changed.

47. How do you create combo charts (e.g., bar and line chart together)?
Combo charts combine two chart types in one, ideal for comparing values of different scales (e.g.,
Sales vs. Growth %).
Steps:
1. Select data > Insert > Combo Chart.
2. Choose chart types for each series (e.g., Column for Sales, Line for Growth).
3. Optionally, assign one series to a Secondary Axis.

linkedin.com/in/apoorvaiyerkcl | 28 | P a g e
Use Case:
Compare revenue (bar) and profit margin (line) in one visual.
This is a key tool for financial and marketing analysts who compare absolute vs. percentage
metrics.

48. How do you use data labels and data callouts effectively?
Data labels and callouts help convey exact values or commentary directly on the chart, reducing
the need to cross-reference legends.
Steps:
1. Click on the chart > Chart Elements (+) > Check Data Labels.
2. Choose position: Inside, Outside, Center, etc.
3. Use More Options to format (number, font, etc.)
Callouts:
 Use callouts to annotate insights (e.g., peak sales, new product launch).
 Right-click > Add Data Label > Format label text as needed.
Avoid clutter by labeling only key points instead of every data bar.

49. How do you print large Excel sheets with proper scaling and page breaks?
Proper print setup ensures reports are clean, professional, and not cut across pages.
Steps:
1. Go to Page Layout > Page Setup.
2. Set Orientation (Landscape/Portrait) and margins.
3. Use Fit Sheet on One Page or set scaling manually.
4. Use Page Break Preview to manually adjust page breaks (View > Page Break Preview).
Additional Tips:
• Use Repeat Row/Column Headers for multi-page reports.
• Print selection only if required.
• Use headers/footers for file name, page numbers, or date.

linkedin.com/in/apoorvaiyerkcl | 29 | P a g e
50. How do you use the Quick Analysis tool for fast data visualization?
The Quick Analysis tool offers one-click options for charts, formatting, totals, and more—ideal for
quick insights.
Steps:
1. Select your dataset.
2. Click on the Quick Analysis icon (bottom-right corner of selection) or press Ctrl + Q.
3. Choose from tabs:
o Formatting (Data Bars, Color Scales)
o Charts (Recommended visuals)
o Totals (Sum, Avg, Count)
o Tables (Convert to Table)
o Sparklines
Use Case:
Quickly visualize which products have the highest revenue or highlight top performers.
This is an excellent tool for beginners and time-crunched professionals alike.

Latest Excel Features (2024–2025)

51. How does XLOOKUP improve upon VLOOKUP?

 XLOOKUP is a more advanced, flexible replacement for traditional lookup functions like
VLOOKUP, HLOOKUP, and even LOOKUP.
 Key Improvements:
o Bidirectional Lookup: Can search to the left or right of the lookup column, unlike
VLOOKUP which only looks right.
o Exact Match by Default: No need to use FALSE for exact match as in
VLOOKUP.

linkedin.com/in/apoorvaiyerkcl | 30 | P a g e
 o Error Handling: Includes an optional if_not_found argument to handle missing
values gracefully.
o Works with Arrays: Supports both vertical and horizontal lookups, eliminating the
need for separate HLOOKUP.
o Clean Syntax: Easier to understand and maintain.
 Syntax:
 =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode],
[search_mode])
 Example:
 =XLOOKUP("Laptop", A2:A100, C2:C100, "Not Found")
o Looks for "Laptop" in column A and returns the value from column C in the same
row.
 Use Cases:
o Replacing multiple VLOOKUPs with a single, more efficient function.
o Cleaner dashboards and reports with built-in error messages.

52. What are dynamic arrays and how do they change formula writing?
 Dynamic arrays allow formulas to return multiple values that automatically “spill” into
adjacent cells without the need for Ctrl+Shift+Enter.
 Functions Powered by Dynamic Arrays:
o SEQUENCE(), SORT(), SORTBY(), FILTER(), UNIQUE(), RANDARRAY()
 Benefits:
o Eliminates the need for helper columns or complex copy-paste operations.
o Makes calculations more readable, scalable, and interactive.
o Spilled results update automatically when the source data changes.
 Example:
 =UNIQUE(A2:A100)
o Automatically lists all unique values from A2:A100 into the rows below.
 Use Case:
o Quickly extract and sort distinct product names.

linkedin.com/in/apoorvaiyerkcl | 31 | P a g e
 o Filter datasets in real-time with interactive formulas.

53. How do you use the new LET function to simplify complex formulas?
 LET allows you to define named variables inside a formula, improving readability and
performance by calculating values only once.
 Syntax:
 =LET(name1, value1, name2, value2, ..., calculation)
 Example:
 =LET(a, A1+10, b, A2*2, a + b)
 Benefits:
o Avoids repeating calculations within the same formula.
o Makes nested and long formulas easier to understand.
o Slightly improves performance in large workbooks.
 Use Case:
o Creating custom logic for pricing, tax, or scoring calculations.
o Breaking a large formula into smaller reusable variables.

54. Explain the use of the LAMBDA function for reusable formulas.
 LAMBDA lets you create custom functions in Excel without VBA, allowing logic to be
reused across the workbook.
 Syntax:
 =LAMBDA(parameter1, parameter2, ..., calculation)
 Example (inline use):
 =LAMBDA(x, x^2)(5)
o Returns 25.
 To Create a Reusable Named Function:
1. Go to Formulas → Name Manager.
2. Click New, give it a name.
3. Define the function with LAMBDA.

linkedin.com/in/apoorvaiyerkcl | 32 | P a g e
4. Use it in the workbook like any Excel function.
 Use Case:
o Create a custom discount formula, interest calculator, or rating scale.
o Replace redundant logic used across multiple cells.

55. How do you use the new TEXTBEFORE and TEXTAFTER functions?
 These functions make string manipulation easier, especially for splitting text based on
delimiters.
 TEXTBEFORE Syntax:
 =TEXTBEFORE(text, delimiter, [instance_num])
o Example: =TEXTBEFORE("name@example.com", "@") returns "name"
 TEXTAFTER Syntax:
 =TEXTAFTER(text, delimiter, [instance_num])
o Example: =TEXTAFTER("name@example.com", "@") returns "example.com"
 Use Cases:
o Extract username and domain from email addresses.
o Split order IDs, codes, or categories.
o Replace complex combinations of LEFT(), RIGHT(), FIND().

56. What is the Power BI integration with Excel?

 Excel and Power BI have become more connected, allowing analysts to leverage Excel’s
interface with Power BI’s modeling and visualization power.
 Key Integrations:
o Analyze in Excel: Allows you to connect an Excel workbook to a published Power
BI dataset and use PivotTables, slicers, and Excel formulas to analyze live Power
BI data.
o Export to Excel from Power BI: Export summarized data or the underlying
dataset from Power BI visuals directly into Excel.
o Power BI Publisher Add-In (legacy): Used to pin Excel ranges, charts, and
PivotTables directly to Power BI dashboards (being phased out).
 How to Use "Analyze in Excel":

linkedin.com/in/apoorvaiyerkcl | 33 | P a g e
1. In Power BI Service, select a dataset → Click “Analyze in Excel.”
2. Open the downloaded .odc file → This creates a live PivotTable connected to Power BI.
3. Use Excel features to filter, slice, and calculate metrics without importing data locally.
 Use Cases:
o Real-time business reporting from Power BI models using Excel.
o Building Excel dashboards powered by certified Power BI datasets (central source
of truth).

57. How do you use Excel’s AI-powered Ideas feature?

 The Ideas feature in Excel (also called Analyze Data) uses AI to automatically generate
insights from your dataset, including charts, pivot suggestions, and summary statistics.
 How to Use It:
1. Select a clean, tabular data range.
2. Go to Home → Analyze Data (Ideas).
3. Excel opens a side panel with:
 Automatically detected trends.
 Suggested visuals (bar charts, KPIs).
 Natural language queries like “Total sales by product.”
 Benefits:
o Saves time exploring data.
o Great for non-technical users to derive insights without writing formulas.
o Helps identify trends or anomalies you may have missed.
 Limitations:
o Works best on structured datasets with headers.
o May not support very large or highly unstructured data.

58. How do you connect Excel to external databases or APIs?

 Excel supports live or static connections to a wide range of external data sources, useful
for automation and reporting.

linkedin.com/in/apoorvaiyerkcl | 34 | P a g e
  To Connect to a Database (SQL, Access, etc.):
1. Go to Data → Get Data → From Database (choose your DB type).
2. Enter server name, credentials, and choose the table or query.
3. Load into Excel directly or transform it using Power Query.
 To Connect to APIs (Web Sources):
o Go to Data → Get Data → From Web.
o Enter API URL (must be accessible).
o For authenticated APIs, use Web connector advanced settings with headers (may
need Power Query scripting).
o JSON or XML results can be parsed and loaded.
 Use Case:
o Pulling data from CRMs, ERPs, or financial systems.
o Automating market data import from stock APIs or public datasets.

59. What are the new chart types introduced recently?

 Excel has added several modern chart types to support more advanced and intuitive data
storytelling.
 Recent Chart Types:
o Funnel Chart – Visualizes stages in a process (e.g., sales funnel).
o Map Chart – Geographic visual using country, state, or region data.
o Histogram – Displays frequency distribution of a dataset.
o Box & Whisker Chart – Great for statistical analysis (e.g., data spread and
outliers).
o Waterfall Chart – Used for showing increases/decreases over time (e.g., profit
breakdown).
o Sunburst & Treemap – Useful for hierarchical data visualization.
 Where to Find:
o Insert → Charts → All Charts tab → Choose the type.
 Use Case:
o Presenting budget breakdowns, sales conversions, or regional performance.

linkedin.com/in/apoorvaiyerkcl | 35 | P a g e
60. How do you use the Data Types feature in Excel?
 Data Types convert plain text into rich, structured entities like Stocks, Geography,
Currencies, etc., pulling real-time data from the web.
 How to Use:
1. Type a recognizable keyword (e.g., "India", "Apple Inc").
2. Select the cell → Go to Data → Data Types → Choose a type (e.g., Geography,
Stocks).
3. Once converted, click the small icon to pull fields like population, market cap, etc.
 Custom Data Types (via Power Query):
o You can now create your own data types by combining multiple fields into one
collapsible field (e.g., Customer record with name, email, phone).
 Use Cases:
o Pulling real-time stock prices, currency rates.
o Enriching location data with demographics.
o Building clean, collapsible dashboards using custom types.

Business Analyst-Specific Questions

61. How do you use Excel to perform financial modeling?

 Financial modeling in Excel involves building spreadsheets that represent real-world
financial scenarios — used for budgeting, forecasting, valuation, or decision-making.
 Core Components of a Financial Model:
o Assumptions/Input Sheet: Interest rate, growth rate, tax rate, sales volume.
o Income Statement, Balance Sheet, Cash Flow Statement: Created using linked
formulas.

linkedin.com/in/apoorvaiyerkcl | 36 | P a g e
 o Calculations Section: Revenue forecasts, cost structures, EBITDA, etc.
o KPIs and Ratios: Gross margin, net profit margin, ROE, ROI.
o Dashboard/Summary: Visual charts, scenario outputs, key metrics.
 Excel Functions Used:
o IF(), SUMIFS(), INDEX-MATCH, XLOOKUP, NPV(), IRR(), PMT().
 Tools & Techniques:
o Use of Named Ranges for clarity.
o Data Validation for assumptions control.
o Goal Seek and Scenario Manager for sensitivity analysis.
 Use Case:
o Creating a 5-year business plan for a startup.
o Evaluating M&A projections or loan repayment feasibility.

62. Explain how you would use Excel for customer segmentation analysis.
 Customer segmentation involves grouping customers based on common characteristics
(e.g., behavior, demographics, spending patterns).
 Steps in Excel:
1. Collect data: Customer ID, age, gender, location, purchase frequency, average
spend, etc.
2. Use Pivot Tables to explore grouping patterns.
3. Apply clustering logic manually (e.g., High/Medium/Low based on sales using
IF() or QUARTILE()).
4. Use Conditional Formatting to highlight groups visually.
5. For advanced analysis, use K-means clustering via Power Query (or export to
Power BI/Python).
 Example:
o Segment by Recency, Frequency, Monetary (RFM Analysis):
 Use RANK() or NTILE() to categorize.
 Assign scores and group accordingly.
 Use Case:

linkedin.com/in/apoorvaiyerkcl | 37 | P a g e
 o Identify high-value customers.
o Tailor marketing campaigns for different segments.

63. How do you create and use dynamic dashboards for business reporting?
 A dynamic dashboard updates automatically based on user interaction or data changes and
presents information in a visual, digestible format.
 Steps to Build a Dynamic Dashboard:
1. Prepare clean data using Power Query or raw Excel tables.
2. Use Pivot Tables for summaries.
3. Add Pivot Charts for visuals (bar, line, pie, waterfall).
4. Add Slicers/Timelines to enable interactivity.
5. Create a dedicated Dashboard sheet with layout, buttons, and visuals.
 Dynamic Features:
o Named Ranges for dynamic chart ranges.
o OFFSET(), INDEX() for responsive charts.
o TEXTJOIN(), FILTER(), and UNIQUE() for real-time text summaries.
 Use Case:
o Monthly sales dashboard with filter by region/product.
o Project management summary with real-time task status.

64. How do you use Excel to track KPIs?

 Key Performance Indicators (KPIs) are metrics used to track the success of a business
process or objective.
 How to Track in Excel:
1. Create a KPI table: Metric name, target, actual, variance, status.
2. Use formulas to calculate performance:
3. =Actual - Target
4. =IF(Actual>=Target, "On Track", "Behind")
5. Use Conditional Formatting: Green for "On Track", Red for "Behind".

linkedin.com/in/apoorvaiyerkcl | 38 | P a g e
 6. Visualize using Gauge charts, Bar charts, or Sparklines.
 KPI Examples:
o Sales vs Target
o Customer Acquisition Cost
o Conversion Rate
o Net Promoter Score (NPS)
 Use Case:
o Executive dashboards showing real-time business health indicators.

65. How do you perform variance analysis in Excel?

 Variance Analysis compares actual results with budgeted/forecasted figures to understand
deviations.
 Steps:
1. Create columns: Budget, Actual, Variance (=Actual - Budget), Variance %
(=Variance / Budget).
2. Use Conditional Formatting to highlight positive/negative variances.
3. Create Waterfall Charts to visualize variance impact step-by-step.
4. Drill-down using Pivot Tables (e.g., variance by department, product, region).
 Formula Example:
 =IF(Budget=0, "N/A", (Actual - Budget) / Budget)
 Use Case:
o Monthly expense variance reports.
o Sales performance vs forecast.
o Budget adherence reporting.

66. How do you automate data consolidation from multiple sources?

 Data consolidation is the process of combining data from multiple sheets, files, or systems
into a unified table or report.
 Methods in Excel:

linkedin.com/in/apoorvaiyerkcl | 39 | P a g e
 1. Power Query (Recommended):
 Go to Data → Get Data → From Workbook / Folder / CSV / Database.
 Load each source file.
 Apply data transformation steps (cleaning, renaming, filtering).
 Use Append Queries to stack datasets with identical structures.
 Load the final consolidated data into Excel as a Table or PivotTable.
 Refresh all with one click.
2. Consolidate Tool (Basic Option):
 Go to Data → Consolidate.
 Choose function (Sum, Count, etc.), select ranges from different sheets.
 Consolidate based on row/column labels.
3. VBA Automation:
 Write a macro to loop through multiple workbooks in a folder and extract
standard data from each into a master sheet.
 Use Case:
o Consolidating monthly sales data from regional teams.
o Merging department-wise expense trackers into one budget report.

67. How do you use Excel for budgeting and forecasting?

 Excel is widely used by analysts for creating flexible and scenario-based budgets and
forecasts.
 Budgeting Steps:
1. Start with historical data — use AVERAGEIFS() or TREND() to estimate
baseline values.
2. Build a forecast sheet: Columns for months/quarters, rows for line items.
3. Use assumptions (growth %, inflation, cost increases) in a separate section.
4. Apply formulas to model projected income, expenses, and profits.
5. Use Data Validation or drop-downs for scenario toggles (e.g., Best Case, Worst
Case).
6. Visualize with combo charts: Actual vs Forecast.

linkedin.com/in/apoorvaiyerkcl | 40 | P a g e
  Tools:
o FORECAST.LINEAR(), TREND(), SEQUENCE()
o Goal Seek, Scenario Manager
o Conditional formatting to show over/under budget
 Use Case:
o Departmental operating budgets.
o Annual sales forecast models for product lines.

68. How do you use scenario analysis for decision making?

 Scenario analysis evaluates how changes in inputs (like cost, sales, or market conditions)
affect outcomes like profit or ROI.
 Excel Tools for Scenario Analysis:
1. Scenario Manager:
 Go to Data → What-If Analysis → Scenario Manager.
 Add different scenarios (e.g., High Sales, Low Sales) by changing inputs.
 Summarize all scenarios in one report.
2. Data Tables:
 Use one-variable or two-variable data tables to see outcomes across
different input values.
 Example: Evaluate how profit changes with different prices and units sold.
3. Manual Toggle Setup:
 Create a cell that toggles between “Base,” “Best,” and “Worst” and link
formulas to switch assumptions.
 Use Case:
o Choosing between marketing campaign options.
o Pricing models for a new product.
o Evaluating investment returns under different economic conditions.

69. How do you ensure data quality in large Excel datasets?

linkedin.com/in/apoorvaiyerkcl | 41 | P a g e
  Ensuring high data quality is crucial for reliable analysis and reporting.
 Techniques to Ensure Quality:
o Data Validation: Restrict entries to predefined lists, ranges, or types.
o Conditional Formatting: Highlight missing, duplicate, or inconsistent entries.
o Formulas: Use ISERROR(), ISTEXT(), ISNUMBER() to test values.
o Remove Duplicates: Data → Remove Duplicates or use Power Query.
o Consistency Checks: Use COUNTIFS, SUMIFS, and pivot tables to validate totals
against source documents.
 Best Practices:
o Use structured Excel tables to ensure column-level integrity.
o Maintain a data dictionary or metadata sheet to track definitions.
o Regularly audit using filters and sample-based inspection.
 Use Case:
o Customer databases, transaction logs, HR master data validation.

70. How do you document your Excel models for business users?
 Documentation makes your models transparent, reusable, and easy for others to understand
or audit.
 Documentation Components:
o Assumptions Sheet: Clearly outline input values, source references, and
definitions.
o Change Log: List of edits made to logic, formulas, or structure.
o Named Ranges: Use meaningful names to simplify formulas.
o Comments & Notes: Add cell-level notes for important formulas.
o Color Coding: Use formatting conventions (e.g., blue = input, black = formula,
green = output).
 Tips:
o Add a "Read Me" tab with navigation guide and purpose of the model.
o Use grouping and hiding to simplify the interface for end users.
o Lock or protect sheets where users shouldn’t make changes.

linkedin.com/in/apoorvaiyerkcl | 42 | P a g e
  Use Case:
o Sharing Excel pricing tools, budget planners, or project calculators with
stakeholders.

Advanced Pivot Table Techniques

71. How do you create calculated fields and items in Pivot Tables?
Creating calculated fields and items in Pivot Tables allows users to perform custom calculations
without modifying the original dataset. This is particularly useful when analytical logic needs to
be added on top of existing summaries.
• Calculated Field:
A calculated field is a custom field you add to the Values area that performs a formula on the
existing numeric fields.
Steps to create a calculated field:
1. Click on any cell in the Pivot Table.
2. Go to PivotTable Analyze > Fields, Items, & Sets > Calculated Field.
3. In the dialog box, give a name (e.g., "Profit Margin").
4. In the formula box, input a calculation like =Revenue - Cost.
5. Click OK.
The new field will now appear in the Pivot Table and calculate for each group/row.
• Calculated Item:
A calculated item is used in the Rows or Columns area when you want to create a new item by
calculating between existing items.
Example:
If your rows contain "Product A" and "Product B", you could create a calculated item called "Total
AB" using = 'Product A' + 'Product B'.
Steps:
1. Select the Pivot Table field in the row or column area.
2. Go to PivotTable Analyze > Fields, Items, & Sets > Calculated Item.

linkedin.com/in/apoorvaiyerkcl | 43 | P a g e
 3. Enter a name and formula.
4. Click OK.
Key Notes:
 Calculated fields work on the underlying data.
 Calculated items work on summarized Pivot Table results.
 Use sparingly in large datasets to avoid performance issues.

72. How do you group data in Pivot Tables (dates, numbers)?

Grouping data in Pivot Tables helps in summarizing and analyzing data more efficiently by
consolidating values.
• Grouping Dates:
You can group dates into months, quarters, or years.
Steps:
1. Drag a date field into the Row or Column Labels.
2. Right-click on any date value > Group.
3. Choose options like Days, Months, Quarters, Years.
4. Click OK.
This automatically creates multi-level grouping for time series analysis.
• Grouping Numbers:
You can group numeric values into bins (e.g., Sales ranges: 0–1000, 1001–2000, etc.).
Steps:
1. Drag a number field into Rows or Columns.
2. Right-click a value > Group.
3. Enter the starting point, ending point, and interval size (e.g., 0 to 5000 by 1000).
4. Click OK.
• Custom Grouping (Manual):
Select multiple row items > Right-click > Group.
This allows manual control over how items are grouped (e.g., grouping cities into regions).
Grouping is an essential feature in Pivot Table analysis to derive meaning from raw data intervals.

linkedin.com/in/apoorvaiyerkcl | 44 | P a g e
73. How do you create Pivot Charts?
Pivot Charts are dynamic visualizations that are directly connected to Pivot Tables. They update
automatically when the Pivot Table changes.
Steps to create a Pivot Chart:
1. Click inside the Pivot Table.
2. Go to Insert > Pivot Chart.
3. Choose the chart type (Column, Bar, Line, etc.).
4. Click OK.
Features:
 All filters and slicers applied to the Pivot Table affect the chart.
 Axes adjust automatically when data is grouped or ungrouped.
 Interactive field buttons can be displayed or hidden (PivotChart Analyze > Field Buttons).
Tip:
Use Pivot Charts with slicers and timeline filters for dynamic dashboards.

74. How do you refresh and update Pivot Tables with new data?
Refreshing Pivot Tables is essential to keep them in sync with changes in the underlying data.
• Manual Refresh:
Right-click anywhere in the Pivot Table > Refresh.
• Ribbon Method:
Go to PivotTable Analyze > Refresh.
• Refresh All (for multiple tables):
Go to Data > Refresh All.
• Auto Refresh After File Open (VBA):
Use this VBA snippet in the Workbook module:
Private Sub Workbook_Open()
ThisWorkbook.RefreshAll
End Sub
• Expanding Data Source Range Automatically:
Convert the source data to an Excel Table (Ctrl + T). Pivot Tables built on Tables auto-expand as
new data is added.

linkedin.com/in/apoorvaiyerkcl | 45 | P a g e
Regularly refreshing ensures accuracy in reports, especially when working with dynamic datasets.

75. How do you use multiple consolidation ranges in Pivot Tables?

Using multiple consolidation ranges allows you to summarize data from different sheets or ranges
into a single Pivot Table. This is useful when combining monthly reports or regional files.
Steps:
1. Go to Insert > PivotTable.
2. Select Use this workbook’s data model > Multiple Consolidation Ranges.
3. Choose ranges from different sheets.
4. Decide on page fields to separate data (optional).
5. Click OK.
Limitations:
 Data must have identical column structures.
 You don’t get traditional Pivot Field Lists (e.g., named fields).
 Better used when combining data into a master dataset before Pivoting.
For flexible analysis, Power Query is often a better approach than multiple consolidation ranges.

76. How do you filter data using slicers in Pivot Tables?

Slicers provide a user-friendly way to filter data in Pivot Tables using clickable buttons.
Steps to add a slicer:
1. Click anywhere in the Pivot Table.
2. Go to PivotTable Analyze > Insert Slicer.
3. Select the field(s) you want to filter by (e.g., Region, Category).
4. Click OK.
Features:
 Multiple selections can be made with Ctrl + Click.
 Slicers can be formatted for visual consistency in dashboards.
 Slicers can control multiple Pivot Tables (connect via Report Connections).

linkedin.com/in/apoorvaiyerkcl | 46 | P a g e
Slicers make Pivot Table filters more accessible and interactive, especially in presentations or
shared reports.

77. How do you connect multiple Pivot Tables to a single slicer?

To enhance interactivity in dashboards, you can connect one slicer to multiple Pivot Tables—
provided they share the same data source.
Steps:
1. Insert a Slicer for the first Pivot Table.
2. Right-click on the slicer > Report Connections (or PivotTable Connections).
3. Select other Pivot Tables that use the same data source.
4. Click OK.
Now, filtering the slicer updates all connected Pivot Tables simultaneously.
Note:
This only works if Pivot Tables are built from the same Excel Table or Data Model. If not,
reconsolidate the source data.

78. How do you use the GETPIVOTDATA function?

The GETPIVOTDATA function retrieves specific data from a Pivot Table, allowing for more
controlled referencing in dynamic reports.
Syntax:
=GETPIVOTDATA("Sales", $A$3, "Region", "South", "Product", "A")
• "Sales" is the data field you want.
• $A$3 is any cell inside the Pivot Table.
• "Region", "South" and "Product", "A" are field-item pairs.
Uses:
 Helps build custom dashboards outside the Pivot Table layout.
 Prevents errors from shifting references when Pivot layout changes.
To disable auto-generation:
Go to File > Options > Formulas > Uncheck “Use GETPIVOTDATA functions for PivotTable
references”.

linkedin.com/in/apoorvaiyerkcl | 47 | P a g e
79. How do you create a Pivot Table using Power Pivot and the Data Model?
Power Pivot allows for building Pivot Tables using multiple related tables—ideal for advanced
models and dashboards.
Steps:
1. Load data into Power Pivot (Power Pivot > Add to Data Model).
2. Create relationships between tables (Diagram View).
3. Insert a Pivot Table from Power Pivot window (Home > PivotTable).
4. Select fields from multiple tables—Power Pivot will handle the joins.
Benefits:
 Supports millions of rows.
 Allows use of DAX formulas for measures and KPIs.
 Enables complex relationships (like Star Schema).
This is especially valuable for Business Analysts building robust reporting systems from
normalized data.

80. How do you apply conditional formatting to Pivot Tables?

Conditional formatting in Pivot Tables helps highlight trends, outliers, and important metrics
visually.
Steps:
1. Select the values in the Pivot Table.
2. Go to Home > Conditional Formatting.
3. Choose options like Color Scales, Data Bars, Icon Sets.
Key Tips:
 Choose “All cells showing values for…” to apply rules across all similar data points.
 Use custom formulas in formatting rules for more control.
 Be cautious—Pivot Table refreshes can sometimes remove conditional formats. To retain
them, use Excel Tables with linked formulas when possible.

linkedin.com/in/apoorvaiyerkcl | 48 | P a g e
 Behavioral And Experience Based Questions

81. Describe a challenging Excel problem you solved.

 Example Scenario:
o While working on a marketing ROI dashboard, I was given multiple Excel files
from different regions, each with a different format and inconsistent column names.
 Challenges Faced:
o Duplicates, missing values, inconsistent date formats, and non-standard column
headers.
o Complex nested formulas for dynamic budget allocation that frequently broke with
new data.
 Solution Approach:
o Used Power Query to standardize and clean each file.
o Created a mapping table to unify header names.
o Built a consolidated data model using Power Pivot, linked via unique campaign
IDs.
o Used XLOOKUP(), LET(), and conditional formatting to dynamically analyze and
highlight anomalies.
o Designed a user-friendly dashboard with slicers, timelines, and pivot charts.
 Impact:
o Reduced manual work by 80%, improved accuracy, and made the dashboard
refreshable in one click.

82. How do you keep your Excel skills updated?

 Continuous Learning Approach:
o Regularly follow trusted sources like Microsoft Learn, ExcelJet, and
Chandoo.org.
o Participate in LinkedIn communities and Excel forums to explore real-world use
cases.
o Explore new features in Microsoft 365 Insider Preview (like LAMBDA, LET,
Dynamic Arrays).

linkedin.com/in/apoorvaiyerkcl | 49 | P a g e
 o Practice building projects — dashboards, financial models, data analysis reports —
using real datasets.
o Take short certifications or online courses from platforms like Coursera, LinkedIn
Learning, or edX.
 Practical Tip:
o Always apply new functions or features to a real project — it ensures retention and
relevance.

83. How do you manage version control in Excel files?

 Best Practices for Version Control:
o Use clear file naming conventions:
 Example: Sales_Model_v1.3_Reviewed_May05.xlsx
o Save backups with timestamps or changelogs.
o Use version history in OneDrive or SharePoint to revert to previous versions.
o Maintain a "Change Log" tab in the workbook summarizing changes, authors, and
dates.
o Use comments and cell notes to explain formula logic or changes made.
 Use Case:
o Ensuring that collaborative budgeting models have a clear audit trail and rollback
option.

84. How do you collaborate with teams using Excel?

 Collaboration Methods:
o Use Excel Online (Microsoft 365) for real-time co-authoring.
o Share files via OneDrive or SharePoint for controlled access and version tracking.
o Assign protected ranges to different users using sheet protection with permissions.
o Use Comments and Notes to leave feedback or questions directly in the sheet.
o Track changes using the “Track Changes” feature or through manual change logs.
 Best Practices:
o Define a clear file structure: inputs, calculations, outputs.

linkedin.com/in/apoorvaiyerkcl | 50 | P a g e
 o Create a "Read Me" sheet explaining usage, navigation, and collaboration rules.
o Avoid overwriting — use filters, dropdowns, and validations to standardize input
formats.

85. Describe how you have automated a repetitive task in Excel.

 Scenario:
o Monthly HR headcount report involved copying data from three files, cleaning it,
and calculating attrition and hiring metrics manually.
 Solution:
o Used Power Query to connect and clean each source file.
o Created a reusable data model with calculated columns and PivotTables.
o Wrote a macro to refresh the data and export summary sheets to PDF.
o Added a button to run the macro, making it accessible to non-technical users.
 Impact:
o What used to take 3 hours manually was reduced to under 2 minutes with one click.
o Enabled leadership to access fresh reports with real-time insights.

86. How do you explain Excel data insights to non-technical stakeholders?

 Approach:
o Focus on key trends, not technical details. Translate numbers into business
impact.
o Use dashboards and charts instead of tables and formulas.
o Provide clear comparisons: actual vs target, month-on-month change, year-on-
year growth.
o Use color-coded visuals like conditional formatting or traffic-light indicators to
highlight insights.
o Summarize findings in plain language:
“Revenue dropped 12% in Q2, primarily due to lower sales in South India. We
recommend targeted campaigns in that region.”
 Tools Used:

linkedin.com/in/apoorvaiyerkcl | 51 | P a g e
 o PivotCharts, slicers, TEXTJOIN() for textual summaries, SmartArt for process
visuals.
 Best Practice:
o Create a "Storytelling Summary" at the top of the dashboard or presentation — 3–5
bullet points that narrate the data.

87. How do you handle confidential data in Excel?

 Security Practices:
o Store files in encrypted locations (e.g., OneDrive, SharePoint with restricted
access).
o Use password protection for the workbook and individual sheets (File → Info →
Protect Workbook).
o Lock and hide sensitive formula cells using Format Cells → Protection →
Hidden, then protect the sheet.
o Mask or anonymize PII (e.g., use employee IDs instead of names).
 Additional Measures:
o Avoid emailing sensitive files — share via secured links with permission levels.
o Disable external links and macros when sharing externally.
o Always back up sensitive files before sharing.
 Use Case:
o HR compensation reports, internal audit sheets, or client financial data trackers.

88. What is your approach to validating data inputs?

 Validation Strategy:
o Use Data Validation to restrict data entry: lists, numbers only, date ranges, etc.
o Use formulas like ISNUMBER(), ISDATE(), and COUNTIF() to flag incorrect or
duplicate entries.
o Highlight errors with conditional formatting or create a separate validation sheet
with error checks.
 Process:
1. Set validation rules at data entry points.

linkedin.com/in/apoorvaiyerkcl | 52 | P a g e
2. Use dropdowns to prevent typos or inconsistent naming.
3. Create summary metrics to check for missing values, outliers, or invalid formats.
4. Build in alerts like:
5. =IF(A2="", "Missing input", "")
 Use Case:
o Ensuring clean survey data before analysis or preparing investor dashboards.

89. How do you prioritize tasks when working with large datasets?
 Prioritization Method:
o Start with clarifying the objective — what decision needs to be supported?
o Identify critical variables (e.g., dates, metrics, key dimensions like region or
category).
o Use Pivot Tables or COUNTIF()/SUMIF() to get a quick overview of trends or
anomalies.
o Focus on cleaning and structuring high-priority columns first.
o Break tasks into chunks: cleaning, transformation, modeling, visualization.
 Tool Tip:
o Use filters, column profiling (in Power Query), and sampling to find quality issues
early.
 Use Case:
o Analyzing sales performance data for 12 regions over 2 years — prioritize regions
with largest revenue contribution first.

90. Describe a time when Excel helped you improve a business process.
 Scenario:
o The logistics team manually tracked delivery delays across 20 cities, leading to
inconsistent records and no visibility into bottlenecks.
 Excel Solution:
o Collected all delivery data in a single workbook.
o Used Power Query to clean city-wise entries and standardize timestamps.

linkedin.com/in/apoorvaiyerkcl | 53 | P a g e
 o Created a dynamic dashboard with slicers to view delays by city, reason, and
carrier.
o Highlighted cities with >10% delay rate using conditional formatting.
 Impact:
o Enabled the team to identify top 3 cities causing 60% of all delays.
o Suggested operational fixes reduced average delivery delay from 4.2 days to 2.9
days within a month.

Miscellaneous Advanced Topics

91. How do you use the Power Map feature for geographic data visualization?
 Power Map is a 3D data visualization tool in Excel that allows you to plot geographic and
time-based data on a globe or flat map. It is especially useful for visualizing trends,
comparisons, and patterns across geographical locations.
 How to Use:
o Go to Insert → 3D Map → Open 3D Maps (available in Microsoft 365 and Excel
2016+).
o Ensure your data includes fields like Country, State, City, or Latitude/Longitude.
o Excel will recognize geographic fields and map them accordingly.
o You can visualize data using stacked columns, heat maps, bubble charts, etc.
o Use the Tour Editor to create step-by-step animated visual walkthroughs.
 Use Case:
o Displaying sales by region, shipment routes, or COVID-19 spread over time.

92. How do you create and use templates in Excel?

linkedin.com/in/apoorvaiyerkcl | 54 | P a g e
  Excel templates allow you to create standardized and reusable formats for frequently
used workbooks such as invoices, trackers, reports, and dashboards.
 Steps to Create a Template:
o Create your workbook with headers, formulas, conditional formatting, and
structure.
o Save the file as Excel Template (*.xltx) using File → Save As → Excel
Template.
o You can access your templates from File → New → Personal.
 Advantages:
o Saves time and ensures consistency.
o Reduces manual errors by locking structure.
o Can include protected cells, drop-downs, and predefined formulas.
 Use Case:
o Monthly budget sheets, employee onboarding forms, or project management
trackers.

93. How do you customize the Quick Access Toolbar?

 The Quick Access Toolbar (QAT) allows you to pin frequently used commands for fast
access, regardless of which ribbon tab is open.
 How to Customize:
o Click the dropdown at the top-left corner of Excel → Select More Commands.
o Add or remove commands from the list — popular ones include Save As, Print
Preview, Format Painter, and Macros.
o You can also choose to display it above or below the ribbon.
 Use Case:
o Streamlining your workflow by pinning tools like Paste Values, Sort, Camera Tool,
and Macros for single-click access.

94. How do you use the Watch Window for monitoring cells?
 The Watch Window is a tool that allows you to track the value and formula of
important cells in one place, especially helpful when working on large or multi-sheet
workbooks.

linkedin.com/in/apoorvaiyerkcl | 55 | P a g e
  How to Use:
o Go to Formulas → Watch Window → Add Watch.
o Select the cells you want to monitor.
o The Watch Window will show the current value, formula, workbook, and sheet.
 Use Case:
o Monitoring KPIs or total outputs while making changes to other parts of a financial
model.

95. How do you use the INDIRECT function with external references?
 The INDIRECT function returns a reference specified by a text string. However, when
used with external workbooks, the referenced file must be open for the function to work.
 Syntax:
 =INDIRECT("'[WorkbookName.xlsx]Sheet1'!A1")
 Limitations:
o Will return #REF! if the external workbook is closed.
o Not ideal for scalable models due to performance concerns.
 Use Case:
o Dynamically switching between different files based on dropdowns or scenario
setups.

96. How do you create dependent drop-down lists using named ranges?
 Dependent drop-downs adjust the options in the second drop-down based on the selection
in the first.
 Steps:
1. Create a main category list (e.g., Region).
2. Define named ranges for each sub-list. For example, name the range of cities under
“North” as North.
3. Use Data Validation in the first cell: =RegionList.
4. Use INDIRECT(A2) in the second cell’s validation (assuming A2 is the first drop-
down).

linkedin.com/in/apoorvaiyerkcl | 56 | P a g e
  Use Case:
o Selecting Product Category → Subcategory or Country → State.

97. How do you use the Form Controls and ActiveX Controls?
 These are interactive objects that allow user inputs, macro execution, and dashboard
interactivity.
 Form Controls:
o Available in Developer → Insert → Form Controls.
o Include buttons, checkboxes, drop-downs, scrollbars.
o Simple, lightweight, and cross-compatible across Excel versions.
 ActiveX Controls:
o Also in Developer tab, more powerful and customizable.
o Can respond to events (e.g., double-click) and support font/color/style adjustments.
o Work only on Windows.
 Use Case:
o Create interactive forms, trigger macros with buttons, or create scroll-based input
ranges.

98. How do you use the Data Table feature for sensitivity analysis?
 Data Tables allow you to evaluate how changes in one or two variables affect an output.
 Steps:
o Set up a formula (e.g., profit based on price and quantity).
o Create a row or column of input values next to it.
o Go to Data → What-If Analysis → Data Table.
o For a 1-variable table, enter the formula cell and column/row input cell.
o For a 2-variable table, set up a matrix and define both input cells.
 Use Case:
o Test pricing strategies, profit models, or sales forecasts under different
assumptions.

linkedin.com/in/apoorvaiyerkcl | 57 | P a g e
99. How do you use the Scenario Manager for what-if analysis?
 The Scenario Manager allows you to store and switch between multiple sets of inputs.
 Steps:
o Go to Data → What-If Analysis → Scenario Manager.
o Click Add, name the scenario, and select input cells.
o Enter values for each scenario (e.g., Best Case, Worst Case).
o Generate a summary report to compare all scenarios.
 Use Case:
o Budgeting multiple cost scenarios or revenue outcomes for business planning.

100. How do you use Goal Seek to find input values for desired outputs?
 Goal Seek finds the input value needed to achieve a desired result from a formula.
 Steps:
o Go to Data → What-If Analysis → Goal Seek.
o Set cell: the formula cell you want to hit a target value in.
o To value: the target value (e.g., ₹5,00,000).
o By changing cell: the input variable cell.
 Use Case:
o Finding the sales volume required to achieve a target profit.

linkedin.com/in/apoorvaiyerkcl | 58 | P a g e
I hope you found this
helpful!

APOORVA IYER

linkedin.com/in/apoorvaiyerkcl | 59 | P a g e