Microsoft Excel is a powerful tool widely used in the corporate world for data management, analysis, and reporting. It helps employees organize large amounts of information efficiently using spreadsheets, formulas, and functions. Excel enhances productivity by simplifying complex calculations, generating charts, and automating repetitive tasks through features like pivot tables and macros. Whether you’re in finance, marketing, HR, or operations, Excel plays a crucial role in decision-making and daily business activities. Its versatility makes it essential for preparing reports, tracking performance, and analyzing trends. Mastering Excel is a valuable skill for anyone aiming to succeed in a corporate environment.
What is MS Excel?
Excel is a spreadsheet program developed by Microsoft used for organizing, analyzing, and storing data. It allows users to perform calculations, create charts, and use functions to manage data efficiently. Widely used in businesses and education, Excel simplifies tasks like budgeting, reporting, and data analysis through its powerful features.
Here’s a friendly guide to common Excel interview questions for freshers, organized into basic, intermediate, and scenario-based categories. These questions are designed to help you showcase both your practical skills and your understanding of key Excel concepts.
Important Basic Excel Interview Questions
1. What is Microsoft Excel?
2. What are cells and cell references in Excel?
In Excel, cells are individual boxes where you enter data, located at the intersection of rows and columns. Cell references identify a cell’s location using its column letter and row number (e.g., A1).
3. What is the difference between a workbook and a worksheet?
A workbook is an Excel file that contains one or more worksheets. A worksheet is a single spreadsheet within the workbook where data is entered and organized.
4. How do you save a file in Excel?
To save a file in Excel, click File > Save or press Ctrl + S. Choose a location, enter a file name, and click Save.
5. What are the different data types supported in Excel?
Excel supports various data types, including text, numbers, dates, times, booleans (TRUE/FALSE), and formulas. These types help in organizing, calculating, and analyzing data effectively.
6. What is the default file extension for Excel 2016 or later?
The default file extension for Excel 2016 or later is .xlsx. It represents a standard Excel workbook without macros.
7. How do you insert a new row or column in Excel?
To insert a new row or column in Excel, right-click a row number or column letter and select Insert. You can also use the Insert option from the Home tab.
8. What is the shortcut to create a new Excel workbook?
The shortcut to create a new Excel workbook is Ctrl + N. This opens a blank workbook instantly.
9. How do you apply bold, italics, or underline in Excel?
To apply bold, select the cell and press Ctrl + B.
For italics, use Ctrl + I, and for underline, press Ctrl + U.
You can also click the corresponding buttons on the Home tab in the ribbon.
10. What is the use of AutoSum in Excel?
AutoSum in Excel quickly adds a range of numbers with a single click.
It automatically selects adjacent cells and inserts the SUM function.
You can find it on the Home tab or use the shortcut Alt + =.
Intermediate Level Excel Interview Questions
1. What are formulas in Excel? Give examples.
Formulas in Excel are expressions used to perform calculations on data.
They begin with an equal sign (=) and can include functions, cell references, and operators.
Example: =A1+B1 adds two cells, and =SUM(A1:A5) totals a range.
2. What is the difference between a formula and a function?
A formula is a user-defined expression to perform calculations, like =A1+B1.
A function is a predefined formula in Excel, such as =SUM(A1:A5).
Functions simplify complex calculations, while formulas can combine multiple functions and operators.
3. Name some commonly used functions in Excel.
SUM, AVERAGE, IF, VLOOKUP, HLOOKUP, COUNT, COUNTA
4. What is the use of the IF function?
The IF function in Excel checks whether a condition is true or false.
It returns one value if the condition is true and another if it’s false.
Example: =IF(A1>10, “Yes”, “No”) returns “Yes” if A1 is greater than 10.
5. What is the VLOOKUP function, and how is it used?
The VLOOKUP function searches for a value in the first column of a table.
It then returns a value from the same row in a specified column.
Example: =VLOOKUP(101, A2:C10, 2, FALSE) looks for 101 in column A and returns the value from column B.
6. Explain the difference between relative, absolute, and mixed cell references.
Relative references (e.g., A1) change when copied to another cell.
Absolute references (e.g., $A$1) stay fixed, no matter where they’re copied.
Mixed references (e.g., $A1 or A$1) lock either the row or the column.
7. How do you filter data in Excel?
To filter data in Excel, select your data range and click Filter on the Data tab.
Small dropdown arrows will appear in the header cells.
Click the arrows to choose specific values or conditions to display.
8. What is conditional formatting?
Conditional formatting highlights cells based on specific rules or conditions.
It helps visually analyze data by changing cell colors, fonts, or styles.
Example: Highlighting values above 100 in green automatically.
9. What is a Pivot Table and why is it used?
A Pivot Table is a tool in Excel used to summarize, analyze, and organize large data sets.
It allows you to group, filter, and calculate data dynamically.
Pivot Tables are useful for quick data insights and reporting.
10. How do you protect a worksheet or workbook in Excel?
To protect a worksheet or workbook, go to the Review tab and click Protect Sheet or Protect Workbook.
Set a password if desired to restrict changes.
This helps prevent unauthorized editing or structure changes.
Situation Based or Practical Questions
1. How would you remove duplicates from a list in Excel?
To remove duplicates in Excel, first select the range of data.
Go to the Data tab and click on Remove Duplicates.
Choose the columns to check for duplicate values and click OK.
Excel will delete duplicate rows and show how many were removed.
2. Imagine you have sales data. How will you find the total sales per region?
To find total sales per region, first organize your data with Region and Sales columns.
Select the data and insert a Pivot Table from the Insert tab.
Place Region in the Rows area and Sales in the Values area.
The Pivot Table will display the total sales for each region automatically.
3. How would you highlight values greater than a specific number?
To highlight values greater than a specific number, select the desired cells.
Go to the Home tab, click Conditional Formatting, then choose Highlight Cells Rules > Greater Than.
Enter the specific number and choose a formatting style.
Click OK, and the cells meeting the condition will be highlighted.
4. How can you sort data by multiple columns?
To sort data by multiple columns, select your full data range.
Go to the Data tab and click on Sort.
In the Sort dialog box, add levels for each column you want to sort by.
Set the order for each and click OK to apply the multi-level sort.
5. You have a column with names in lowercase. How do you convert them to uppercase?
Use UPPER() function
6. How do you combine data from two columns (e.g., first and last name)?
Use =A2 & " " & B2 or =CONCATENATE(A2, " ", B2)
7. How do you fix an error like #DIV/0! in Excel?
The #DIV/0! error occurs when a number is divided by zero or an empty cell.
To fix it, ensure the divisor is not zero or blank.
You can use the formula =IF(B1=0, “Error”, A1/B1) to handle it safely.
8. How do you insert a chart in Excel?
To insert a chart in Excel, first select the data you want to visualize.
Go to the Insert tab and choose a chart type (e.g., Column, Line, Pie).
Click the desired chart style, and Excel will insert it into your sheet.
9. If a formula is not calculating, what could be the reason?
If a formula isn’t calculating, it could be due to manual calculation mode—switch to automatic under Formulas > Calculation Options.
Another reason might be the formula is entered as text—check for an apostrophe (‘) before the = sign.
Also, ensure cell references and syntax are correct.
Press F9 to force recalculation if needed.
10. How do you freeze panes in Excel and why would you use it?
To freeze panes, go to the View tab and click Freeze Panes, then choose an option like Freeze Top Row or Freeze First Column.
You can also select a specific cell and choose Freeze Panes to lock both rows and columns above and to the left.
This keeps headers or key information visible while scrolling.
Extra Bonus Tips for Interviews
1. Practice using shortcut keys: e.g., Ctrl + Z (undo), Ctrl + Arrow (navigate), Ctrl + Shift + L (filter), etc.
2. Be ready to demonstrate tasks live (if it’s a practical test).
3. Familiarize yourself with Excel 365 interface (many companies use this version).
Important Shortcuts Interview Questions
1. What is the shortcut to select an entire column or row in Excel?
Answer:
Column: Ctrl + Space
Row: Shift + Space
🔹 2. How do you quickly navigate to the last cell with data in a column or row?
Answer:
Ctrl + Arrow key (Up, Down, Left, or Right)
🔹 3. What is the shortcut to insert the current date or time in a cell?
Answer:
Date: Ctrl + ;
Time: Ctrl + Shift + :
🔹 4. How can you apply a filter to a dataset using a shortcut?
Answer:
Ctrl + Shift + L
🔹 5. How do you autofill cells quickly without dragging the fill handle?
Answer:
Double-click the fill handle (bottom-right corner of the cell).
🔹 6. What’s the fastest way to copy a formula down a column?
Answer:
Select the cell with the formula, press Ctrl + C, then select the range and press Ctrl + V, or double-click the fill handle.
🔹 7. How can you quickly hide or unhide columns or rows?
Answer:
Hide column: Ctrl + 0
Hide row: Ctrl + 9
Unhide: Ctrl + Shift + 0 or Ctrl + Shift + 9 (depending on Excel version and system settings)
🔹 8. What shortcut is used to open the Format Cells dialog box?
Answer:
Ctrl + 1
🔹 9. How do you repeat the last action performed in Excel?
Answer:
F4
🔹 10. What trick can you use to quickly highlight all blank cells in a selection?
Answer:
Select range → Press Ctrl + G → Click Special → Choose Blanks → Click OK
Conclusion
Excel interview questions help freshers showcase their data handling and problem-solving skills, which are essential in most corporate roles. Preparing for these questions builds confidence, strengthens foundational knowledge, and improves efficiency in real-world tasks. Understanding Excel basics and shortcuts gives freshers a competitive edge during job interviews and beyond.
FAQs on Excel Interview Questions
1. What type of Excel questions are asked in interviews for freshers?
You can expect questions related to basic Excel functions (like SUM, AVERAGE), formatting, formulas, data handling (sorting/filtering), and simple problem-solving using functions like IF and VLOOKUP.
2. Is Excel important for all job roles?
Yes, Excel is used in many roles including data entry, finance, marketing, HR, and operations. It’s a basic yet powerful tool for organizing and analyzing data efficiently.
3. Do I need to know advanced Excel for a fresher role?
Not necessarily. For most fresher roles, a strong understanding of basic to intermediate Excel skills is enough. However, learning advanced features like Pivot Tables and VLOOKUP can give you an edge.
4. How can I practice Excel before an interview?
You can practice using free Excel templates, YouTube tutorials, Excel practice websites, or by replicating common office tasks like creating expense sheets or reports.
5. Will there be a practical test during the interview?
Some companies do include a short Excel test to assess your hands-on skills. This might involve using formulas, sorting data, or creating a simple chart.
6. What are the most common Excel functions I should know?
Key functions:
SUM, AVERAGE, MIN, MAX IF, VLOOKUP, HLOOKUP COUNT, COUNTA, LEN, CONCATENATE NOW(), TODAY()
7. Should I memorize Excel formulas?
Understanding how and when to use them is more important than memorizing. Practice using them in real scenarios to build confidence.
Read more popular post >
Explain what excel is – Everyone need to know
What are spreadsheets? Know its Importance
What is digital template? How to earn money from its
What is the Difference between Row and Column in Excel
Loan Interest and EMI Calculator in Excel
Useful Practical MIS Excel Formulas : Editable Spreadsheet
Automatic PO Result By Excel Check Box Formula
Age Calculator in Excel Template – Year, Month, Days, Hours, Minute, Week
