write the use , syntax and give one example of the following Excel function ? a). sum ( ) b). Count if ( ) c). average ( ) d). min ( ) e.) Exact ( )
Answers
Answer:
yop-wcva-erj interested one i am waiting
Syntax in the English Language: Definition, Examples, and 3 Ways to Use Syntax Effectively. Syntax is the set of rules that helps readers and writers make sense of sentences. It's also an important tool that writers can use to create various rhetorical or literary effects.
examples :-
sum :- =sum(a1+a10) — adds cell A1 and A10.
=sum(a1-a10) — subtracts A1 from A10.
count :- range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.
average :- series of numbers: 1, 2, 3, 4, 1, 2, and 3. The sum of these numbers is 16, 16 divided by 7 is 2.28. Therefore, 2.28 is the average of these numbers.
min :- A1 through A10. If these cells had the values 1, 2, 3, 4, 5, 6, 7, 8, 9, and 10, the result would return "1." This result would occur because 1 is the smallest, or minimum, value in all of the cells.
exact :- Exact numbers are either defined numbers or the result of a count. For example, a dozen is defined as 12 objects, and a pound is defined as 16 ounces. An exact number can only be expressed in one way and cannot be simplified any further. ... Counted numbers are exact: there are two chairs in the photograph.