KaabilGet the app

Interview prep

Excel interview questions

Excel interview questions for freshers test whether you can work with real business data: lookups such as VLOOKUP, XLOOKUP and INDEX-MATCH, IF and COUNTIFS formulas, absolute and relative references, pivot tables, cleaning data, and charts. Accounts, MIS, operations and analyst roles often add a short practical test on a sample sheet.

  • Updated
  • 30 questions with answers

Kaabil AI builds and scores your resume, and its Career Agent emails recruiters for jobs you approve. 7 days free, no card.Start free trial

Formulas use a simple sheet: names in column A, regions in column B and sales in column C.

Questions with answers30in 4 groups

Basic Excel interview questions for freshers

8 questions

  1. What is the difference between a relative and an absolute cell reference?

    Basic

    A relative reference such as A1 changes when you copy the formula to another cell. An absolute reference such as $A$1 stays fixed. A mixed reference fixes only the column ($A1) or only the row (A$1). Press F4 while editing a reference to cycle through them.

  2. What is the difference between COUNT, COUNTA and COUNTBLANK?

    Basic

    COUNT counts cells that contain numbers. COUNTA counts cells that are not empty, whatever they contain. COUNTBLANK counts empty cells in a range.

  3. What is the difference between a formula and a function?

    Basic

    A formula is anything you type that starts with = and calculates a result, such as =A1+B1. A function is a built-in, named calculation such as SUM or VLOOKUP that you use inside a formula.

  4. What does Freeze Panes do?

    Basic

    It keeps chosen rows or columns, usually the header row, visible while you scroll through a long sheet. Find it under View, Freeze Panes.

  5. How do you remove duplicates in Excel?

    Basic

    Select the data, then Data, Remove Duplicates, and choose the columns that define a duplicate. To find them without deleting, use Conditional Formatting, Highlight Duplicate Values, or a COUNTIF column. In Microsoft 365 the UNIQUE function returns a list without duplicates.

  6. What is data validation?

    Basic

    A rule that controls what can be typed into a cell, such as a dropdown list of departments, whole numbers between 1 and 100, or dates after today. It prevents bad data instead of cleaning it later.

  7. What is conditional formatting?

    Basic

    Formatting that changes with the cell value: colouring cells above a target green, highlighting duplicates, or adding data bars and colour scales. It makes patterns visible at a glance.

  8. Name some Excel shortcuts you use.

    Basic

    Ctrl+T (make a table), Ctrl+Shift+L (filters), Ctrl+Arrow keys (jump to the edge of data), Ctrl+Shift+Arrow (select to the edge), F4 (toggle absolute references), Alt+= (AutoSum), Ctrl+; (today's date) and Ctrl+1 (format cells).

Excel formula interview questions

10 questions

  1. How does VLOOKUP work?

    Basic

    VLOOKUP looks for a value in the first column of a range and returns a value from a column to the right. The last argument should be FALSE (or 0) for an exact match; TRUE gives an approximate match and needs sorted data.

    =VLOOKUP("Priya", A2:C100, 3, FALSE)

  2. What are the limitations of VLOOKUP?

    Intermediate

    It can only look to the right of the lookup column, it uses a column number that breaks if someone inserts a column, it returns only the first match, and it can be slow on very large ranges. INDEX-MATCH or XLOOKUP fix these.

  3. How does INDEX-MATCH work, and why is it better than VLOOKUP?

    Intermediate

    MATCH finds the position of a value in a column; INDEX returns the value at that position in another column. Because the two columns are separate, it can look left and does not break when columns are inserted.

    =INDEX(C2:C100, MATCH("Priya", A2:A100, 0))

  4. What is XLOOKUP?

    Intermediate

    A newer lookup function in Microsoft 365, Excel 2021 and later. It takes a lookup range and a return range, looks in any direction, does an exact match by default and lets you set a value to show when nothing is found.

    =XLOOKUP("Priya", A2:A100, C2:C100, "Not found")

  5. How do SUMIF and SUMIFS differ?

    Basic

    SUMIF adds values that meet one condition. SUMIFS adds values that meet several conditions, and its sum range comes first. COUNTIF/COUNTIFS and AVERAGEIF/AVERAGEIFS work the same way.

    =SUMIF(B2:B100, "North", C2:C100)
=SUMIFS(C2:C100, B2:B100, "North", C2:C100, ">50000")

  6. How do you write a nested IF, and what is the alternative?

    Intermediate

    Put one IF inside another to test several conditions in order. With many conditions, IFS (Excel 2019 and later) is easier to read.

    =IF(C2>=90000, "A", IF(C2>=50000, "B", "C"))
=IFS(C2>=90000, "A", C2>=50000, "B", TRUE, "C")

  7. What does IFERROR do?

    Basic

    It returns a value you choose when a formula gives an error such as #N/A or #DIV/0!. It is often wrapped around lookups so missing values show "Not found" or 0 instead of an error.

    =IFERROR(VLOOKUP(E2, A2:C100, 3, FALSE), "Not found")

  8. Which text functions do you use to clean data?

    Intermediate

    TRIM removes extra spaces, PROPER, UPPER and LOWER fix case, LEFT, RIGHT and MID pull out parts of text, LEN counts characters, SUBSTITUTE replaces text, and TEXTJOIN or the & operator join text.

    =PROPER(TRIM(A2))
=LEFT(A2, FIND(" ", A2) - 1)   (first name)

  9. Which date functions should you know?

    Intermediate

    TODAY and NOW for the current date and time, DATE to build a date, YEAR, MONTH and DAY to split one, EOMONTH for month-ends, and NETWORKDAYS for working days between two dates.

  10. What do the common Excel errors mean?

    Basic

    #N/A: a lookup found no match. #DIV/0!: division by zero or an empty cell. #VALUE!: the wrong type of data, such as text in a sum. #REF!: a referenced cell was deleted. #NAME?: a misspelt function or range name.

Pivot table and data analysis questions

6 questions

  1. What is a pivot table?

    Basic

    A tool that summarises a large table in seconds by dragging fields into Rows, Columns, Values and Filters, for example total sales by region and month. It does not change the source data.

  2. How do you update a pivot table when the data changes?

    Basic

    Right-click it and choose Refresh, or use Data, Refresh All. If new rows are added below the data, convert the source to an Excel table (Ctrl+T) first so the pivot picks them up automatically.

  3. What are slicers and calculated fields in a pivot table?

    Intermediate

    Slicers are clickable buttons that filter a pivot table, and one slicer can control several pivots. A calculated field is a new value computed from other fields inside the pivot, such as profit equals sales minus cost.

  4. How do you show a value as a percentage of the total in a pivot table?

    Intermediate

    Right-click a value, choose Show Values As, then % of Grand Total, % of Column Total or % of Row Total.

  5. What is the difference between a filter and an advanced filter?

    Intermediate

    A normal filter hides rows in place using dropdowns on the headers. An advanced filter uses a separate criteria range, can apply complex AND/OR conditions and can copy the matching rows to another location.

  6. What is Goal Seek?

    Intermediate

    A what-if tool that finds the input needed to reach a result. For example, it finds the sales figure needed to hit a target profit by changing one input cell. It is under Data, What-If Analysis.

Advanced Excel interview questions

6 questions

  1. What is an Excel table, and why use one?

    Intermediate

    Format a range as a table (Ctrl+T) and it gets headers with filters, banded rows, automatic expansion when you add data, and formulas that copy down by themselves. Pivots and charts built on a table grow with it.

  2. What is Power Query in Excel?

    Advanced

    A tool under Data, Get and Transform that imports and cleans data with recorded steps: removing columns, splitting, merging files and unpivoting. Next month you click Refresh instead of redoing the cleaning by hand.

  3. What is a macro?

    Advanced

    A recorded or written set of steps, stored in VBA, that repeats a task with one click, such as formatting a daily report. Files with macros are saved as .xlsm.

  4. What is Flash Fill?

    Intermediate

    Excel fills a column by spotting the pattern from one or two examples you type, such as pulling first names out of full names. Press Ctrl+E. It does not create a formula, so it does not update when the source changes.

  5. Which chart would you use for trends, comparisons and shares?

    Basic

    A line chart for trends over time, a bar or column chart to compare categories, and a pie or doughnut only for a few parts of one whole. A combo chart shows two measures with different scales, such as sales and margin.

  6. How would you find and fix inconsistent entries such as "Bangalore", "Bengaluru" and "bangalore "?

    Intermediate

    Use TRIM and PROPER to fix spaces and case, then filter the column or use a pivot to list the unique values, and Find and Replace to make them consistent. Add data validation with a dropdown so it does not happen again.

How to prepare for an Excel interview

  1. Download a sample sales or HR dataset and practise on it: VLOOKUP, INDEX-MATCH, XLOOKUP, SUMIFS, COUNTIFS, IF and IFERROR until you can write each without help.

  2. Build two pivot tables and a chart from the same data, add a slicer and refresh it after adding new rows.

  3. Clean a messy sheet: extra spaces, mixed case, duplicates, dates stored as text. Clean data is what most office roles spend their time on.

  4. Learn ten shortcuts and use them, because some practical tests are timed and interviewers notice speed.

  5. If the role is analytical, add basic Power BI or SQL. Our Power BI interview questions are the natural next step.

What is asked in an Excel test for a job?

Practical Excel tests for freshers usually give you a sheet and 20 to 30 minutes to: look up values from a second sheet, total by category with SUMIFS or a pivot table, flag rows with IF or conditional formatting, remove duplicates and build one chart. Accounts roles add date and rounding functions; MIS roles add pivots and lookups across files.

Kaabil App

Prove your skills before the interview.

Take skill assessments in the Kaabil AI app. Passed checks become certificates from Kaabil AI by Redrob, with a verification link.

See the Kaabil App
Start free trialGet it on Google PlayDownload on the App Store

7 days free · No card

Questions freshers ask

There is no fixed definition, but in job posts it usually means lookups (VLOOKUP, INDEX-MATCH, XLOOKUP), SUMIFS and COUNTIFS, nested IFs, pivot tables, charts, data validation, conditional formatting and, for some roles, Power Query and macros.

Yes. Many offices still use Excel versions without XLOOKUP, and VLOOKUP is the most common lookup in existing files. Learn VLOOKUP, its limits, and INDEX-MATCH or XLOOKUP as the fix.

Accounts and finance, MIS and reporting, operations, sales coordination, HR operations and data analyst roles all list Excel. For analyst roles it is a minimum, with SQL or Power BI on top.

With daily practice, the formulas and pivot tables most fresher roles test take about three to five weeks. Practise on real-looking data rather than only watching tutorials.