BASIC FUNCTION

SUM : The SUM function in Excel is used to add up a range of numbers. It calculates the total sum of the specified values.

• sum task file 1 

• sum task file 2

• sum task file 3

• sum task file 4

• sum task file 5

• sum task file 6

• sum task file 7

• sum task file 8

MAX : The MAX function is used to find the maximum value in a range of cells. It identifies the highest value among the given set of numbers. 

• Max Task File  1

• Max Task File  2

• Max Task File  3 

• Max Task File 4

MIN : The MIN function is the opposite of the MAX function. It is used to find the minimum value in a range of cells. It identifies the lowest value among the given set of numbers.

• Min Task File  1

• Min Task File  2

• Min Task File  3 

• Min Task File 4

AVERAGE : The AVERAGE function calculates the average or mean value of a range of numbers. It adds up all the values and divides the sum by the count of numbers in the range. 

• Average Task File 1

• Average Task File 2

• Average Task File 3

• Average Task File 4

PRODUCT : The PRODUCT function is used to multiply a range of numbers together. It calculates the product of all the values in the specified range.

• Product task file 1

• Product task file 2

• Product task file 3

• Product task file 4

• Product task file 5

• Product task file 6

PERCENTAGE : The term “percentage” does not refer to a specific function in Excel. However, you can use mathematical operations in combination with cell references to calculate percentages. 

• Percentage Task File 1

• Percentage Task File 2

• Percentage Task File 3

• Percentage Task File 4

• Percentage Task File 5