Excel

In Excel, we do concatenation or joining of strings by using the CONCAT/CONCATENATE functions. Concatenate in Excel Definition with Formula: These functions concatenate or join two strings together and form a single chain. The strings can be numbers, names etc. Both CONCAT and CONCATENATE in excel work the same. The CONCATENATE function is for old […]

VLOOKUP in Excel Definition with Formula: VLOOKUP in excel means “Vertical LOOKUP”. It means that it helps to look up a value vertically, i.e., in a different column but the same row. In the case of repeated values, the first matched value will return. Formula: VLOOKUP(lookup_value; table_array; col_index_num; [range_lookup]) Lookup Value: It is the given

Index Function in Excel Definition with Formula: The index function in excel returns a value from the table(array). We obtain the value from the intersection of the row number and the column number defined in the formula. The row_num and column_num are according to the array that we choose. Formula: =INDEX(array, row_num, [column_num]) Excel Match

Average Formula in Excel Definition with Formula: The average formula in excel calculates the average of given numbers. Average means the sum of numbers divided by the total numbers. Suppose there are 6 numbers, i.e., a,b,c,d,e,f then Average=(a+b+c+d+e+f)/6 To make the above calculation easy, we use the average formula in excel. Formula: =AVERAGE(number1, [number2],..) The

Excel Date Formula Definition: The Excel Date Formula returns a serial number that represents a particular date. While using excel, this is the correct way of providing a date. Formula: DATE(year, month, day) Explanation with Example Questions: Today’s a sunny and bright day. Brenda decided to teach her children about the excel date formulas. She

Percentage in Excel Definition with Formula: As the name suggests, per cent means “per 100”. A percentage in Excel means a number that expresses as a fraction of 100. Formula= (Sum of marks obtained/ Total marks)*100 Explanation with Example Questions: Carly is very nervous on the way home as her result is not the way

Division Formula in Excel Definition with Formula: There is no particular formula for the divide in excel. But we can use the divide symbol in excel, “/” for this purpose. Formula: number1/number2 Explanation with Example Questions: Today, Brenda decides to teach the division formula in excel to her children. She decides to bake a cake

Excel Multiply Formula Definition with Formula: Excel multiply formula is used to multiply the values. We can multiply the values using the multiply symbol in excel, i.e., “*”. Formula: =number1*number2 Another way of multiplication is using the PRODUCT function. Formula: =PRODUCT(number1, [number2], ….) Explanation with Example Questions: After learning the concept of subtraction in excel,

Subtraction Formula in Excel Definition with Formula: There is no proper subtraction formula in excel. We can minus in excel using the “-” sign. Formula: Value1-Value2 Explanation with Example Questions: After teaching the concept of SUM function to her children, Brenda decides to teach subtraction formulas in excel. She sits in the living room and