Skip to content
New Milap Nagar, Ambala City

← Learning Blog

Excel Interview Questions for Freshers with a Practical Test

By PHP Training in Ambala

Prepare for an Excel interview by working through a small spreadsheet from start to finish. Interviewers may ask you to explain how you wrote a formula, checked a report or fixed messy data. This exercise gives you examples you can talk through and verify on your own.

Excel interview questions for freshers

When would you use SUMIF?

Use SUMIF to total numbers that match one condition, such as revenue for the East region. Use SUMIFS if you also need to match a product or another condition.

What is the difference between A2 and $A$2?

A2 moves when you copy a formula. $A$2 stays fixed. Use a fixed reference for a tax rate or a target percentage stored in one cell.

When would you build a PivotTable?

Use it to group rows and summarise values, such as total revenue for each region. Give every source column a header, keep the number columns numeric and refresh the PivotTable after editing the source values.

How do you look up a product price?

In versions that support XLOOKUP, search for the product name in a price list and return its price. In older versions, use an exact-match VLOOKUP with the product in the first column of the lookup range.

How do you check a spreadsheet before sharing it?

Look for blank required fields, duplicates and inconsistent names. Check that number columns are stored as numbers. Compare the grand total against an independent total or manually check a few rows.

Practical Excel interview test

Copy the five source columns into cells A1:E7. Leave the sixth column for your calculations. Give yourself 15 minutes and explain one formula aloud when you finish.

Practice sales data
Sale Region Product Units Unit Price Revenue
1 East Notebook 12 50  
2 West Mouse Pad 8 75  
3 East USB Cable 5 120  
4 North Notebook 10 50  
5 West USB Cable 6 120  
6 East Mouse Pad 4 75  
  1. Calculate revenue for every sale and the grand total.
  2. Find total revenue for the East region.
  3. Count how many sales have at least eight units.
  4. Build a PivotTable showing revenue by region and identify the region with the highest revenue.

Answer key

  • Enter =D2*E2 in F2 and fill down to F7. The results are 600, 600, 600, 500, 720 and 300. =SUM(F2:F7) returns 3,320.
  • =SUMIF(B2:B7,"East",F2:F7) returns 1,500. Microsoft’s SUMIF reference.
  • =COUNTIF(D2:D7,">=8") returns 3.
  • Use A1:F7 as the source, place Region in Rows and set Revenue in Values to Sum. East leads with 1,500, followed by West at 1,320 and North at 500.

For a follow-up challenge, make a bar chart from the regional totals. In a mock interview, explain how you would check that the chart and PivotTable still agree after a price changes.

For more spreadsheet exercises, explore the Advanced Excel course in Ambala or ask about the current course syllabus.