Write two examples of each type of functions you have learnt? Show the way how they can be used in Excel.
Answers
Answer:
Some of the 5 functions are as :-
(i) The SUM Function.
(ii) The AVERAGE Function.
(ii) The COUNT Function.
(iv) The TRIM Function.
(v) The MAX and MIN Function.
Explanation:
(i) The SUM Function :-
The SUM function is the first must-know formula in Excel. It usually aggregates values from a selection of columns or rows from your selected range.
=SUM(number1, [number2], …)
Example:
(a) =SUM(B2:G2) – A simple selection that sums the values of a row.
(b) =SUM(A2:A8) – A simple selection that sums the values of a column.
(ii) The Average Function :-
The AVERAGE function should remind you of simple averages of data such as the average number of shareholders in a given shareholding pool.
=AVERAGE(number1, [number2], …)
Example:
=AVERAGE(B2:B11) – Shows a simple average, also similar to (SUM(B2:B11)/10)
(iii) The COUNT Function :-
The COUNT function counts all cells in a given range that contain only numeric values.
=COUNT(value1, [value2], …)
Example:
(a) COUNT(A:A) – Counts all values that are numerical in A column. However, you must adjust the range inside the formula to count rows.
(b) COUNT(A1:C1) – Now it can count rows.
(iv) The TRIM Function :-
The TRIM function makes sure your functions do not return errors due to unruly spaces. It ensures that all empty spaces are eliminated. Unlike other functions that can operate on a range of cells, TRIM only operates on a single cell. Therefore, it comes with the downside of adding duplicated data in your spreadsheet.
=TRIM(text)
Example :
TRIM(A2) – Removes empty spaces in the value in cell A2.
(v) The MAX & MIN Function :-
The MAX and MIN functions help in finding the maximum number and the minimum number in a range of values.
=MIN(number1, [number2], …)
Example:
=MIN(B2:C11) – Finds the minimum number between column B from B2 and column C from C2 to row 11 in both columns B and C.
=MAX(number1, [number2], …)