Excel: Find Sum and Average

https://www.youtube.com/watch?v=kO094RKeQos

Sum

The SUM function, (math and trig function) adds values. You can add individual values, cell references or ranges or a mix of all three.

Syntax: SUM(number1,[number2],...)

  • Number1    mandatory. The first number, cell reference, or range for which you want the Sum.

  • Number2, ...    Optional. Additional numbers, cell references or ranges for which you want the Sum.


Average function returns the Average . It is (Arithmetic mean) of the arguments or values specified.


Syntax


AVERAGE(number1, [number2], ...)

  • Number1    mandatory. The first number, cell reference, or range for which you want the average.

  • Number2, ...    Optional. Additional numbers, cell references or ranges for which you want the average.



Notes:



  • Arguments  can either be numbers or names, ranges, or cell references that contain numbers.

  • Logical values and text representations of numbers that you type directly into the list of arguments are counted.

  • If a range or cell reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included while counting average.

  • Arguments that are error values or text that cannot be translated into number  will return errors.


Comments

Post a Comment

Popular posts from this blog

What is unit testing

https://www.youtube.com/watch?v=h9RvPN3kiHk&feature=youtu.be   Testing of individual software components or units or modules. Typically unit testing is done by the programmer and not by testers. Unit is smallest and complete set of code which accepts input, processes and gives output The primary goal of unit testing is to take the smallest piece of testable software in the application, isolate it from the remainder of the code, and determine whether it behaves exactly as you expect.
Read more

Regression Testing

https://www.youtube.com/watch?v=qaANTCZt20g What is Regression testing? It is a type of software testing that verifies that software performs correctly after the change or defect fix. Changes may include software enhancements, patches, hardware, networking, data structure, configuration changes, etc. In other words purpose of regression testing is to identify that  new defects are not introduced in the system after the change. 2) At what levels regression testing should be done? At all levels mainly Unit Testing, Integration testing and System Testing: Focus on testing is different at different levels. 3) What are the types of Regression testing techniques? Corrective Regression Testing: Progressive Regression Testing: Retest-All Strategy:. Selective Strategy: (dependencies between a test case and the program entities it covers) 4) What should be the frequency of regression testing? Ideally Regression testing should be done after bug fix and after any change to the syste
Read more