[go: up one dir, main page]
Scribd
Upload
28 views1 page

Essential Excel Functions Explained

The document outlines important Excel functions including SUM, AVERAGE, IF, VLOOKUP, HLOOKUP, INDEX, MATCH, CONCATENATE, NOW, and COUNTIF. Each function is described with its purpose and an example of its usage. These functions are essential for performing various calculations and data manipulations in Excel.

Uploaded by

samiroutaleb26
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
28 views1 page

Essential Excel Functions Explained

The document outlines important Excel functions including SUM, AVERAGE, IF, VLOOKUP, HLOOKUP, INDEX, MATCH, CONCATENATE, NOW, and COUNTIF. Each function is described with its purpose and an example of its usage. These functions are essential for performing various calculations and data manipulations in Excel.

Uploaded by

samiroutaleb26
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Important Excel Functions

Function: SUM
Description: Adds all the numbers in a range of cells.
Example: =SUM(A1:A5)

Function: AVERAGE
Description: Returns the average (arithmetic mean) of the arguments.
Example: =AVERAGE(B1:B10)

Function: IF
Description: Performs a logical test and returns one value for TRUE and another for FALSE.
Example: =IF(A1>10, "Yes", "No")

Function: VLOOKUP
Description: Looks for a value in the first column of a range and returns a value in the same row from an
Example: =VLOOKUP(1001, A2:C10, 2, FALSE)

Function: HLOOKUP
Description: Searches for a value in the top row of a table and returns a value in the same column from
Example: =HLOOKUP("Q1", A1:D4, 2, FALSE)

Function: INDEX
Description: Returns the value of a cell at the intersection of a particular row and column in a given rang
Example: =INDEX(A1:C3, 2, 3)

Function: MATCH
Description: Returns the relative position of an item in an array that matches a specified value.
Example: =MATCH(39, B1:B10, 0)

Function: CONCATENATE
Description: Joins several text strings into one text string.
Example: =CONCATENATE(A1, " ", B1)

Function: NOW
Description: Returns the current date and time.
Example: =NOW()

Function: COUNTIF
Description: Counts the number of cells that meet a criterion.
Example: =COUNTIF(A1:A10, ">5")

You might also like