Computer Science, asked by Harishtopper3867, 6 hours ago

Write two examples of each type of functions you have learnt? Show the way how they can be used in Excel.

Answers

Answered by anjalivashisthvk2
9

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], …)

Similar questions