Excel trick to jump from worksheet to worksheet
https://www.youtube.com/watch?v=ZzOvUIgq7wk By pressing Ctrl Page up and Page down on your keyboard, you can move from one worksheet to another wokrsheet,
Posts
3 times table trick
https://www.youtube.com/watch?v=8sVKCDHp0ao You write number 1 to 9 in tic toe table and add 1 in front on numbers in the second row and 2 in the third row and you have 3 times table ready.
Create Number sequence using Excel
https://www.youtube.com/watch?v=G0VYpbYu4hk Create number sequence in Excel Select the first cell in the range that you want to fill. Type the starting value for the series and next values in the next cell to establish pattern of sequence. Note: For example, if you want the series 2, 4, 6, 8..., type 2 and 4 in the first two cells. Select the cells that contain the first two values. Drag the fill handle across the range that you want to fill. Note: To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.
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 r...
What is Data Driven Testing
https://www.youtube.com/watch?v=gQF_Zlulk2U Data driven testing is an automation testing, which tests the output and/or input values. These values are read directly from the data files rather than using hard coded values. The data files can be csv files, excel files, text files, data pools etc. Separation of test and data makes tests logically simpler. A test containing several sets of hard-coded values can be rather difficult to modify and maintain. For instance, easy to extend values in data file than to modify test commands. Various inputs can be handled effectively. When the storage contains both input and verifying data, a data-driven test performs following operation in a loop. Retrieving input data from storage Entering data in an application form and stimulates actions Verifying the results Continuing with the next set of input data
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.
What is Software Testing
https://www.youtube.com/watch?v=v548wJC62jE The process of validating and verifying that a software program or application or product work as expected. Software meet the business and technical requirement The only objective of software testing is not to find software bug that exists, but to identify situations that could negatively impact the customer, usability of software.
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
Excel: Find duplicate values
https://www.youtube.com/watch?v=RO53GaLi2pE&feature=youtu.be Find duplicate values in excel using conditional formatting and you can use any color combination you want to identify duplicate values. You can apply conditional formatting to selected cells or to the entire worksheet. Formatting can be cleared by clicking on conditional formatting and clear rules.
Software Testing: Build and Release
https://www.youtube.com/watch?v=aT4O9K6Kq5g&feature=youtu.be Build Build: It is a number given to Installable software that is handed over to testing team by the development team for testing purpose. Build is still in testing phase or may not be tested yet. Build can be rejected by test team if major defect is found or it does not meet the certain requirement Release It is a number given to software that is handed over to customer by the testing team or development team. One Release can have several builds associated with it. A build when tested and certified by the test team is given to the customers as “release”. Release is handed over to Customer after completion of development and testing phase.
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.
Excel convert text to lower case
https://www.youtube.com/watch?v=AltQw4o_qQA&feature=youtu.be lower(text) function converts text to lower case.
Excel: Convert text to upper case
https://www.youtube.com/watch?v=mLcGLdSXEF8 =upper(text) converts text to upper case. All the letters in the word are converted to capital letters.
Excel: Convert text to proper case
https://www.youtube.com/watch?v=6Eipo7oVeqk&feature=share Formula to convert text to proper case =proper(text) Proper case converts first letter into upper case and rest of the letters to lower case for every word.