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

What is Manual Testing

https://www.youtube.com/watch?v=FeihVtO8GBM Manual Testing  is a process carried by testing team to find the defects  and to confirm that application works as per the requirements. Testers manually execute test cases without using any automation tools. Tester plays an important role as end user and verify all features of the application work as per requirements. Identify any unexpected behavior or bug 100% automation is impossible In Manual testing the designed test cases or test scenarios will be executed and any differences between actual and expected results are reported as defects. Once the reported defects are fixed, the testers will retest the defect to make sure that the defects are fixed It is preferable to execute User Interface test cases using manual testing. Manual testing is slower than automation. Running tests manually can be very time consuming.
Read more

What is Black Box Testing

https://www.youtube.com/watch?v=KmbtBuEOLIs&feature=youtu.be It is a software testing techniques in which functionality of the software under test is tested, without reference to the internal structure of the component or system. Tests are based  entirely on requirements and specifications Black Box Testing Software Test Life Cycle  (STLC) Requirements- Test Planning  & Analysis - Test Cases and Test Script Design- Test Execution
Read more