Series Numbering in Google Spreadsheet

Whenever you create a new google spreadsheet it is better to have series numbering listed for each row in column 1. We already have numbering before the 0th column but, if you have a huge pile of data and if somebody asks to check the 1000th row then you can directly search for 1000 in the search to highlight the particular row. Below, I have mentioned different ways to add series numbering in google spreadsheets.

1. Manual: Entering numbers in each row.

2. Use the drag action: Enter the number 1 in the first row of the column(A1) and then add number 2 in the second row of the same column (A2), then point the cursor to the right bottom corner of the number 2 cell to get a + symbol. Now click on it and drag the cursor below to automatically add the number.

3. Incremental Formula:
Add number 1 in the first row of the first column (A1), now in the 2nd row of the first column add the formula as below.

=(A1+1)

Now drag the cursor of the 2nd row below to automatically add the numbers.

Consider you have a scenario where you have to count the number from in between say 1000 then, just change A1 to 1000, it will auto-increment from 1000. Try it.

4. ARRAYFORMULA: Consider you want to add numbers till 1000 rows, it will be quite tiresome to use the dragging cursor action or incremental formula dragging. Although you can do it if you have an ample amount of time, there is an easier way to add the auto numbering to any row. You can use ArrayFormula formula to automatically add the numbers in the sheet. Below is the example to add 5 rows with incremental numbers using ARRAYFORMULA

=ARRAYFORMULA(ROW(A1:A5))

Add the above formula to row A1 and hit enter.

If you want to add numbering till 100 then you just need to change the formula to below

=ARRAYFORMULA(ROW(A1:A100))

Note:

1. If you delete any row from the numbered row then you can observe that the numbering will not be affected, this is not the case when using manual numbering or drag action. Also observe that the formula dynamically changes to A1:A99. Try it.
2. If you want the series numbering to happen for columns then you need to change the formula as

=ARRAYFORMULA(Column(A1:1))

Fun Fact: 
1. You can add 5000000 rows keeping only 1 column in the sheet. I was extremely bored on a Quarantine Sunday and I tried adding 5000000 entries in the sheet to check if the browser would crash. It did a couple of times. Find the google spreadsheet below. Don't blame me if your system gets hanged :D

https://docs.google.com/spreadsheets/d/1TbF7t1Vg18LzHQjGjA72a0-oMbFiwULNG4svVLuSXKg/

2. You can add 18278 columns in one spreadsheet if you keep only 273 row in the sheet. As mentioned previously I tried adding the columns to test how it behaves. Click the link below.

https://docs.google.com/spreadsheets/d/11Yl4Fpg7UXvhNVq9iXVPy6t1UQbi_qK0U9Eh5LVVq8I/

I will make another post for filling sequential text and much more in the coming blog posts.

Google Spreadsheet Introduction - Understanding the spreadsheet

Google spreadsheet has many features which can be used for day to day QA tasks, before moving to how to insert data and formulas to the sheet, let us first understand terminologies which are used in google spreadsheet. If you have not gone through my post on how to create a new google spreadsheet then visit the link below first.

Link: https://qualitytestingtips.blogspot.com/2020/04/google-spreadsheet-introduction.html

Let's start with the most import terminologies used in the spreadsheet. 

Worksheet( Sheet)

Every page in the spreadsheet is called Sheet.

Cell:

Every box in the google spreadsheet is called a Cell.

Rows:

Horizontally displayed cells are called as Row. Rows are represented by numbers on the Y-axis.

Columns: 

Vertically displayed cells are called as Column. Columns are represented by Alphabets on the X-axis

Google Spreadsheet Introduction - Creating a spreadsheet

Google Spreadsheet is a web-based application that was introduced by Google in the Year 2006. Google acquired the software from 2Web Technologies which had originally created the idea of online-based spreadsheets. Google spreadsheet is available in all the browser platforms and as a mobile-based application too.

Google Spreadsheet is a boon to every QA who likes to maintain proper documentation while testing. Earlier I used to use excel sheet for all QA tasks, but I realized that google spreadsheet is much better when you need to share it to different QA's who are required to edit the sheet. It saves time as multiple users can edit the file in the same session. I just have 2 and half years of experience but I am going to make sure I clearly explain each formula with different examples in the coming posts. I would also explain how with simple Javascript knowledge, you can be a better google app-script QA.

Understanding how to access Google Spreadsheets is also necessary if you have never used google spreadsheets. Below are the steps to create a new google spreadsheet.

1. If you have a Gmail account then you can access the google drive by clicking on the link below

Link: https://drive.google.com/drive/u/0/my-drive

If you do not have a Gmail account then you need to create one to access it.

2. Click on the New button.

3. Click on Google Sheets 

4. Voilà! You have successfully created a new google spreadsheet. Congratulations :)

5. You can name your Spreadsheet by clicking on Untitled spreadsheet

6. Type any name as you wish, I have named my spreadsheet as Teaching Google Spreadsheet

Fun Fact: You can add 9500 characters to the name field. But, I have crashed the browser by continuously adding around 2 Lakh characters :D

How do you install an iPa file in iPhone using Xcode software?

iPa file can be installed in iPhone/iPod/iPads using Xcode software in mac system instead of using iTunes application.

Steps to Install the iPa file.

1. Open Xcode application.

2. Under Windows tab you will find Devices option

3. Click on Devices

4. Connect your iPhone/iPod/iPad to the mac system

5. Drag and drop the iPa file under Installed apps

Make sure that the provision profile is updated with the UDID of the device.

Different type of performance testing in software testing.

Listed below are the types of performance testing

1. Load testing: Load testing is a type of performance testing where increasing amount of load is applied to the system to check how the application performs till the threshold limit is reached.

Ex: Consider the system can handle only 1000 users in an application. Initially 10 users are injected and gradually the amount of users are increased till it reaches the threshold of the system i.e 1000 users to check how the system performed under various injected users.

2. Stress testing: Stress testing is a type of performance testing where the amount of load is increased more than the threshold limit in-order to break the system and to check how the application performs.

Ex: Consider the system can handle only 1000 users in an application. More than 1000 users are injected to the system in-order to break the system and to check how the application would respond

3. Volume testing: Volume testing is type of performance testing where particular amount of load is applied to the system to check how the application performs.

Ex: Consider the system can handle only 1000 users in an application. System is tested for 500 users or 900 users to check how the application performs.

4. Soak testing: Soak testing is a type of performance testing where the system is tested over a significant period of time by applying significant load to check how the application behaves.

Ex: Keeping an application for overnight while the data is injected to the system. Consider you have a new application which refreshes the page every-time a new news is added. Keeping the application open and injecting news to check how the application performs.

5. Spike testing: Spike testing is a type of performance testing where the load is suddenly increased and decreased and vice-versa to check how the application performs.

Ex: Consider the system can handle only 1000 users in an application. Load of 900 users is applied and suddenly the load is brought down to 100 and vice versa to check how the system performs

6. Scalability testing: Scalability testing is a type of performance testing where the system is tested once the load of the system is increased to meet the growing need

Ex: Consider the system can handle only 1000 users in an application. Now due to the application is getting used by more than 1500 in an year the system is now made to handle 1500 users.