--- description: "Following are the Most Frequently Asked Excel Formulas in an interview 1) SUM formula: =SUM (C2,C3,C4,C5) In excel, SUM formula is used to calculate the total number. For instance here we had calculat" title: Top 10 Excel Formulas Interview Questions and Answers (2026) image: https://www.guru99.com/images/2/sum_formula_1.png --- [Skip to content](#main) Here are Excel Formulas interview questions and answers for fresher as well experienced candidates to get their dream job.   ## Basic Excel Formulas for Interview ### 1) Excel SUM formula: =SUM (C2,C3,C4,C5) In excel, **SUM** formula is used to calculate the total number. For instance here we had calculated the total number of computer items sold across different region in U.S.A by using **formula =SUM (C2,C3,C4,C5)** at the end you get the total $ 20, 500, as shown in next formula. In formula, inside bracket you have to mention the column or row number which you want to add. ![Excel Formula Interview Questions]() ![Excel Formula Interview Questions]() SUM formula [👉 Free PDF Download: Excel Formulas Interview Questions & Answers](#cb336b8ed0) --- ### 2) Excel Average Formula: = Average (C2,C3,C4,C5) In excel, the average formula, is used to retrieve the average for any number. Like we have calculated the average sales of computer merchandise across U.S.A. The first screen shot highlights the formula, i.e., `= Average (C2,C3,C4,C5)` that we have applied for our data. ![Excel Formula Interview Questions]() Average Formula The below screen shot shows the average amount that we retained after applying the formula. --- ### 3) SumIF formula = SUMIF (A2:A7,“Items wanted”, D2:D7) The [SumIF](https://www.guru99.com/sumif-function-excel.html) gives the total number of any items for selected ranges. For instance here we want to calculate only the total sales amount for **software items,** to do that we will apply the formula as `=SUMIF (A2:A7, “software”, D2:D7).` Here A2 and A7 defines the range for software and same way we can find sales amount for hardware. **(A2:A7, “hardware”, D2:D7).** ![Excel Formula Interview Questions]() ![Excel Formula Interview Questions]() Below screen-shot show the total sale amount of hard-ware and soft-ware in the table. ![Excel Formula Interview Questions]() SumIF formula **Don't Miss:** - [How to Open & Convert XML File to Excel](https://www.guru99.com/connecting-microsoft-excel-to-external-data-sources.html) - [How to Create Pivot Table in Excel: Beginners Tutorial](https://www.guru99.com/pivot-tables-in-excel-beginner-s-guide.html) - [Excel VLOOKUP Tutorial for Beginners](https://www.guru99.com/excel-vlookup-tutorial.html) - [8 BEST Microsoft Excel Courses Online with Certificate (2026)](https://www.guru99.com/excel-courses.html) --- ### 4) COUNTIF Formula: COUNTIF(D2:D7, “Function”) COUNTIF function offers wide application; you can apply the formula according. Here we have taken a simple example of COUNTIF function, where our motive is to find the total number of cells whose value is greater than $3000. In order to know that we will apply the formula `=COUNTIF(D2:D7,”3000”).` ![Excel Formula Interview Questions]() Below screen shot shows the total number of cells that has value greater than 3000. ![Excel Formula Interview Questions]() COUNTIF Formula --- ### 5) Concatenate Function: =CONCATENATE(C4,Text, D4, Text,…) Concatenate function is used in excel to connect different segment or text to display as a single sentence. For example, here we want to display text as “NewYork has the highest sale of 12000 dollars”, for that we will use the formula =CONCATENATE(C4,”has the highest sale of”,D4,dollar”). ![Excel Formula Interview Questions]() When you execute the formula and display the text as show in below screen-shot ![Excel Formula Interview Questions]() Concatenate Function --- ## Advanced Excel Formulas for Interview ### 6) Int Formula: int (this number) Int formula is used to remove integer from the number like we have demonstrated over here in below example. ![Excel Formula Interview Questions]() ![Excel Formula Interview Questions]() Int Formula --- ### 7) MAX Formula: =Max(D2:D7) This [excel formula](https://www.guru99.com/introduction-to-formulas-and-functions-in-excel.html) will retain the cells that have the highest value in the column, for example, here we want to know the highest value for computer items, and it retains the value $12000. Likewise, you can execute same formula to get a minimum value, in the formula you have to replace Max with Min. ![Excel Formula Interview Questions]() Below, screen shot shows the highest value in the column. ![Excel Formula Interview Questions]() MAX Formula --- ### 8) Factorial Formula= FACT(number) Factorial formula will return the factorial of the number. To know the factorial number for 3, we use this formula. You can use this formula to know the probability for any number, here we will have factor 3=3x2x1. ![Excel Formula Interview Questions]() ![Excel Formula Interview Questions]() Factorial Formula --- ### 9) VLookup Formula = Vlookup(value, range, and get me value in the column, is my list sorted) [VLookup formula](https://www.guru99.com/excel-vlookup-tutorial.html) is used when you know anyone detail of any object or person and, you retain other formation based on that detail. For example here we have an example of the keyboard, where you know the retail price of the keyboard but you don’t know how much total sale it made in California by selling keyboard. To know that you will use **=Vlookup(20,D2:D7,2,False).** This formula will give you the total sale amount based on the retail price. While applying this formula you have ensure that whatever you are placing as ref, must be unique, for example you are looking for any particular employee with its ID number it should not be allotted to others otherwise it will show an error. ![Excel Formula Interview Questions]() When formula is executed, the total sale amount shown is $2500 ![Excel Formula Interview Questions]() VLookup Formula --- ### 10) IF function formula: IF (E2>2000, correct/Incorrect) Here we have used **IF** function; this function is used when you want to refer whether the following condition met is correct or incorrect. Here we have used “good” as any sales made greater than 2000 should be remarked as good. Likewise, you can set this as “bad”, “correct” or “incorrect”. ![Excel Formula Interview Questions]() Below table shows when we applied our formula it highlighted cell as “good”. ![Excel Formula Interview Questions]() IF function formula These interview questions will also help in your viva(orals) #### Summarize this post with: ChatGPTPerplexityGrokGoogle AI **Stay Updated on AI** **Get Weekly AI Skills, Trends, Actionable Advice.** ##### Sign up for the newsletter Subscribe for Free You have successfully subscribed. Please check your inbox. ![AI-Newsletter]() Chosen by over **350,000+** professionals [Scroll to top](#wrapper) × Search for: ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.guru99.com/#organization","name":"Guru99","sameAs":["https://www.facebook.com/Guru99Official","https://twitter.com/guru99com"],"logo":{"@type":"ImageObject","@id":"https://www.guru99.com/#logo","url":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","contentUrl":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","caption":"Guru99","inLanguage":"en-US"}},{"@type":"WebSite","@id":"https://www.guru99.com/#website","url":"https://www.guru99.com","name":"Guru99","publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https://www.guru99.com/images/2/sum_formula_1.png","url":"https://www.guru99.com/images/2/sum_formula_1.png","width":"200","height":"200","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/excel-formulas-interview-questions.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":"1","item":{"@id":"https://www.guru99.com","name":"Home"}},{"@type":"ListItem","position":"2","item":{"@id":"https://www.guru99.com/excel","name":"Excel"}},{"@type":"ListItem","position":"3","item":{"@id":"https://www.guru99.com/excel-formulas-interview-questions.html","name":"Top 10 Excel Formulas Interview Questions and Answers (2026)"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/excel-formulas-interview-questions.html#webpage","url":"https://www.guru99.com/excel-formulas-interview-questions.html","name":"Top 10 Excel Formulas Interview Questions and Answers (2026)","dateModified":"2024-07-16T20:09:24+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/2/sum_formula_1.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/excel-formulas-interview-questions.html#breadcrumb"}},{"@type":"Person","@id":"https://www.guru99.com/author/charlotte","name":"Charlotte Miller","description":"I am Charlotte Miller, an Excel VBA Developer with over a decade of first-hand experience.","url":"https://www.guru99.com/author/charlotte","image":{"@type":"ImageObject","@id":"https://www.guru99.com/images/charlotte-miller-author.png","url":"https://www.guru99.com/images/charlotte-miller-author.png","caption":"Charlotte Miller","inLanguage":"en-US"},"worksFor":{"@id":"https://www.guru99.com/#organization"}},{"@type":"NewsArticle","headline":"Top 10 Excel Formulas Interview Questions and Answers (2026)","keywords":"interview","dateModified":"2024-07-16T20:09:24+05:30","articleSection":"Excel","author":{"@id":"https://www.guru99.com/author/charlotte","name":"Charlotte Miller"},"publisher":{"@id":"https://www.guru99.com/#organization"},"description":"Following are the Most Frequently Asked Excel Formulas in an interview 1) SUM formula: =SUM (C2,C3,C4,C5) In excel, SUM formula is used to calculate the total number. For instance here we had calculat","copyrightYear":"2024","copyrightHolder":{"@id":"https://www.guru99.com/#organization"},"name":"Top 10 Excel Formulas Interview Questions and Answers (2026)","@id":"https://www.guru99.com/excel-formulas-interview-questions.html#richSnippet","isPartOf":{"@id":"https://www.guru99.com/excel-formulas-interview-questions.html#webpage"},"image":{"@id":"https://www.guru99.com/images/2/sum_formula_1.png"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/excel-formulas-interview-questions.html#webpage"}}]} ```