Don't let tricky interview questions catch you off guard. Master these essential Excel formulas to impress potential employers and land that dream job.
Share your favorite Excel formula in the comments below!
Here are some of the must-know Excel formulas for freshers in 2023 that you can use during interviews:
Formula:1. SUM Formula
is a normal arithmetic addition function that just adds cells or a range of cells present in the Excel file provided to the sum. It does not have any criteria. It's just adding multiple cells or ranges provided to evaluate.
Syntax = SUM (C2,C3,C4,C5)
2. SumIF Formula
A sum function is a normal arithmetic addition function with an if function and holds good for one if criteria based on that sum will be evaluated.
Syntax = SUMIF (A2:A7,“Items wanted”, D2:D7)
Know more Types of SUM functions in Excel
3. Average Formula:
Average is an ordinary arithmetic Average function that just calculates Average cells or a range of cells present in the Excel file provided to the Average. It does not have any criteria. It's just adding multiple cells or ranges provided to evaluate.
Syntax = Average (C2,C3,C4,C5)
4. COUNTIF Formula:
The count is a normal Count cell or a range of cells present in the Excel file provided to the Count. It does have criteria. It's just doing the Count of multiple cells or range provided to evaluate.
Syntax COUNTIF (D2:D7, “Function”)
Know more types of Count Functions in Excel
5. Concatenate Function:
Joins several text items into one text item. The CONCATENATE function in Excel allows you to join two or more text strings into one. For example, you can use this function to combine the first and last names of your customers or to create product codes from different attributes. The syntax of the
Syntax = CONCATENATE function is: =CONCATENATE(text1, text2, ...)
where text1, text2, ... are the text strings that you want to join. You can enter up to 255 text arguments for this function. You can also use the ampersand (&) operator instead of the CONCATENATE function to join text strings. For example: =A1 & " " & B1 will produce the same result as:
Syntax = CONCATENATE (C4,Text, D4, Text,…)
6. Int Function:
The Int function in Excel returns the integer part of a number by rounding it down to the nearest integer. For example, Int(3.7) returns 3, and Int(-2.3) returns -3. The Int function can be useful when you want to extract the whole number from a decimal value, such as a price or a percentage.
Syntax int (this number)
7. MAX Formula: =Max (D2:D7)
The MAX function in Excel returns the largest value from a set of numbers. It can be used to compare values across different ranges, worksheets, or workbooks. The syntax of the MAX function is:
Syntax =MAX(number1, [number2], ...)
where number1, number2, ... are the numbers or references to the cells that contain numbers. You can enter up to 255 arguments in the MAX function. If any argument is non-numeric, it is ignored
The FACT function in Excel is a mathematical function that returns the factorial of a given number. The factorial of a number is the product of all positive integers less than or equal to that number. For example, the factorial of 5 is 5 x 4 x 3 x 2 x 1 = 120. The syntax of the FACT function is:
where the number is a positive integer or a cell reference containing a positive integer. If the number is not an integer, it is truncated. If the number is negative or greater than 170, the FACT function returns an error value.
Syntax = FACT (number)
9. Look up Formula
The LOOKUP function in Excel is a versatile tool that can help you find data in a range or table. It can also return the value from a different column in the same row as the lookup value. The syntax of the LOOKUP function is:
=LOOKUP(lookup_value, lookup_vector, [result_vector])
where lookup_value is the value you want to find, lookup_vector is the range or array where you want to look for the value, and result_vector is the range or array from which you want to return a value. If result_vector is omitted, the LOOKUP function will return the value in the same position as the lookup_value in the lookup_vector.
10. IF function formula
The IF function in Excel is a logical function that allows you to test a condition and return different values based on whether the condition is true or false. The syntax of the IF function is:
=IF(logical_test, value_if_true, value_if_false)
where logical_test is any expression that can be evaluated as true or false, value_if_true is the value to return if the logical_test is true, and value_if_false is the value to return if the logical_test is false.
For example, you can use the IF function to check if a student's grade is above or below a certain threshold and assign a pass or fail result accordingly. The formula would look something like this:
=IF(B2>=60, "Pass", "Fail")
where B2 is the cell containing the student's grade. This formula will return "Pass" if the grade is 60 or higher, and "Fail" if the grade is lower than 60.
-----------------------------------------------------------------------------------------------------------------------------
You may also be interested in knowing
400+ Excel Functions list with detailed descriptions.
Test our mock simple Excel Q&A and test your knowledge today.!
0 Comments
Please do not spam