Training Portal

Top 7 Most Excel Formulas Interview Question & Answers (January 2022)

Top Most Interview Questions About Excel Formulas 2022

What is Excel ?

Microsoft Excel is a Spreadsheet Program. That means it's used to create grids of text, numbers and formulas specifying calculations. That's extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.

Top Interview Question About Excel Sheet

1)  SUM Formula = SUM (D2, D3,D4,D4,D5,D6)






2)  Average Formula =AVERAGE(D2, D3,D4,D4,D5)



3)  COUNTIF Formula =COUNTIF (D2:D6, "Function")

We have simple example for COUNTIF,

To find the total number of cells which value is greater than 2000, So that we can apply the formula 
=COUNTIF(D2:D6,">2000").




The Result 2, which means 2 Values are greater than 2000.



4)  Concatenate Formula - 

The CONCATENATE function allows you to combine text from different cells into one cell. In our example, we can use it to combine the text in column A and column B to create a combined name in a new column.

Example

We would say the purpose of CONCATENATE is Join Text Together



5) Int Formula : int (This Number)

Int formula is used to remove integer from any value which we highlight before apply





6) MAX Formula = Max(D27:D31)

This formula used to find out highest value in the column.

For example,




7) VLookup Value Formula