Question

Write any ten Microsoft Excel functions along with examples
-​

Answer 1

Listing of the most useful Microsoft Excel functions. Explanations on how to write each function in Excel and examples of its use are provided.

Mathematical Functions

SUM - Adds up all the values in a range

SUMIF - Adds all the values in a range that meet specific critera

SUMIFS (2007+) - Adds values in a range based on multiple criteria

SUMPRODUCT - Sum a range of cells that meet multiple criteria

ROUND - Round a number to a specified number of digits

ROUNDUP - Round a number up to a specified number of digits

ROUNDDOWN - Round a number down to a specified number of digits

CEILING - Round a number up to a multiple of significance

FLOOR - Round a number down to a multiple of significance

Statistical Functions

COUNT - Counts all the values in a range

AVERAGE - Calculates the average number from a range of values

MAX - Finds the maximum value in a range

MIN - Finds the minimum value in a range

COUNTA - Counts all non-empty cells in a range

COUNTBLANK - Counts all blank cells in a range

COUNTIF - Counts all the cells in a range that meet specific critera

COUNTIFS (2007+) - Counts all the cells in a range that meet multiple criteria

AVERAGEIF (2007+) - Calculates the average of a range of values that meet specific criteria

AVERAGEIFS (2007+) - Calculates the average of a range of values that meet multiple criteria

LARGE - Return a value dependent upon its ranking in a range of values in descending order

SMALL - Return a value dependent upon its ranking in a range of values in ascending order

RANK - Returns the rank or position of a number within a range of numbers

Text Functions

LEN - Returns the length, in number of characters, of the contents of a cell

REPT - Repeats a character a specified number of times

TRIM - Remove unwanted spaces from cells

LEFT - Extracts a specific number of characters from the start of a cell

RIGHT - Extracts a specific number of characters from the end of a cell

MID - Extracts a specific number of characters from the middle of a cell

Mark me as brainleist